Upload Deposit
Menu Path: Customer > Task > Upload Deposit
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
Sample of Upload Deposit file
| 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_CODE | String with Maximum (150) Characters | Compulsory, Customer ID / Customer Code | Customer > Maintenance > Customer > Account PKID or Customer > Task> Settle Document > Customer | 4703 |
| 3 | METHOD_OF_PAYMENT | String with Maximum (30) Characters | Compulsory, CASH, CARD, CHEQUE, PD CHEQUE, COUPON, OTHER | ||
| 4 | PAYMENT_AMOUNT | Floating Point Number | Compulsory | ||
| 5 | RECEIPT_DATE | String in the following format (yyyy-mm-dd) | Compulsory | 2017-11-20 | |
| 6 | SALESMAN | String with Maximum (100) Characters | Compulsory | Customer > Task> Settle Document > Salesman drop down list | admin |
| 7 | PAYMENT_MODE | String with Maximum (30) Characters | Compulsory if Method Of Payment is CARD | Accounting > Maintenance> Card Listing > Generate> Payment Mode | |
| 8 | PAYMENT_NUMBER | String with Maximum (50) Characters | Compulsory if Method Of Payment is not CASH. [Card no./Cheuque no./PD Cheuqe no./Coupon Serial no.] | ||
| 9 | TAX_CODE | String with Maximum (36) Characters | Must follow configured Tax Code | ||
| 10 | CARD_APPROVAL_CODE | String with Maximum (50) Characters | |||
| 11 | CARD_BATCH | String with Maximum (50) Characters | |||
| 12 | CARD_NAME | String with Maximum (100) Characters | |||
| 13 | CARD_VALID_THRU | String in the following format (yyyy-mm-dd) | |||
| 14 | CASHBOOK | String with Maximum (100) Characters | |||
| 15 | DATE_PD_CHEQUE | String in the following format (yyyy-mm-dd) | |||
| 16 | GL_DIMENSION_CODE | String with Maximum (50) Characters | |||
| 17 | GL_DIMENSION_ID | Integer | |||
| 18 | REMARKS | String with Maximum (300) Characters | |||
| 19 | TAX_RATE | Floating Point Number |
Note: The amount recorded will follow Output tax GST configuration, if the configuration is set as inclusive, the Amount recorded will be inclusive of GST
Excel sample:
- CASH
- CARD
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 Payment Mode in the file
- After editing the file, please repeat STEP 4
Private & Confidential