Upload Cash Sale

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.

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