Bank Account Reconciliation Error - Statement No Must be equal to in Check ledger entry

(0) Share

Report

Posted on by jjku

We have multiple companies under Business Central. Suddenly, we are getting this error.

However, when we check the bank ledger entries, we do see this:

The first 25 is entry 467, and has 25 next to it.

Anyone else have this error, and what did you do to resolve it?

I have the same question (0)

All responses (7)

Answers (1)

jjku on at

Like (2)

Report

I would just like to add that this is happening in all of our companies. So it's a pervasive issue. Not a one off error.

Was this reply helpful? Yes No
MG_PNW 10 on at

Like (0)

Report

We're an OR special district that converted to Business Central this past summer. I don't have many BC bank recs under my belt yet, but I started receiving this message in the past 2 weeks while attempting to Clear Lines, Clear Check Ledger Entries, Remove Match, and even when attempting to delete the bank rec altogether so I can start over.

I can find the check ledger entry referenced and can see that there isn't a statement no. listed but I cannot add one. At this point, I cannot move forward with my bank rec.

Was this reply helpful? Yes No
Cap428 5 on at

Like (0)

Report

We started using Business Central over the summer and I am also now getting this error for every bank account. I think it must be a bug with Microsoft that they will hopefully address soon.

Was this reply helpful? Yes No
jjku on at

Like (1)

Report

We spoke with our partner support, and MS knows that there is an issue.

We were issued a PTE Fix.

We are testing the fix in a sandbox environment.

I would encourage all to contact their support partner to get this fix. I am not sure if the fix we were given is customized for us.

Was this reply helpful? Yes No
Suggested answer

jjku on at

Like (1)

Report
[View:/cfs-file/__key/communityserver-discussions-components-files/758/PTEFixBankReconciliation.zip]

The PTE Fix is from MS.

These are the instructions from our partner. I HIGHLY RECOMMEND YOU DO THIS ON A SANDBOX VERSION TO MAKE SURE IT WILL WORK. I ALSO HIGHLY RECOMMEND YOU TALK TO YOUR SUPPORT PARTNER BEFORE DOING THIS. We have NO customizations when it comes to the bank, and you may have. So, I highly suggest you talk to your partner before you apply this fix.

To deploy this, please follow the instructions below.

Unzip/extract the records to desired location.

In Business Central, navigate to Extension Management.

From here, select Manage>Upload Extension.

While on the Upload and Deploy Extension window, select the look up for ‘Select .app file’ and browse out to the location you saved your package to, and select the .app file.

Once populated, select ‘Accept’ and then ‘Deploy’.

You can monitor the deployment status from the Installed Extension page. Should take just a few minutes.

Once deployed, you will see these new options:

This is the process you need to follow to correct those corrupted entries and post the bank acc rec:

Use PTE to clean up the applied entries (entries with Statement Status: “Check Entry Applied” or " Bank Acc. Entry applied" and the statement no and statement line are blanks)

If a bank ledger entry has a related check ledger entry, you should correct the “bad records” from both tables

Go to bank account ledger entries and/or check ledger entries and click PTE Open Entry button. This will “open” the entry, meaning it will “unmatch/unapply” the entries. Statement Status will become Open, Statement No. and Statement Line No. will be blank. Then, you would be able to match these transactions again.

Delete the Open Bank Recon

Recreate bank reconciliation

You may uninstall the extension afterwards on the Extension Management page.

Was this reply helpful? Yes No
Verified answer

jjku on at

Like (1)

Report

Just to update everyone, the fix worked for us.

Was this reply helpful? Yes No
MG_PNW 10 on at

Like (0)

Report

jjku Thanks for the good info. We received a fix as well and it worked.

Was this reply helpful? Yes No