Vendor Credit Memo 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.

Date

Date

Ref. No.

Credit No.

Sage 50 will add a two-digit number to duplicate Ref. Numbers found in QuickBooks.

Credit Amount

Credit Total

Terms

This information will be populated using the terms for the associated vendor record.

Return Authorization

Not converted

A/P Account

ITEMS TAB

APPLY TO INVOICE NO. TAB

Item

Item

Description

Description

Sage 50 will convert only the first 160 characters.

Returned

Not converted

GL Account

U/M

Not converted

Quantity

Quantity

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. This column is displayed for a QuickBooks credit but is not accessible to the user.

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 set to 1.

Unit Price

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