Purchase Inventory Fields (QuickBooks Conversion)

QuickBooks Field	Sage 50 Field	Comments
Vendor	Vendor ID	This field will be shortened to 20 characters when the Vendor field in QuickBooks is converted.
Name/Address	Remit To:	Line 1 will be converted into the Vendor name. For Address Lines 1 and 2, Sage 50 will convert the first 30 characters. Only the first 20 characters of the City field will be converted, while the first 12 characters of the Zip Code will be converted. Finally, Sage 50 will convert the first 15 characters of the Country field
	Ship To:	Not converted
Date	Date
Ref. No.	Invoice No.	Sage 50 will append a two-digit number to any duplicate Invoice Numbers.
Amount Due	Total
Bill Due (date)		Not converted
	Drop Ship	Not converted – Defaults to unchecked in Sage 50.
	Customer ID	Not converted. This field is available in Sage 50 when drop ship is selected. QuickBooks does not allow drop shipments from the receive items screen.
	Customer SO No	Not converted
	Customer Invoice No	Not converted
	Ship Via	Not converted
Terms	Terms
Discount Date		Not converted
	A/P Account
Bill Received	Waiting on Bill	When Bill Received in QuickBooks = True, then Waiting on Bill in Sage 50 = False, and vice versa.
ITEMS TAB	APPLY TO PURCHASE ORDER TAB
Item	Item
	Remaining	Calculated field in Sage 50
Description	Description	Sage 50 will convert only the first 160 characters.
	GL Account
	U/M	Not converted
Quantity	Received
Cost	Unit Price
Amount	Amount
Customer	Job	The job, when selected for a line item in QuickBooks, will be converted to the job field in Sage 50 for that line item. If no job is selected in QuickBooks or the field is populated with a customer instead of a job, the field will not map and the job will be blank for the line item in Sage 50.
Billable		Not converted
Time		Not converted
PO No.		Multiple POs can be entered on the same bill in QuickBooks. Sage 50 allows the association of ONE Purchase Order per Purchase. If multiple POs are paid with the same bill in QuickBooks, the conversion will create an individual bill in Sage 50 for each PO listed.

EXPENSES TAB	APPLY TO PURCHASES TAB
	Item	Not converted.
Amount	Amount
Memo	Description	Sage 50 will convert only the first 160 characters.
Account	GL Account
	U/M	Not converted
	Quantity	Not converted. The Quantity field in Sage 50 is automatically set to 1.
	Unit Price	Sage 50 will populate this field with the figure from the QuickBooks Amount field.
Billable		Not converted
Customer	Job	The job, when selected for a line item in QuickBooks, will be converted to the job field in Sage 50 for that line item. If no job is selected in QuickBooks or the field is populated with a customer instead of a job, the field will not map and the job will be blank for the line item in Sage 50.
Memo	Notes	Sage 50 will convert the Memo field in QuickBooks to an Internal Note in Sage 50 and limit the length to 2000 characters.

Vendor

Vendor ID

This field will be shortened to 20 characters when the Vendor field in QuickBooks is converted.

Name/Address

Remit To:

Line 1 will be converted into the Vendor name. For Address Lines 1 and 2, Sage 50 will convert the first 30 characters. Only the first 20 characters of the City field will be converted, while the first 12 characters of the Zip Code will be converted. Finally, Sage 50 will convert the first 15 characters of the Country field

Ship To:

Not converted

Date

Ref. No.

Invoice No.

Sage 50 will append a two-digit number to any duplicate Invoice Numbers.

Amount Due

Total

Bill Due (date)

Not converted

Drop Ship

Not converted – Defaults to unchecked in Sage 50.

Customer ID

Not converted. This field is available in Sage 50 when drop ship is selected. QuickBooks does not allow drop shipments from the receive items screen.

Customer SO No

Not converted

Customer Invoice No

Not converted

Ship Via

Not converted

Terms

Discount Date

Not converted

A/P Account

Bill Received

Waiting on Bill

When Bill Received in QuickBooks = True, then Waiting on Bill in Sage 50 = False, and vice versa.

ITEMS TAB

APPLY TO PURCHASE ORDER TAB

Item

Remaining

Calculated field in Sage 50

Description

Sage 50 will convert only the first 160 characters.

GL Account

U/M

Not converted

Quantity

Received

Cost

Unit Price

Amount

Customer

Job

The job, when selected for a line item in QuickBooks, will be converted to the job field in Sage 50 for that line item. If no job is selected in QuickBooks or the field is populated with a customer instead of a job, the field will not map and the job will be blank for the line item in Sage 50.

Billable

Not converted

Time

Not converted

PO No.

Multiple POs can be entered on the same bill in QuickBooks. Sage 50 allows the association of ONE Purchase Order per Purchase. If multiple POs are paid with the same bill in QuickBooks, the conversion will create an individual bill in Sage 50 for each PO listed.

EXPENSES TAB

APPLY TO PURCHASES TAB

Item

Not converted.

Amount

Memo

Description

Sage 50 will convert only the first 160 characters.

Account

GL Account

U/M

Not converted

Quantity

Not converted. The Quantity field in Sage 50 is automatically set to 1.

Unit Price

Sage 50 will populate this field with the figure from the QuickBooks Amount field.

Billable

Not converted

Customer

Job

The job, when selected for a line item in QuickBooks, will be converted to the job field in Sage 50 for that line item. If no job is selected in QuickBooks or the field is populated with a customer instead of a job, the field will not map and the job will be blank for the line item in Sage 50.

Memo

Notes

Sage 50 will convert the Memo field in QuickBooks to an Internal Note in Sage 50 and limit the length to 2000 characters.