web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Account Reconciliation...
Microsoft Dynamics AX (Archived)

Account Reconciliation form Showing Unreconciled amount after the bank is reconciled

(0) ShareShare
ReportReport
Posted on by binitshah 660

We have been following a weekly bank reconciliation in our implementation and we are facing a very strange issue that after the bank account is reconciled some how the ending balance don't sum up correctly.

Also after the reconciliation when I go to the accounts reconciliation form and click on the reconcile statement and the go to the transactions the transactions from shows a unreconciled amount.

Can someone help why this is happening?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Binit, What you describe sounds like a bug. Have you already check LifeCycle Services for an available hotfix? Ludwig

  • binitshah Profile Picture
    binitshah 660 on at

    Hi Ludwig,

    I did check for the issue on LCS but all I could found is this:

    The Opening Balance field in the Account reconciliation form

    is actually not a stored field. The form displays the Opening Balance field

    based on the Ending Balance from the previous' BANKACCOUNTSTATEMENT record for

    that bank account.

  • Stephen Bradford Profile Picture
    Stephen Bradford 170 on at

    Are you sure someone hasn't created a deposit slip for a transaction that has already been reconciled?

    This has happened to me, but I do not know how to unravel it.

    Steve

  • Suggested answer
    binitshah Profile Picture
    binitshah 660 on at

    Hi Steve,

    We found the error. This was happening in case two account reconciliations are open for the same period and both are reconciled on the same date.

    We made a little change in the code which will also pick the time of the reconciliation to bring the correct opening balance and hence the even the unreconciled balance became 0.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans