Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Advanced Bank Reconcil...
Finance forum
Answered

Advanced Bank Reconciliation

(1) ShareShare
ReportReport
Posted on by Tilman Vo 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.

Categories:
Financial Management
  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced Bank Reconciliation

    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

  • Tilman Vo Profile Picture
    Tilman Vo 122 on at
    RE: Advanced Bank Reconciliation

    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?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced Bank Reconciliation

    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

  • Tilman Vo Profile Picture
    Tilman Vo 122 on at
    RE: Advanced Bank Reconciliation

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced Bank Reconciliation

    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:

    dynamicsax-fico.com/.../

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans