Advanced Bank Reconciliation matching thousands of records

(0) Share

Report

Posted on by GavinLinnett

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?

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
GavinLinnett 35 on at

Like (0)

Report

Thanks. Yes, already enabled for Advanced Bank Recon. I do select one transaction and the 700000 matching entries, but the process does not complete.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,648 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

GavinLinnett 35 on at

Like (1)

Report

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.

Was this reply helpful? Yes No