Inventory Adjustment 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 |
|---|---|---|
|
Adjustment Date |
Date |
|
|
Ref. No. |
Reference |
Sage 50 will append a two-digit number to any duplicate reference numbers. |
|
Adjustment Account |
GL Source Account |
|
|
Customer;Job |
Job |
The job will be converted to the job field in Sage 50. If no job is selected in QuickBooks or the field is populated with only a customer instead of a job, the field will not map and the job will be blank in Sage 50. |
|
Item |
Item ID |
|
|
Name |
||
|
Description |
Not converted |
|
|
Current Qty |
Not converted – calculated field |
|
|
New Qty |
Adjust Quantity By: |
|
|
Qty Difference |
Not converted – calculated field |
|
|
Current Value |
Not converted – calculated field |
|
|
New Value |
Unit Cost |
Calculation – Although not required, QuickBooks allows the entry of the total value for the adjustment. If the value has not been adjusted the conversion shall use the unit cost stored with the record. If the value has been adjusted, the conversion will calculate the unit cost. |
|
Value Adjustment (checkbox) |
Not converted |
|
|
Total Value of Adjustment |
Not converted – calculated field in QuickBooks. |
|
|
Memo |
Reason to Adjust: |
Sage 50 will convert only the first 30 characters. |