Menu Path: Menu Path: Trading > Sales > Upload Cashsale
...
| Panel |
|---|
Cashsale creates documents with Receipts, the function is similar with upload invoice, |
...
For the payment, we are using hard coded item code called "MOP", as additional row with same BRANCH_CODE, SALESMAN, INVOICE_DATE, REFERENCE.
For better understanding, please refer example below.
Example 1 : Upload cash sale for 1 item, pay using cash.
Sample upload file should be as below :
| BRANCH_CODE | CUSTOMER_CODE | SALESMAN | INVOICE_DATE | REFERENCE | REMARKS | ITEM_CODE | ITEM_NAME | ITEM_REMARKS | UNIT_PRICE | UNIT_DISCOUNT | ITEM_QTY | TAX_CODE | TAX_RATE | TAX_AMT | METHOD_OF_PAYMENT | PAYMENT_AMOUNT |
| branch-a | AUTO-1002 | wavelet | 2014-11-19 | ref | item-abcd | item name | item remark1 | 1590 | 10 | 2 | SR | |||||
| branch-a | AUTO-1002 | wavelet | 2014-11-19 | ref | MOP | item name | item remark1 | 0 | CASH | 3160 |
result:
Example 2 : Upload cashsale for multiple items, pay using cash and card
| BRANCH_CODE | CUSTOMER_CODE | SALESMAN | INVOICE_DATE | REFERENCE | REMARKS | ITEM_CODE | ITEM_NAME | ITEM_REMARKS | UNIT_PRICE | UNIT_DISCOUNT | ITEM_QTY | TAX_CODE | TAX_RATE | TAX_AMT | METHOD_OF_PAYMENT | PAYMENT_AMOUNT | PAYMENT_MODE |
| branch-a | AUTO-1002 | wavelet | 2014-11-19 | ref | item-abcd | item name | item remark1 | 1500 | 10 | 2 | SR | 6 | 89.40 | ||||
| branch-a | AUTO-1002 | wavelet | 2014-11-19 | ref | item-xyz | item name | item remark1 | 200 | 1 | ||||||||
| branch-a | AUTO-1002 | wavelet | 2014-11-19 | ref | MOP | item name | item remark1 | 0 | CASH | 180 | |||||||
| branch-a | AUTO-1002 | wavelet | 2014-11-19 | ref | MOP | item name | item remark1 | 0 | CARD | 3000 | RHB |
result:
Sample of Upload Error List
...
Upload Error List, Column with red background is invalid.
UNIT_DISCONT
Solution: check the Field Name Spelling, should be UNIT_DISCOUNT
...
ONLY difference is payment information is required for this Upload. |
The Mode of Payment (MOP) , you are required to create an identical row, with Item Code MOP and use same BRANCH_CODE, SALESMAN, INVOICE_DATE, REFERENCE. Refer to Excel Example
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 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 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:
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|