ABS100 multiple invoices on bank statement line

We face an issue with a certain batch payments from a customer that gets imported into ABS100.At times, the customer has paid 50+ invoices and the total amount is displayed on one bank statement line in ABS101. The finance team then needs to allocate all 50 AR invoices manually to this bank statement line in order to clear the invoices in the AR ledger. Therefore, we are looking for a way to allocate the batch of invoices automatically to the bank statement line. Does anyone know if ABS940 can be used to achieve this (assuming the additional information text in ABS102 is always the same for these batch payments), or any other solution?

Find more posts tagged with

Comments

JuanSz

Are all the invoice numbers on the bank statement message? Often it says with that many invoices something like "See payment specification" then there is nothing to match in ABS102.
The payment specification is often a PDF but when you ask there are customers that can send it as a XML/Text file. Then you can make an ION/MeC mapping that processes these files. The amount of all paid, but unspecified invoices, is then with the BankStatement proecessing step "parked" on a specific account. The payment specification from the customer then takes it from that account and allocates it to the paid invoices.
Sounds a bit complicated but we recently implemented it (supporting 2 different files format) and the AR people are saving several hours per week. Works so well that we are piloting with transforming PDF into data files using OCD/AI - for customer who cannot or want to send the specification as data file.

Jeremy Bull

How are ABS910 and ABS911 configured? What search path are you using to match the invoice to a reference field on the ABS100 record?

Daniel Andersson

We are using search path 2 - additional information file. The invoice number is on the additional information file and the automatic allocation works when the line only considers one invoice, but when the customer has paid several invoices and only one bank statement line is created for this payment, the additional information file cannot contain all AR invoice numbers, forcing us to allocate the AR invoices manually to the bank statement line.

Daniel Andersson

Yes, usually all the invoice numbers are in the file from the bank (except for these batch customer payments which usually is the last entry in the file from the bank which gets imported into ABS100). Might be worth mentioning that the bank is sending us a text file (MT940 format). We receive three files from the bank; the MT940 file which gets imported into ABS100, the bank statement PDF and an Excel file which lists all invoices that were paid in batch. Did you do any configurations in M3 to 'park' the amount on the bank statement line which corresponds to the batch of invoices paid by the customer, or was the solution built entirely in ION/MEC?

nick-garris

Hi,

While it a bit of a tough task to know how your information comes in, it depends if your bank breaks down each payment into a payment group highlighting each invoice thats being paid. If that is the case, then the mapping process to import your payments into ABS100, should break down each payment into each payment in ABS101 then the detail breaks out per invoice where it can use your search setup in ABS910. You can add another rule in ABS910/911 to create a separate search on the supplier where it will create a payment on account for any invoices that weren't a perfect match and your team can go in under that customer and then apply the payments where needed. Please let me know if you wish to know more.

Daniel Andersson

Hello. In the text file we receive from the bank, each line refers to a specific invoice which, when imported into M3, creates one line for each invoice in ABS101. These get auto allocated and pose no issues for us. However, the very last line in the text file refers to a batch payment of several invoices. No invoice numbers are provided for this batch payment in the file. This line in the text file creates one line in ABS101. Also, this batch payment covers multiple invoices from various customers.

JuanSz

For now the users "park" the amounts manually when they correct the errors in the bank statement.
Processing the payment specification is done via a complete new MeC mapping/agreement with own ASB900 configuration. It took some effort to implement but in our case it was worth it.

Copyright © 2025 Infor. All rights reserved.