Purchase Order 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. |
|
Name/Address |
Remit To: |
|
|
Ship To |
Ship 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 |
|
Date |
Date |
|
|
P.O. No. |
PO No. |
Sage 50 will append a two-digit number to any duplicate PO Numbers. |
|
Drop Ship |
Converted when the Ship To field in QuickBooks is populated. Checkbox in Sage 50 is marked as true. |
|
|
Ship To |
Customer ID |
|
|
Good Thru |
Use the Sage 50 default when setting the Good Thru date in Sage 50. The default in Sage 50 is 30 days past the transaction date. |
|
|
FOB |
Not converted |
|
|
Close PO |
Not converted |
|
|
Other 1 |
Not converted |
|
|
Customer SO No |
Not converted |
|
|
Customer Invoice No |
Not converted |
|
|
Discount Amount |
Not converted |
|
|
Ship Via |
Ship Via |
|
|
Terms |
Terms |
|
|
Due Date |
||
|
A/P Account |
||
|
Account Number |
Not converted |
|
|
Project/Job |
Converted in the Job field of the line items below. |
|
|
Other 2 |
Not converted |
|
|
Custom Fields |
Not converted |
|
|
Discount |
Not converted |
|
|
Service Date |
||
|
Item |
Item |
|
|
Description |
Description |
Sage 50 will convert only the first 160 characters. |
|
GL Account |
||
|
Man. Part Num |
Not converted |
|
|
U/M |
Not converted |
|
|
Quantity |
Quantity |
|
|
Backordered |
Not converted |
|
|
Received |
Received |
|
|
Other 1 |
Not converted |
|
|
Other 2 |
Not converted |
|
|
Rate |
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 |
|
Color |
Not converted |
|
|
Material |
Not converted |
|
|
Vendor Message |
Notes |
The Vendor Message in QuickBooks will be converted to a Vendor Note in Sage 50. It will be set to print “After Line Items”. |
|
Total |
Purchase Order Total |
|
|
To be Printed |
Not converted |
|
|
To be emailed |
Not converted |