Vendor Payment 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 |
|---|---|---|
|
Pay to the Order of (Vendor/Customer ID/Other Lists ID) |
Pay to the Order of (Vendor ID/Customer ID) |
Maps the Vendor or Customer ID. This field is limited to 41 characters. |
|
Address |
Pay to the order of Address: Name Address Line 1 Address Line 2 City State Zip Country |
Line 1 will be converted into the 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 |
|
|
No. |
Check No. |
Duplicate check numbers will be appended with –nn. |
|
Ref. No. |
Check No. |
The name changes when it’s a credit card charge as opposed to a check. Sage 50 will append the reference number to begin with CC to indicate that the payment was a credit card charge. |
|
Amount |
Amount |
|
|
Memo |
Memo |
This field will be limited to the first 30 characters. |
|
Credit Card |
Cash Account |
This field is converted based on the transaction in QuickBooks. For Write Checks, this field is pulled from “behind the scenes.” For Credit Card, it is pulled from the field on the screen. |
|
Expenses TAB (write checks) |
APPLY TO EXPENSES TAB |
|
|
Account |
GL Account |
|
|
Amount |
Amount |
|
|
Memo |
Description |
Only the first 160 characters will be 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 convert and the job field will be blank for the line item in Sage 50. |
|
Billable |
Not converted |
|
|
Quantity |
Not converted |
|
|
Item |
Not converted |
|
|
U/M |
Not converted |
|
|
Unit Price |
Not converted |
|
|
Items TAB (write checks) |
APPLY TO EXPENSES TAB |
|
|
Account |
GL Account |
|
|
Amount |
Amount |
|
|
Description |
Description |
Only the first 160 characters will be 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 convert and the job field will be blank for the line item in Sage 50. |
|
Billable |
Not converted |
|
|
QTY |
Quantity |
|
|
Item |
Item |
The Item ID will be updated with list conversion. |
|
U/M |
Not converted |
|
|
Cost |
Unit Price |
|
|
PO No. |
Not converted |
|
|
Bill Payment |
APPLY TO EXPENSES TAB |
|
|
Pay |
Pay |
|
|
Date Due |
Date Due |
|
|
Vendor |
Not converted |
|
|
Ref. No |
Invoice |
|
|
Bill Amt |
Amount Due |
|
|
Amt. Due |
Not converted |
|
|
Amount of Discount |
Discount |
|
|
Disc. Date |
Not converted |
|
|
Amt. Paid |
Amount Paid |
|
|
Discount Account |
Discount Account |