Notifications
Announcements
No record found.
Hello Experts,
I am trying to find out why there comes a difference in closing balance amount in trial balance for a main account and ledger balance amount for the same main account in vendor reconciliation report? this should ideally be same right? How to investigate and rectify this difference?
I am using AX 2012 R2 CU6
Regards,
Karan
Hello Karan,
If you run the reconciliation report with the show detail parameter enabled you should be able to see the vouchers that generated the difference.
Check those vouchers and the underlying original documents to identify what happened.
Best regards,
Ludwig
Hello Ludwig,
Ok so whichever vouchers are populated in the report, all those vouchers will be responsible for the difference right?
and how to identify what went wrong in those vouchers?
Karan Nair
Hi Karan,
Hope you are running both report and trial balance for the same period. However I could see fix available for same issue for Ax7 but not 2012R2.
https://fix.lcs.dynamics.com/Issue/Details?kb=4042970&bugId=3846033&dbType=2&qc=a3cd3ed31e2caa7ac7d6c346c5b32ed5b749d7484eb1f9c8d6f0c90ce11cdcd2.
Thanks,
Sreepriya.
Note: This post is my own opinion and does not necessarily reflect the opinion or view of my company.
“If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.”
Hello Sreepriya
Yes i am running both the report and trial balance for same period. However there are discrepancies only from a particular month onwards.
till particular months the closing balance amount in trial balance and the ledger balance amount in the vendor reconciliation report matches
After that there arises differences in both the amounts.
do you have any idea regarding which table data to check to identify the difference.
Once you have those vouchers, you have to check on which accounts there were posted and whether those accounts are still setup in your posting profiles or whether some changes have been made to them.
That can be a lengthy task but that's the only one I know to identify the underlying issue.
There are a lot of vouchers. will i need to check for each voucher individually?
Can you share a screenprint of the reconciliation report?
I would only check the vouchers where you see a difference between GL and AP.
If you have many than something might be systematically wrong with the way how things are configurated.
Would be great if you could share some additional details / screenprints.
Many thanks,
I found out there are 2 vouchers which are causing the difference and which are not present in the report but both the vouchers are posting to the correct account. What could be the reason that those 2 vouchers are not getting displayed in the report?
Can you share some screenprints how you identified the difference if those vouchers are not shown in the report?
Its difficult to grasp that without having any other detail.
I compared both the amounts by running the detailed trial balance report for closing transactions and vendor reconciliation report for 1 day from where the difference is coming. After analyzing both the reports i found out 2 vouchers are not present in the vendor reconciliation report which is causing the difference in the total amount. Please suggest me what could be the possible reasons why those vouchers were not not included in the report.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 467 Super User 2025 Season 2
Martin Dráb 420 Most Valuable Professional
BillurSamdancioglu 241 Most Valuable Professional
