Menu Path: Finance > Payment Voucher > Upload Payment Voucher
Step 1: Click file link: 'Download Template File'
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 | AMOUNT | Floating Point Number | Compulsory | 212 | |
| 2 | APPROVED_BY | String with Maximum (50) Characters | Compulsory | Refer to User Listing | developer |
| 3 | BRANCH_CODE | String with Maximum (50) Characters | Compulsory | Control Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code" | A Co.-B1 |
| 4 | CASHBOOK_CODE | String with Maximum (50) Characters | Compulsory | Accounting > Maintenance > Cashbook Maintenance > Refer to "Code" | A Co-CIMB |
| 5 | CHECKED_BY | String with Maximum (50) Characters | Compulsory | Refer to User Listing | developer |
| 6 | PV_DATE | String in the following format (yyyy-mm-dd) | Compulsory | Follow YYYY-MM-DD | 2017-12-21 |
| 7 |
| REMARKS | String with Maximum (100) Characters | Compulsory | SINV3365 | ||
| 8 | ITEM_PAY_TO | String with Maximum (50) Characters | if not provided, the supplier will be populated from PAY_TO/SUPPLIER_ID/CUSTOMER_ID | ||
| 9 | ITEM_SUPPLIER_ID | Integer | If provided, the supplier name will be populated to ITEM_PAY_TO and overwrite existing | ||
| 10 | PAY_TO | String with Maximum (50) Characters | Compulsory if SUPPLIER_ID/CUSTOMER_ID is empty | ||
| 11 | SUPPLIER_ID | Integer | Compulsory if PAY_TO is empty. If provided, the supplier name will be populated to PAY_TO and overwrite existing | ||
| 12 | BILL_DATE | String in the following format (yyyy-mm-dd) | |||
| 13 | BILL_NO | String with Maximum (100) Characters | |||
| 14 | BRN_FOR_SUPPLIER | String with Maximum (50) Characters | |||
| 15 | CHEQUE_NO | String with Maximum (50) Characters | |||
| 16 | CURRENCY | String with Maximum (50) Characters |
| 17 | CURRENCY_RATE | Floating Point Number |
| 18 | CUSTOMER_ID | Integer | Compulsory if PAY_TO is empty. If provided, the supplier name will be populated to PAY_TO and overwrite existing |
| 19 | GLCODE | String with Maximum (50) Characters |
| 20 | GL_DIMENSION_CODE | String with Maximum (50) Characters |
| 21 | GL_DIMENSION_CODE_ITEM | String with Maximum (50) Characters |
| 22 | GL_DIMENSION_ID | Integer |
| 23 | GL_DIMENSION_ID_ITEM | Integer |
| 24 | ITEM_BRANCH_CODE | String with Maximum (50) Characters |
| 25 | ITEM_REMARKS | String with Maximum (300) Characters |
| 26 |
| REFERENCE_NO | String with Maximum (100) Characters |
| 27 | SUPPLIER_GST_ID | String with Maximum (50) Characters |
| 28 | TAX_AMT | Floating Point Number |
| 29 | TAX_CODE | String with Maximum (100) Characters | |||
| 30 | TT_NO_OR_E_BANKING | String with Maximum (50) Characters |
Notes:
If TAX_AMT is not specified, system will automatically calculate the GST/VAT amount based on settings in the system.
Excel sample:
- With Supplier ID or Customer ID (Normal PV)
- With Pay To (Open PV)
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,put the correct Cashbook Code under Cashbook Maintenance
- After editing the file, please repeat STEP 4
Related WIKI Pages
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
...