Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Account Reconciliation form Showing Unreconciled amount after the bank is reconciled

(0) ShareShare
ReportReport
Posted on by 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

  • 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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans