Upload Cash Sale

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.

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 

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

result:

Sample of Upload Error List

1. Unable to create invoice. No payment for invoice with group
   Solution: Add another row : ITEM_CODE: MOP ; METHOD_OF_PAYMENT ; PAYMENT_AMOUNT
   
   
   
   
   
2. 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
   
   
   
   
   
3. 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
   
   
   
   
4. 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
   
   
   

5. 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
   
   
   

6. Upload Error List, Column with red background is invalid.

   UNIT_DISCONT

   Solution: check the Field Name Spelling, should be UNIT_DISCOUNT

   
   

   
   

7. 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

   
   

8.