...
...
...
...
...
...
...
...
...
...
...
...
...
...
Menu Path: Trading > Sales > Upload Invoice
| Panel | ||
|---|---|---|
| ||
| This function allow user to upload invoice using excel instead of create manually |
Step 1: Click "Download template file" to download the excel template
File Link 'Download Template File'
Notes:
- 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
- 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 | CUSTOMER_ID | Integer | Compulsory | Refer to system customer account PKID (auto-generated) | 4748 |
| 3 | INVOICE_DATE | String in the following format (yyyy-mm-dd) | Compulsory | 2017-08-25 | |
| 4 | ITEM_CODE | String with Maximum (100) Characters | Compulsory | GST-ITEM-1 | |
| 5 | ITEM_QTY | Floating Point Number | Compulsory | 1 | |
| 6 | REFERENCE | String with Maximum (100) Characters | Compulsory | Note: same reference no. for same customer pkid, for difference item code, will be created in same invoice; if difference reference, created in separete invoice | ref |
| 7 | SALESMAN | String with Maximum (100) Characters | Compulsory | developer | |
| 8 | TAX_CODE | String with Maximum (100) Characters | Compulsory, for GST (SR, ZRL, ZRE, DS, OS, ES, AJS,......) | SR | |
| 9 | UNIT_PRICE | Floating Point Number | Compulsory | Amount Inclusive GST | 1272.00 |
| 10 | AUTO_CREATE_GRN | String with Maximum (0) Characters | Auto Generate GRN for this Invoice(Default is false) | ||
| 11 | BATCH_NUMBER | String with Maximum (100) Characters | Compulsory if item is Batch Expiry Item | ||
| 12 | CONTACT_PERSON_IC | String with Maximum (30) Characters | For Intercompany Stock Transfer Purpose | ||
| 13 | CURRENCY | String with Maximum (50) Characters | USD,CNY,HKD,THB,SGD,JPY | SGD | |
| 14 | CURRENCY_RATE | Floating Point Number | 4.27,0.65,0.54,0.13,3.15,0.0389 | 3.02 | |
| 15 | EXPIRY_DATE | String in the following format (yyyy-mm-dd) | Compulsory if item is Batch Expiry Item |
| 16 | ITEM_SERIAL | String with Maximum (0) Characters | Compulsory if item is serialized |
| 17 | GL_DIMENSION_CODE | String with Maximum (50) Characters |
| 18 | GL_DIMENSION_ID | Integer |
| 19 | GUID_CODE | String with Maximum (50) Characters |
| 20 | ITEM_NAME | String with Maximum (1000) Characters |
| 21 | ITEM_REMARKS | String with Maximum (3000) Characters | Item's remarks |
| 22 | MAJOR_INDUSTRY_CODE | String with Maximum (50) Characters |
| 47591 |
| 23 | REMARKS | String with Maximum (300) Characters | Invoice's remarks Note: same reference no. & same remarks for same customer pkid, for difference item code, will be created in same invoice; if same reference, difference remark, created in separete invoice |
| 24 | SUPPLIER_ID | Integer |
| 25 | TAX_AMT | Floating Point Number |
| 26 | TERMS | Integer |
| 27 | UNIT_DISCOUNT | Floating Point Number |
Sample Upload File
Result:
Excel sample:
Normal Invoice
Invoice with Foreign Currency
Notes:
- Make sure the Currency is active under configuration
Step 3: Save file, save as comma separated values (.csv) format
Step 4: Upload file
Tips
Related Permission & Configuration
#[IMPORTANT:
- Kindly ensure that ((UNIT_PRICE - UNIT_DISCOUNT) * ITEM_QTY) is inclusive of GST/VAT
- If TAX_AMT is not specified, system will automatically calculate the GST/VAT amount based on settings in the system
Related WIKI Pages
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
...