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. |
|
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. |