Menu Path: Trading > Sales > Upload CashsaleBasically the
| Panel |
|---|
Cashsale creates documents with Receipts, the function is similar with upload invoice, ONLY difference is |
...
payment information is required for this Upload. |
...
For the payment, we are using hard coded item code called "MOP", as additional row with same BRANCH_CODE, SALESMAN, INVOICE_DATE, REFERENCE.
Upload Step
Step 1: Fill in information in excel format and save as CSV file
Step 2: Select Input File and click Submit to upload
Step 3: Successfully upload message and show Previously created invoice for reference
If upload fail, system give error message, please refer to below Sample of Upload Error List.
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 :
...
- Result:
Example 2 : Upload Cashsale for multiple items, pay using cash and card
- Sample upload file should be as below :
...
Result: Sample of Upload Error List
Unable to create invoice. No payment for invoice with group.
Solution: Add another row : ITEM_CODE: MOP ; METHOD_OF_PAYMENT ; PAYMENT_AMOUNT
...
Upload Error List, Column with red background is invalid. (CUSTOMER_CODE)
Solution: Refer to Customer > Maintenance > Edit Customer: Account Code Prefix column (usually this code follow existing software customer code); Not the Account PKID
...
Upload Error List, Column with red background is invalid. (INVOICE_DATE : Date format must be in the following format (yyyy-mm-dd))
Solution: change the date format to yyyy-mm-dd.
...
Upload Error List, Column with red background is invalid. (PK!��X�y[Content_Types].xml �(��T�n�0�W�?D�V�@����[$��xB)
...
Warning Message:
| INVOICE WITH THE FOLLOWING KEY EXIST branch code|customer code|invoice date|reference|salesman LHQ|AUTO-1002|2015-11-16|ref1|developer |
Solution: The information uploaded, remove the data in excel file and upload again.
...
Upload Error List, Column with red background is invalid. (UNIT_DISCONT)
- Solution: check the Field Name Spelling, should be UNIT_DISCOUNT
Warning Message:
...
Solution: check the PAYMENT_AMOUNT
...
|
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 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|