Inventory Adjustments Journal Fields (Import/Export)

Item ID

Y

Y

Alphanumeric – Inventory item ID for the transaction.

Reference

Y

N

Alphanumeric – Reference for the transaction.

Date

Y

Y

Date - Date of the transaction. Must be in ##/##/## (month/day/yr) format.

Job ID

Y

N

Alphanumeric - Job ID for the line of distribution. (Sage 50 Premium Accounting and higher)

Note: When importing any combination of jobs, phases, or cost codes, you must separate the items with commas and enclose the entire string with quotes. For example: "jobid,phase,costcode".

Reason to Adjust

Y

N

Alphanumeric - Reason to adjust for the transaction.

Inventory Account

N

<N/A>

Alphanumeric - Inventory account number for the transaction retrieved from the Inventory item list during the import process. This field is used for exporting only.

Amount Adjusted

N

<N/A>

Numeric (Real) - Net inventory amount for the transaction calculated during the import process. A positive amount denotes a debit, while a negative amount denotes a credit. (This field is used for exporting only.)

Inv Acnt Date Cleared in Bank Rec

Y

N

Date - If the transaction used an inventory account and was cleared in bank reconciliation, then this is the date it cleared. Otherwise, leave blank or exclude this field. Must be in ##/##/## (month/day/yr) format.

Number of Distributions

Y

Y

Numeric (Whole) – Number of distributions in the transaction; in this case, it's always the number 1.

G/L Source Account

Y

Y

Alphanumeric - G/L source account number for the line of distribution. Typically, the cost of sales account.

GL Date Cleared in Bank Rec

Y

N

Date - If the General Ledger account used on a chosen distribution was cleared in bank reconciliation, then this is the date it cleared. Otherwise, leave blank or exclude this field. Must be in ##/##/## (month/day/yr) format.

Unit Cost

N

N

Numeric (Real) - Unit cost for the line of distribution; This field is ignored during the import process, so should be used for exporting only.

Quantity

Y

Y

Numeric (Real) – Quantity for the line of distribution. A negative quantity triggers a reversal to the Amount field on import.

Amount

Y

Y

Numeric (Real) – Amount for the line of distribution calculated during the import process. This amount is designed to be a credit for the source account, which is usually a COS account. As such, the amount field should always be set to negative on importing. A negative Quantity on import is what triggers a needed debit amount.

A positive amount denotes a debit, while a negative amount denotes a credit. This field is used for exporting only.

Transaction Period

N

<N/A>

Numeric (Whole) – Period number for the transaction. Used in conjunction with the Transaction number to identify where a transaction (which is composed of several lines of distribution) begins and ends.

Transaction Number

N

<N/A>

Numeric (Whole) – Transaction number for the transaction. Used in conjunction with the period number to identify where a transaction (which is composed of several lines of distribution) begins and ends.