Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Menu Path: Accounting > Maintenance > Configuration > Upload GL Code

Image Removed

Image Removed

 

LetterField NameCompulsory / OptionalDescription
AGL Short HandCompulsoryGL name as display in system / reports ; *Note: Once created, this GL Code may not be changed. ; Only accept alphanumeric, space and char _()/.-
BGL CodeCompulsoryAnother naming for GL, can used previous system GL code for easy referencing ; Only accept alphanumeric, space and char _()/.-
CGL Category CodeCompulsoryMust refer back to system GL Category under Accounting > Maintenance > Configuration, GL Category Maintenance
DGL Code Name 1CompulsoryGL code full name 1 display in reports
EGL Code Description 1OptionalAdditional description for GL code name 1
FGL Code Name 2OptionalGL code alternative name
GGL Code Description 2OptionalAdditional description for GL code name 2
HEORCompulsoryEnd Of Record for the template file

 

...

View file
nameUpload GL Code.ods
height250

...

View file
nameUpload GL Code.csv
height250

...


...

Image Removed
Warning
titleUpload Error Message
Panel

If there is a bulk GL Codes to be added, EMP system also upload GL Code by using CSV file. 

Image Added

Step 1: Click file link 'Download Template File'

Image Added

Notes:

  1. select source fields and add to target fields (You can choose the fields for the information you wish to upload) **The compulsory fields are pre-selected and can not be removed
  2. default format is “comma” delimiter


Step 2: Fill in the data

NoField NameData TypeRemarksWhere to FindSample Data
1GL_CATEGORY_CODEString with Maximum (50) CharactersCompulsoryAccounting > Maintenance > Configuration > GL Category MaintenanceBank2
2GL_CODEString with Maximum (30) CharactersCompulsory
MBB_11223344
3GL_SHORT_HANDString with Maximum (50) CharactersCompulsory
MBB_11223344
4GL_CODE_DESCRIPTION_1String with Maximum (300) Characters


5GL_CODE_DESCRIPTION_2String with Maximum (300) Characters


6GL_CODE_NAME_1String with Maximum (100) Characters


7GL_CODE_NAME_2String with Maximum (100) Characters


Notes:

  • Please make sure the GL Category already exist in the system under GL Category Maintenance
  • To note, once GL SHORT HAND  has been created, it can not be changed , it can only be merged . EMP use GL Short Hand when doing the transaction

Excel sample:

Image Added


Step 3: Save file, save as comma separated values (.csv) format

Image Added

Image Added


Step 4: Upload file

Image Added

Image Added
Sample of Error Message:
  • If the file is not sucessfully uploaded, please refer to the column with RED color background
  • Please move the cursor to the RED color background to see the Error Message
Image Added
  • If this situation happen, please verify and correct the error eg: in the above case, check the GL Category Maintenance and make sure follow the correct code
  • After edit the file, please repeat STEP 4

Related WIKI Pages:
Panel

Search Results
spacekeyWMS
maxLimit5
queryGL
typepage