web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    binitshah Profile Picture
    binitshah 660 on at
    RE: Account Reconciliation form Showing Unreconciled amount after the bank is reconciled

    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.

  • Stephen Bradford Profile Picture
    Stephen Bradford 170 on at
    RE: Account Reconciliation form Showing Unreconciled amount after the bank is reconciled

    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

  • binitshah Profile Picture
    binitshah 660 on at
    RE: Account Reconciliation form Showing Unreconciled amount after the bank is reconciled

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Account Reconciliation form Showing Unreconciled amount after the bank is reconciled

    Hi Binit, What you describe sounds like a bug. Have you already check LifeCycle Services for an available hotfix? 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans