I am busy rolling out our 200 odd bank accounts onto Dynamics 365 Advanced Bank reconciliation. We went live with about 30 accounts on go live date in October 2020, but have had delays getting the reference fields matched up for some of our higher volume accounts. In October 2020 we took on all bank accounts into Dynamics 365, but did not bring in the bank statements for all. Now as I rollout the remaining accounts, I follow a process of creating a dummy opening bank statement that has all unreconciled transactions and a single transaction that is matched to the bank ledger transactions that were matched in the legacy solution. The issue I have is that one account has over 700,000 entries that I need to match to my single opening balance bank statement entry. The values all match 100% but the processing takes forever and has yet to complete. Any solutions out there to do this on the database directly (will need to get MS to run the scripts on prod), or tricks to ensure the processing completes?
To solve, I extracted all transactions, split them by week and then created a dummy bank statement with a movement by week and reconciled those week by week until all were reconciled. Marking the statement as reconciled took forever, but eventually completed.
Hi GavinLinnett ,
As I remember, block code in reconciliation in technical side is not in tts begin/end , thus if after run reconciliation none of the transaction not match, probably it cause date of transaction.
I propose you debug batch job's reconciliation with some rows.
Hello GavinLinnett,
I would recommend getting into touch with the MS support because I am not sure if the standard recon. feature was intended and can actually handle that large volume of matching entries. The support might know some tricks that can help you getting this process completed.
Best regards,
Ludwig
Thanks. Yes, already enabled for Advanced Bank Recon. I do select one transaction and the 700000 matching entries, but the process does not complete.
1. Is bank account already enabled for Advance Bank reco? if now may be manual bank reco will be faster?
2. Are you not able to match by selecting all transactions and one transaction manually and click match instead rule?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 777 User Group Leader
André Arnaud de Cal... 630 Super User 2025 Season 2
Martin Dráb 602 Most Valuable Professional
