...
...
...
...
...
...
...
...
...
| Panel | ||
|---|---|---|
| ||
| This function allow user to upload invoice using excel instead of create manually |
Menu Path: Trading > Sales > Upload Invoice
Step 1: Click "Download template file" to download the excel template
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 | EXPIRY_DATE | String in the following format (yyyy-mm-dd) | Compulsory if item is Batch Expiry Item | ||
| 14 | ITEM_SERIAL | String with Maximum (0) Characters | Compulsory if item is serialized | ||
| 15 | GL_DIMENSION_CODE | String with Maximum (50) Characters | |||
| 16 | GL_DIMENSION_ID | Integer | |||
| 17 | GUID_CODE | String with Maximum (50) Characters | |||
| 18 | ITEM_NAME | String with Maximum (1000) Characters | |||
| 19 | ITEM_REMARKS | String with Maximum (3000) Characters | Item's remarks | ||
| 20 | MAJOR_INDUSTRY_CODE | String with Maximum (50) Characters | 47591 | ||
| 21 | 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 | ||
| 22 | SUPPLIER_ID | Integer | |||
| 23 | TAX_AMT | Floating Point Number | |||
| 24 | TERMS | Integer | |||
| 25 | UNIT_DISCOUNT | Floating Point Number |
Sample Upload File
Result:
Tips
Related Permission & Configuration
...