Upload Supplier Credit Memo
Menu Path: Supplier > Credit Memo > Upload Supplier Credit Memo
Step 1: Click file link: 'Upload Supplier Credit Memo 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" | A Co.-B1 |
| 2 | DATE | String in the following format (yyyy-mm-dd) | Compulsory | 2017-11-25 | |
| 3 | GLCODE | String with Maximum (50) Characters | Compulsory | Accounting > Maintenance> Configuration > View GL Code > GL Short Hand or Supplier > Supplier Invoice > Supplier Invoice Create > Type on GL Code Column | purchaseReturns |
| 4 | ITEM_BRANCH | String with Maximum (50) Characters | Compulsory | Follow Branch_Code | A Co.-B1 |
| 5 | REFERENCE | String with Maximum (100) Characters | Compulsory | SINV3322 | |
| 6 | SUPPLIER_ID | Integer | Compulsory | Supplier > Maintenance > Supplier Listing or Procurement > Transactions > Direct Receiving Stock > Select Supplier | 1006 |
| 7 | AMOUNT_CREDIT | Floating Point Number | Compulsory if AMOUNT_DEBIT empty | ||
| 8 | AMOUNT_DEBIT | Floating Point Number | Compulsory if AMOUNT_CREDIT empty | 500000 | |
| 9 | 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 | ||
| 10 | GLCODE_REMARKS | String with Maximum (100) Characters | |||
| 11 | GLCODE_TAX_CODE | String with Maximum (100) Characters | |||
| 12 | GL_DIMENSION_CODE | String with Maximum (50) Characters | |||
| 13 | INVOICE_PKID_FOR_CONTRA | Integer | Supplier Monitor Outstanding Document > Choose which SINV to contra | 3322 | |
| 14 | RELATED_DOCUMENTS | String with Maximum (50) Characters | Key in "invoice" | invoice | |
| 15 | RELATED_DOCUMENTS_NO | Integer | 3322 | ||
| 16 | REMARKS | String with Maximum (100) Characters |
Notes:
- When the Supplier Credit Memo need to be contra with SINV, please fill up no 13 to 15 for auto contra purpose (after upload)
Excel sample:
Step 3: Save file, save as comma separated values (.csv) format
Step 4: Upload file
Sample of Error Message 1:
- 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, add column for the Debit or Credit amount
- After edit the file, please repeat STEP 4
Sample of Error Message 2:
- If this situation happen, please verify and correct the error eg: in the above case, change the "RELATED_DOCUMENTS" to "invoice"
- After edit the file, please repeat STEP 4
Private & Confidential