Versions Compared

Version Old Version 8 New Version Current
Changes made by

Jia Pei Chan

Gracia Surialim

Saved on

Key

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

 Basically the Menu Path: Trading > Sales > Upload Cashsale

Panel

Cashsale creates documents with Receipts, the function is similar with upload invoice,

...

 

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 Removed

Image Removed

Image Removed

Upload Step

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

Image Removed

Step 2: Select Input File and click Submit to upload

Image Removed

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

Image Removed

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 Removed

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 remark1159010.601SR     
branch-aAUTO-1002wavelet2014-11-19ref item-xyzitem nameitem remark1200 1SR     
branch-aAUTO-1002wavelet2014-11-19ref MOPitem nameitem remark1  0   CASH90 
branch-aAUTO-1002wavelet2014-11-19ref MOPitem nameitem remark1  0   CARD1700MBB-VISA

result:

Sample of Upload Error List

...

Upload Error List, Column with red background is invalid.

UNIT_DISCONT

Solution: check the Field Name Spelling, should be UNIT_DISCOUNT

Image Removed

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

...

ONLY difference is payment information is required for this Upload. 

The Mode of Payment (MOP) , you are required to create an identical row, with Item Code MOP and use same BRANCH_CODE, SALESMAN, INVOICE_DATE, REFERENCE. Refer to Excel Example

Image Added

Step 1: Click file link: 'Download Template File'

Image Added

Notes:

  1. select source fields and add to target fields (The compulsory fields are pre-selected and can not be removed)
  2. default format is “comma” delimiter


Step 2: Fill in the data

NoField NameData TypeRemarksWhere to findSample Data
1BRANCH_CODEString with Maximum (50) CharactersCompulsoryControl Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code"A Co.-B1
2CUSTOMER_CODEString with Maximum (150) CharactersCompulsoryRefer to system customer account PKID (auto-generated)PER-4748
3INVOICE_DATEString in the following format (yyyy-mm-dd)Compulsory
2017-11-28
4ITEM_CODEString with Maximum (100) CharactersCompulsory
ITEM A
5ITEM_QTYIntegerCompulsory
1
6METHOD_OF_PAYMENTString with Maximum (150) CharactersCompulsory, CASH, CARD, CHEQUE, PD CHEQUE, COUPON, OTHER
CASH
7PAYMENT_AMOUNTFloating Point NumberCompulsory
106
8REFERENCEString with Maximum (100) CharactersCompulsory
20171128
9SALESMANString with Maximum (100) CharactersCompulsory
developer
10UNIT_PRICEFloating Point NumberCompulsory
106
11BATCH_NUMBERString with Maximum (100) CharactersCompulsory if item is Batch Expiry Item

12CARD_NUMBERString with Maximum (20) CharactersCompulsory if Method Of Payment is CARD

13CHEQUE_NUMBERString with Maximum (30) CharactersCompulsory if Method Of Payment is CHEQUE / PD CHEQUE

14EXPIRY_DATEString in the following format (yyyy-mm-dd)Compulsory if item is Batch Expiry Item

15ITEM_SERIALString with Maximum (0) CharactersCompulsory if item is serialized

16PAYMENT_MODEString with Maximum (30) CharactersCompulsory if Method Of Payment is CARD

17CARD_APPROVAL_CODEString with Maximum (50) Characters


18CARD_BATCHString with Maximum (20) Characters


19CARD_NAMEString with Maximum (100) Characters


Excel sample: 

  • CASH PAYMENT

Image Added

  • CREDIT CARD PAYMENT

Image Added

  • CHEQUE PAYMENT

Image Added


Step 3: Save file, save as comma separated values (.csv) format

Image Added

Image Added


Step 4: Upload file

Image Added

Image Added

Sample of Error Message 1:

  • If the file is not sucessfully uploaded, please refer to the column with RED color background
  • Please move the cursor to the RED color background to see the Error Message

Image Added

  • If this situation happen, please verify and correct the error eg: in the above case,check the Edit Customer pag and add the Customer ACCOUNT CODE in to the file
  • After edit the file, please repeat STEP 4

Sample of Error Message 2:

Image Added

  • If this situation happen, please verify and correct the error eg: in the above case,correct the Date Format to yyyy-mm-dd
  • After edit the file, please repeat STEP 4

Sample of Error Message 3:

Image Added

  • If this situation happen, please verify and correct the error eg: in the above case, copy the data in excel file to new sheet
  • After edit the file, please repeat STEP 4

Sample of Error Message 4:

Image Added

  • If this situation happen, please verify and correct the error eg: in the above case, please check the PAYMENT_AMOUNT
  • After edit the file, please repeat STEP 4

Sample of Error Message 5:

Image Added

  • If this situation happen, please verify and correct the error eg: in the above case, please remove the data that has already uploaded from the excel file
  • After edit the file, please repeat STEP 4


Related WIKI Pages:
Panel

Search Results
spacekeyWMS
maxLimit5
querycashsale
typepage