...
- Header row- This corresponds to the Post Date (Column B), Currency (Column C), Reverse Date (Column D) and Journal Description (Column E) fields of the General Journal screen.
Image Added
Image Removed
Image Added
Image Removed
The word 'Header' is required in the A column so that system can determine if it is importing multiple journal records like what is shown below.Image Removed
2. Detail row(s) - This row consists of following columns:
...
Expand |
---|
|
Column | Data | Length | Special Processing Notes: | A | Year | 4 | i.e. 2009 If column A and/or column B are left blank, the program will use the date in column G to get the Year and determine the Period. | B | Period | 2 | i.e. 04 | C | G/L Account Number | 17 | Must be formatted as 99999999.99999999 or cross referenced in the Account Translation Maintenance program. | D | Source System | 3 | If blank, the program will use “GJE” as the Source System. | E | Source Number | 5 | Numeric | F | Line Number | 6 | Numeric | G | Date | 8 | Formatted as YYYYMMDD | H | Time | 8 | Numeric, formatted as HH:MM:SS If blank, the program will use the system time. | I | Reference | 25 | Alphabetic | J | Document | 25 | Alphabetic | K | Comments | 25 | Alphabetic | L | Debit/Credit | 1 | The value must be either “D” or “C”. | M | Amount | 13 | Formatted as 9(10).99 | N | Units | 17 | Formatted as 9(12).9999 | O | Correction | 1 | The value must be either “Y” or “N” |
|
Sample Import File Import GL from csv sample.csv |