Description |
When the user imports a file from a csv and the file fails and the results of the failure are given it is essential that the user sees the data that has been translated from their file to be imported - if not they will not be able to diagnose the issue. so the grid on failure should show all columns of data that were translated.
You see currently only period, source system, source number are the only columns listed - all columns in the import should be listed and the data that was translated to them should be listed
all 15 columns in the import and the data you have should be displayed in the log.
| *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{color:#ff0000} HH:MM:SS {color} 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”
|
!pastedImage_d31730_0.png!
|