Menu Path: Supplier > Supplier Invoice > Upload Supplier Invoice
Beside create supplier invoices one by one, the Upload function gives user bulk operation option. Follow the EMP menu path, the user can find the function.
- To Upload Supplier Invoice, Download the 'Upload Supplier Invoice Template' first. Fill in the template and then save the document into .CSV format. If user can not find saving to CSV function in Microsoft Office, download a free OpenOfffice will can.
- Can get the step by step user guide from EMP system by clicking the file 'Upload Supplier Invoice User Guide'.
- Click 'Submit' to upload the selected file.
Template Field Description:
...
Step 1: Click file link: 'Upload Supplier Invoice Template'
Notes:
- select source fields and add to target fields (The compulsory fields are pre-selected and can not be removed)
- default format is “comma” delimiter
Step 2: Fill in the data
| No | Field Name | Data Type | Remarks | Where to Find | Sample Data |
|---|---|---|---|---|---|
| 1 | BRANCH_CODE | String with Maximum (50) Characters | Compulsory | Control Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code" | |
| 2 | DEBIT | Floating Point Number | Compulsory | ||
| 3 | GL_SHORT_HAND | String with Maximum (50) Characters | Compulsory | Accounting > Maintenance> Configuration > View GL Code or Supplier > Supplier Invoice > Supplier Invoice Create > Type on GL Code Column | |
| 4 | REFERENCE_NO | String with Maximum (100) Characters | Compulsory | ||
| 5 | SINV_DATE | String in the following format (yyyy-mm-dd) | Compulsory | ||
| 6 | SUPPLIER_ID | Integer | Compulsory | Supplier > Maintenance > Supplier Listing or Procurement > Transactions > Direct Receiving Stock > Select Supplier | |
| 7 | DATE_SRC_DOC | String in the following format (yyyy-mm-dd) | Refer to Source Document Date → optional date as per usage. E.g: can be use as additional date column for document received date | ||
| 8 | DUE_DATE | String in the following format (yyyy-mm-dd) | Optional date → Default date is 001-01-01 | ||
| 9 | GL_DIMENSION_CODE | String with Maximum (50) Characters | |||
| 10 | GL_DIMENSION_CODE_ITEM | String with Maximum (50) Characters | |||
| 11 | GL_DIMENSION_ID | Integer | |||
| 12 | GL_DIMENSION_ID_ITEM | Integer | |||
| 13 | ITEM_BRANCH | String with Maximum (50) Characters | Key in Same as BRANCH_CODE | ||
| 14 | ITEM_REFERENCE_NO | String with Maximum (100) Characters | |||
| 15 | ITEM_REMARKS | String with Maximum (300) Characters | |||
| 16 | REMARKS | String with Maximum (100) Characters | |||
| 17 | TAX_CODE | String with Maximum (100) Characters | |||
| 18 | TAX_RATE | Floating Point Number |
Excel sample:
Step 3: Save file, save as comma separated values (.csv) format
Step 4: Upload file
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
- If this situation happen, please verify and correct the error eg: in the above case, edit the Supplier and put the default GL Code
- After edit the supplier, please repeat STEP 4
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|