The following table lists the fields available for import or export, with a brief description of the field and (when necessary) a character limit for the field. The Import? column identifies which fields are available for import (all are available for export). The Required column shows those fields that must be provided.
Note: Inventory Adjustment Journal fields are exported using ADJUST.CSV as the default file name.
|
Field Name |
Import? |
Required |
Description of Field |
Limit |
|---|---|---|---|---|
|
Item ID |
Y |
Y |
Alphanumeric – Inventory item ID for the transaction. |
Up to 20 characters |
|
Reference |
Y |
N |
Alphanumeric – Reference for the transaction. |
Up to 20 characters |
|
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". |
Up to 20 characters |
|
Reason to Adjust |
Y |
N |
Alphanumeric - Reason to adjust for the transaction. |
Up to 30 characters |
|
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. |
Up to 15 characters |
|
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. |
Up to 15 characters |
|
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 |
Y |
N |
Numeric (Real) - Unit cost for the line of distribution; it gets ignored for negative inventory adjustments, but gets used for positive inventory adjustments. Note: If this field is not included during import, it is calculated for you based on Quantity and Amount values. |
|
|
Quantity |
Y |
Y |
Numeric (Real) – Quantity for the line of distribution. |
|
|
Amount |
N |
Y |
Numeric (Real) – Amount for the line of distribution 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. |
|
|
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. |
|
|
Serial Number |
Y |
Y |
Alphanumeric - Serial number for a line of distribution. Note: Each serial number will be listed on a separate line. |
Up to 30 characters |