Menu Path: Accounting > Maintenance > Configuration > Upload GL Code
| Letter | Field Name | Compulsory / Optional | Description |
|---|---|---|---|
| A | GL Short Hand | Compulsory | GL name as display in system / reports ; *Note: Once created, this GL Code may not be changed. ; Only accept alphanumeric, space and char _()/.- |
| B | GL Code | Compulsory | Another naming for GL, can used previous system GL code for easy referencing ; Only accept alphanumeric, space and char _()/.- |
| C | GL Category Code | Compulsory | Must refer back to system GL Category under Accounting > Maintenance > Configuration, GL Category Maintenance (Refer to GL Category Maintenance) |
| D | GL Code Name 1 | Compulsory | GL code full name 1 display in reports |
| E | GL Code Description 1 | Optional | Additional description for GL code name 1 |
| F | GL Code Name 2 | Optional | GL code alternative name |
| G | GL Code Description 2 | Optional | Additional description for GL code name 2 |
| H | EOR | Compulsory | End Of Record for the template file |
...
- In order to UPLOAD the GL Codes, user needs to fill in the template in an openOffice Calc
- Please download "Upload GL Code Template" (
View file name Upload GL Code.ods height 250
)View file name Upload GL Code.csv height 250 - It is compulsory to use the template attached above, or else the file would not be able to be uploaded
- The Header, Description (1st - 4th row) in the file is not required when upload
- Required to save in CSV format, with the filter settings
Field delimiter: |
Text Delimiter: (Blank)
(Use the | character to separate columns)
| Warning | ||
|---|---|---|
| ||
|
