You’re offline. This is a read only version of the page.
Announcements
30
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 Ludwig,
It has been resolved. There was a PO associated with a subledger journal which was not invoiced and hence was causing the difference.
Many thanks
Regards,
Karan
Hi Karan,
Can you share a screenprint of those vouchers and the transaction origin.
Is it possible that the account used is somehow filtered out in your report?
Also, have you checked the subledgers affected by those vouchers? That is, are those voucher related to the vendor subledger and is this subledger visible in the transaction origin form?
Best regards,
Ludwig
Hello Ludwig,
In the transaction origin form, both the vouchers have been posted to the correct main account and are present in the detailed trial balance report, yet both the vouchers are missing from the report
Regards,
Karan
Hello Karan,
If you have identified the vouchers, can you open the transaction origin form?
What do you see there?
Do you have some background information about the nature of those vouchers and where they are posted?
Best regards,
Ludwig
Hello Ludwig,
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.
Regards,
Karan
Hello Karan,
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.
Many thanks,
Ludwig
Hello Ludwig,
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?
Regards,
Karan Nair
Hello Karan,
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,
Ludwig
Hello Ludwig,
There are a lot of vouchers. will i need to check for each voucher individually?
Regards,
Karan
Hi Karan,
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.
Best regards,
Ludwig
#1
André Arnaud de Cal...
294,206
Super User 2025 Season 1
#2
Martin Dráb
232,968
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
