Menu Path: Trading > Sales > Upload Cashsale
Basically the function is similar with upload invoice, ONLY difference is we are adding another row for payment information.
For the payment, we are using hard coded item code called "MOP", as additional row with same BRANCH_CODE, SALESMAN, INVOICE_DATE, REFERENCE.
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 | 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 | Refer to system customer account PKID (auto-generated) | PER-4748 |
| 3 | INVOICE_DATE | String in the following format (yyyy-mm-dd) | Compulsory | 2017-11-28 | |
| 4 | ITEM_CODE | String with Maximum (100) Characters | Compulsory | ITEM A | |
| 5 | ITEM_QTY | Integer | Compulsory | 1 | |
| 6 | METHOD_OF_PAYMENT | String with Maximum (150) Characters | Compulsory, CASH, CARD, CHEQUE, PD CHEQUE, COUPON, OTHER | CASH | |
| 7 | PAYMENT_AMOUNT | Floating Point Number | Compulsory | 106 | |
| 8 | REFERENCE | String with Maximum (100) Characters | Compulsory | 20171128 | |
| 9 | SALESMAN | String with Maximum (100) Characters | Compulsory | developer | |
| 10 | UNIT_PRICE | Floating Point Number | Compulsory | 106 | |
| 11 | BATCH_NUMBER | String with Maximum (100) Characters | Compulsory if item is Batch Expiry Item | ||
| 12 | CARD_NUMBER | String with Maximum (20) Characters | Compulsory if Method Of Payment is CARD | ||
| 13 | CHEQUE_NUMBER | String with Maximum (30) Characters | Compulsory if Method Of Payment is CHEQUE / PD CHEQUE | ||
| 14 | EXPIRY_DATE | String in the following format (yyyy-mm-dd) | Compulsory if item is Batch Expiry Item | ||
| 15 | ITEM_SERIAL | String with Maximum (0) Characters | Compulsory if item is serialized | ||
| 16 | PAYMENT_MODE | String with Maximum (30) Characters | Compulsory if Method Of Payment is CARD | ||
| 17 | CARD_APPROVAL_CODE | String with Maximum (50) Characters | |||
| 18 | CARD_BATCH | String with Maximum (20) Characters | |||
| 19 | CARD_NAME | String with Maximum (100) Characters |
Excel sample:
- CASH PAYMENT
- CREDIT CARD PAYMENT
- CHEQUE PAYMENT
Step 3: Save file, save as comma separated values (.csv) format
Step 4: Upload file
Sample of Error Message 1:
- 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,check the Edit Customer pag and add the Customer ACCOUNT CODE in to the file
- After edit the file, please repeat STEP 4
Sample of Error Message 2:
- 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,correct the Date Format to yyyy-mm-dd
- After edit the file, please repeat STEP 4
Sample of Error Message 3:
- 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, copy the data in excel file to new sheet
- After edit the file, please repeat STEP 4
Sample of Error Message 4:
- If this situation happen, please verify and correct the error eg: in the above case, please check the PAYMENT_AMOUNT
- After edit the file, please repeat STEP 4
Sample of Error Message 5:
- If this situation happen, please verify and correct the error eg: in the above case, please remove the data that has already uploaded from the excel file
- After edit the file, please repeat STEP 4
Related WIKI Pages:
Found 5 search result(s) for cashsale.