Upload Cashsale

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.

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 :

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

  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