Page Comparison

Menu Path: Trading > Sales > Upload Cashsale

Image Added

Image Added

Image Added

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 BRANCHsame 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 :

Example 2 : Upload cashsale for multiple items, pay using cash and card

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
   
   Image Added
   Image Added
   
   
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
   Image Added
   Image Added
   
   
   
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
   
   Image AddedImage Added
   
   
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
   Image AddedImage Added
   
   
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
   Image AddedImage Added
6.