You’re offline. This is a read only version of the page.
50
Hi all,
I am trying to figure out how to handle huge amount of payments per day of customer payments of sales invoices from the bank account statement.
When we download a structured BAI2, ISO2022, or..... file from our bank we would like to automatic match this with the customer sales invoice, is there any possibility ?
I already researched the bank statement and matching function but this does not cover our needs, ofcourse there are ISV solutions but would like to know if someone already faced this challenge and how made a solution for this.
Thanks!
*This post is locked for comments
The third option is to change your process ;-)
Hello csteenbe,
The way how the automatic bank reconciliation is currently designed is that you have to post customer payments first in a customer payment journal where you do the settlement with the invoices.
In a second step, you upload your bank file and match it against the transfer account / positions that come from this customer payment journal.
Matching bank transactions directly with open customer transactions is currently not supported by the advanced bank recon. feature.
If you operate in a European banking environment then this might be something that looks different from what you might be used to and you have to assess whether this functionality is something you can use or whether a system modification or the purchase of an (expensive) ISV solution might might necessary.
Best regards,
Ludwig
I'm not a functional consultant (you'd have to wait for others), but that's what the automatic bank reconciliation feature is for, isn't it?
Our needs are explained in this sentence;
When we download a structured BAI2, ISO2022, or..... file from our bank we would like to automatic match this with the customer sales invoice, is there any possibility ?
This download can be done in a GL journal or Customer Payment Journal, we use the GL journal variant because we are not using a bridging account and book directly on the bank account. There is no match possiblity in this functionality, download, so what are my options here or is there a workaround to match customer invoice payment in a GL Journal ?
If the standard feature for this purpose doesn't cover your needs and you want our advice, maybe you should explain your needs.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (