Menu Path: Supplier > Supplir Invoice > Supplier Invoice CreateSupplier > Supplier Invoice > Upload Supplier Invoice
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 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|