Versions Compared

Version Old Version 7 New Version 8
Changes made by

Jia Pei Chan

Jia Pei Chan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Menu Path: Trading > Sales > Upload Cashsale

Image Removed

Image Removed

Image Removed

 

Basically the function is similar with upload invoice, only  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

Image Added

Image Added

Image Added

Upload Step

Step 1: Fill in information in excel format and save as CSV file

Image Added

Step 2: Select Input File and click Submit to upload

Image Added

Step 3: Successfully upload message and show Previously created invoice for reference

Image Added

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_CODECUSTOMER_CODESALESMANINVOICE_DATEREFERENCEREMARKSITEM_CODEITEM_NAMEITEM_REMARKSUNIT_PRICEUNIT_DISCOUNTITEM_QTYTAX_CODETAX_RATETAX_AMTMETHOD_OF_PAYMENTPAYMENT_AMOUNT
branch-aAUTO-1002wavelet2014-11-19ref item-abcditem nameitem remark11590102SR    
branch-aAUTO-1002wavelet2014-11-19ref MOPitem nameitem remark1  0   CASH3160

result: 

Image Modified


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

 

BRANCH_CODECUSTOMER_CODESALESMANINVOICE_DATEREFERENCEREMARKSITEM_CODEITEM_NAMEITEM_REMARKSUNIT_PRICEUNIT_DISCOUNTITEM_QTYTAX_CODETAX_RATETAX_AMTMETHOD_OF_PAYMENTPAYMENT_AMOUNTPAYMENT_MODE
branch-aAUTO-1002wavelet2014-11-19ref item-abcditem nameitem remark11500159010.6021SR6 89.40    
branch-aAUTO-1002wavelet2014-11-19ref item-xyzitem nameitem remark1200 1 SR     
branch-aAUTO-1002wavelet2014-11-19ref MOPitem nameitem remark1  0   CASH18090 
branch-aAUTO-1002wavelet2014-11-19ref MOPitem nameitem remark1  0   CARD30001700RHBMBB-VISA

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

    Image Added