You’re offline. This is a read only version of the page.
Announcements
122
Hello, I am trying to set up the advanced bank reconciliation for Germany and having trouble with doing so.
The import of the XML file works fine, and all bank transactions are shown in the Bank reconciliation worksheet in the Open statement lines section. Nevertheless, the Open bank documents section is empty, and no open transactions are shown. Only after posting a payment journal with the matching lines, those lines are available for reconciliation in the Bank reconciliation worksheet.
The process that we would like to set up is that we would like to match the imported bank statement with open payments of our customers to post the payment.
So from my understanding there should be first the matching and reconciliation in the Bank reconciliation worksheet and as a result there should be a payment journal for all matched lines to settle the payment. But the process in AX seems to be the exact opposite.
Can someone help me to set it up correctly.
Hello Tilman Vo,
I don't know why things have been designed the way they are designed. Germany and the way how we handle things here is probably not something that is used on a global level :-) Already had a couple of talks with the PMs. What would help is if you could create a new idea in the ideas/experience portal and try to get as many votes as possible. The product team will then pick up those things. This does not guarantee that it will make it into the product but it will certainly be considered.
Best regards,
Ludwig
You wrote "settling the customer payments in a separate journal beforehand is time consuming and commonly not used this way.".
Why is the process designed like this? For what kind of company / processs fits this solution? Is there a way to change the internal processes so that standard would be a valid solution?
Hello Tilman,
For AX2012R3 you might be better off using either a customization or purchasing a 3rd party ISV solution.
Theoretically, you can use Flow/PowerAutomate but only if the volume of your data is small.
If you need to import and reconcile thousands of payments on a daily basis then Flow/PowerAutomate might be too slow.
Best regards,
Ludwig
Hello Ludwig,
Thank you very much for your Reply. I checked the posts from your link and they look neat and easy, although you do not use the standard forms at all.
Electronic reporting is only available in D365, isn't it?
So what would be choice for R3? The use of Flow or Power automate?
Thanks,
Tilman
Hello Tilman,
You are right.
The first step would be posting the customer and vendor payment journals before you can run the reconciliation in the bank module.
For all of the projects in Germany that I worked on this standard process is not one that can directly be used without making some system modifications because especially posting and settling the customer payments in a separate journal beforehand is time consuming and commonly not used this way.
What might help is importing the bank statements in GL journals and doing the settlement and reconciliation there.
This import is not fully supported especially the settlement but you can use standard tools such as electronic reporting to get started.
Yet, I posted a couple of blog posts how that could be achieved.
Please see:
Best regards,
Ludwig
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
