Menu Path: Trading > Sales > Upload Cashsale
Basically the function is similar with upload invoice, only difference 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.
Menu Path: Trading > Sales > Upload Cashsale
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 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 :
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
- 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 PAYMENT_MODE branch-a AUTO-1002 wavelet 2014-11-19 ref
...
item-abcd item name item remark1 1590 10.60 1 SR
...
...
branch-a AUTO-1002 wavelet 2014-11-19 ref
...
item-xyz item name item remark1 200
...
1 SR
...
...
branch-a AUTO-1002 wavelet 2014-11-19 ref
...
MOP item name item remark1
...
0
...
...
CASH 90
...
branch-a AUTO-1002 wavelet 2014-11-19 ref
...
MOP item name item remark1
...
0
...
...
CARD 1700 MBB-VISA
...
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)
Solution: copy the data in excel file to new sheet, save and upload again.
...
Warning Message:
INVOICE WITH THE FOLLOWING KEY EXIST
branch code|customer code|invoice date|reference|salesman
LHQ|AUTO-1002|2015-11-16|ref1|developerSolution:
...
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:
...
Unable to create invoice. Insufficient payment amount [3,180.00] for invoice amount [3,358.80] with group : (LHQ, AUTO-1002, 2015-11-16, developer, ref8) Solution: check the PAYMENT_AMOUNT
...
