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) |
...
Overview
Content Tools