Page History
The format of the file to be imported may be formatted in for a full year or for certain periods of the year.
Period
Typically, this option is used when importing for a single month or only a few months. Formatting requirements are as follows:
| Info | ||
|---|---|---|
| ||
| Column | Data | ||
| A | G/L Account – may be up to 8 numbers | ||
| B | Profit Center – may be up to 8 numbers
| ||
| C | First Period # – must be numeric (next period number in column F) | ||
| D | First Period Data Type (A = Amount or U = Units) – must be capital A or U and must be left justified (next period type in column G) | ||
| E | First Period Budget Amount or Budget Quantity – must be numeric, no commas, decimal not required if whole number, minus sign (-) is required only for credits and may be leading or trailing (next budget amount or quantity in column H) |
...
Full Year
All twelve (or thirteen) general ledger periods will need to be included into the import file. Formatting requirements are as follows:
| Info | ||
|---|---|---|
| ||
| Column | Data | ||
| A | G/L Account – may be up to 8 numbers | ||
| B | Profit Center – may be up to 8 numbers
For instance, if you have Location 2005, add leading zeros to complete the 8 digits total length.
| ||
| C | Data Type (A = Amount or U = Units) – must be capital A or U and must be left justified | ||
| D thru O | Budget Amount or Budget Quantity – must be numeric, no commas, decimal not required if whole number, minus sign (-) is required only for credits and may by leading or trailing |
...
Overview
Content Tools