Item Receipts Fields (QuickBooks Conversion)

The following table outlines which QuickBooks data items are converted to Sage 50 and which are not.

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.
	Remit To:	Since QuickBooks does not display the address on a vendor credit, this field will be populated using the information stored on the vendor record in Sage 50.
	Ship To:	Not converted
Date	Date
Ref. No.	Invoice No.	Sage 50 will append a two-digit number to any duplicate Invoice Numbers.
Total	Total
	Drop Ship	Not converted – Default to unchecked in PT
	Customer ID	Not converted. This field is available in PT when drop ship is selected. QB does not allow drop shipments from the receive items screen.
	Customer SO No	Not converted
	Customer Invoice No	Not converted
Terms	Terms
	Ship Via	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	Not converted. This is a 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	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