/
Upload Consignment
Upload Consignment
- Jia Pei Chan
- Farah S Noshirwani (Unlicensed)
Owned by Jia Pei Chan
Menu Path: Distribution > Consignment > Upload Consignment
Step 1: Click file link: 'Download Template File'Download template file and fill in detail
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
- IMPORTANT:
1. Kindly ensure that ((UNIT_PRICE - UNIT_DISCOUNT) * ITEM_QTY) is inclusive of GST/VAT
2. If TAX_AMT is not specified, system will automatically calculate the GST/VAT amount based on settings in the system.
Step 2: Fill in the data
| No | Field Name | Data Type | Remarks |
|---|---|---|---|
| 1 | BRANCH_CODE | String with Maximum (50) Characters | Compulsory |
| 2 | CUSTOMER_ID | Integer | Compulsory |
| 3 | ITEM_CODE | String with Maximum (100) Characters | Compulsory |
| 4 | ITEM_QTY | Floating Point Number | Compulsory |
| 5 | REFERENCE | String with Maximum (100) Characters | Compulsory |
| 6 | SALESMAN | String with Maximum (100) Characters | Compulsory |
| 7 | TAX_CODE | String with Maximum (100) Characters | Compulsory, for GST (SR, ZRL, ZRE, DS, OS, ES, AJS,......) |
| 8 | UNIT_PRICE | Floating Point Number | Compulsory |
| 9 | BATCH_NUMBER | String with Maximum (100) Characters | Compulsory if item is Batch Expiry Item |
| 10 | EXPIRY_DATE | String in the following format (yyyy-mm-dd) | Compulsory if item is Batch Expiry Item |
| 11 | ITEM_SERIAL | String with Maximum (0) Characters | Compulsory if item is serialized |
| 12 | CONSIGNMENT_DATE | String in the following format (yyyy-mm-dd) | |
| 13 | GUIDE_CODE | String with Maximum (50) Characters | |
| 14 | ITEM_NAME | String with Maximum (1000) Characters | |
| 15 | ITEM_REMARKS | String with Maximum (3000) Characters | |
| 16 | MAJOR_INDUSTRY_CODE | String with Maximum (50) Characters | |
| 17 | REMARKS | String with Maximum (300) Characters | |
| 18 | SHIP_TO | String with Maximum (50) Characters | Tips: for Customer's outlet |
| 19 | SUPPLIER_ID | Integer | |
| 20 | TAX_AMT | Floating Point Number | |
| 21 | TERMS | Integer | |
| 22 | UNIT_DISCOUNT | Floating Point Number |
Sample Data
Sample Excel Data:
Step 3: Save file, save as comma separated values (.csv) format
Step 4: Upload file
Results:
Tips
Sample of Error Message:
1. Ship To does not match with customer ID
- If this situation happen, please verify and correct the error ; eg: in the above case, please check the Customer > Other > Contact Person Name
- After edit the file, please repeat STEP 4
2. Duplicated Reference no
3. Major Industry Code is not valid
Related Permission & Configuration
Related WIKI Pages
Found 5 search result(s) for xxx.
Private & Confidential