Banking and Cash Management > Electronic Processing > Multiple Invoice Lines
  
Multiple Invoice Lines
When importing the same payment for multiple open items (invoices and credit notes), Process Incoming Bank Files searches the system for the relevant matching open items, and allocates payment against all the lines using a single payment transaction. The system matches imported bank file payments and the corresponding open items by matching the bank numbers and payment references.
Example:  
An imported bank file for the customer Alderon contains a single check payment for two invoices.
 
Payment
Check Reference: 2014/7890
Amount: 870.00 USD
Invoices
2014/ARINV/0000328
Amount: 320.00 USD
 
2014/ARINV/0000329
Amount: 550.00 USD
When the file is imported, the details are stored in the system as follows:
 
Customer
Payment Reference
Amount
Allocated To
Alderon
Check Reference: 2014/7890
320.00 USD
2014/ARINV/0000328
Alderon
Check Reference: 2014/7890
550.00 USD
2014/ARINV/0000329
The payments are automatically processed by Process Incoming Bank Files, and grouped into one transaction because both payments have the same check reference, 2014/7890. The single payment is allocated to both open invoices.
 
Customer
Check Reference
Amount
Allocated To
Alderon
Check Reference: 2014/7890
870.00 USD
2014/ARINV/0000328 and 2014/ARINV/0000329
Example:  
An imported bank file for the customer Alderon contains a single check payment for both an open invoice and an open credit note.
 
Payment
Check Reference: 2014/7899
Amount: 1000.00 USD
Open Items
2014/ARINV/0000330
Amount: 1300.00 USD
 
2014/ARCN/0000079
Amount: -300.00 USD
When the file is imported, the details are stored in the system as follows:
 
Customer
Payment Reference
Amount
Allocated To
Alderon
Check Reference: 2014/7899
1300.00 USD
2014/ARINV/0000330
Alderon
Check Reference: 2014/7899
-300.00 USD
2014/ARCN/0000079
The payments are automatically processed by Process Incoming Bank Files, and grouped into one transaction because both payments have the same check reference, 2014/7899. The single payment is allocated to both open items.
 
Customer
Check Reference
Amount
Allocated To
Alderon
Check Reference: 2014/7899
1000.00 USD
2014/ARINV/0000330 and 2014/ARCN/0000079