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_CODE | SALESMAN | INVOICE_DATE | REFERENCE | REMARKS | ITEM_CODE | PAYMENT_AMOUNT | ITEM_NAME | ITEM_REMARKS | UNIT_DISCOUNT | UNIT_PRICE | ITEM_QTY | CUSTOMER_CODE | METHOD_OF_PAYMENT |
idabranch | wavelet | 2014-11-19 | ref | IDA-ITEM | item name | item remark1 | 10 | 1500 | 2 | AUTO-1002 | |||
idabranch | wavelet | 2014-11-19 | ref | MOP | 3000 | item name | item remark1 | 0 | AUTO-1002 | CASH |