Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

Posted on by 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

  • Karan Nair Profile Picture
    Karan Nair 30 on at
    RE: Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

    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

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

    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

  • Karan Nair Profile Picture
    Karan Nair 30 on at
    RE: Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

    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

  • Karan Nair Profile Picture
    Karan Nair 30 on at
    RE: Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

    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

  • Karan Nair Profile Picture
    Karan Nair 30 on at
    RE: Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

    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

  • Karan Nair Profile Picture
    Karan Nair 30 on at
    RE: Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

    Hello Ludwig,

    There are a lot of vouchers. will i need to check for each voucher individually?

    Regards,

    Karan

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger Balance on Vendor to Ledger Reconciliation report does not match the Closing Balance from the Trial Balance report

    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans