Versions Compared

Version Old Version 2 New Version 3
Changes made by

Siti Norhidayah

Siti Norhidayah

Saved on

Key

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


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 :

 

BRANCH_CODESALESMANINVOICE_DATEREFERENCEREMARKSITEM_CODEPAYMENT_AMOUNTITEM_NAMEITEM_REMARKSUNIT_DISCOUNTUNIT_PRICEITEM_QTYCUSTOMER_CODEMETHOD_OF_PAYMENTidabranch
branch-awavelet2014-11-19ref item-abcd item nameitem remark11015002AUTO-1002 
branch-awavelet2014-11-19ref MOP3000item nameitem remark1 IDA-ITEM 0AUTO-1002CASH



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

 

 

 

 

BRANCH_CODESALESMANINVOICE_DATEREFERENCEREMARKSITEM_CODEPAYMENT_AMOUNTITEM_NAMEITEM_REMARKSUNIT_DISCOUNTUNIT_PRICEITEM_QTYCUSTOMER_CODEMETHOD_OF_PAYMENTPAYMENT_MODE
branch-awavelet2014-11-19ref item-abcd item nameitem remark11015002AUTO-1002  
branch-awavelet2014-11-19ref item-xyz item nameitem remark1 2001AUTO-1002  
idabranchbranch-awavelet2014-11-19ref MOP3000item nameitem remark1  0AUTO-1002CASH 
branch-awavelet2014-11-19ref MOP200item nameitem remark1  0AUTO-1002CARDRHB