web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to generate comple...
Microsoft Dynamics AX (Archived)

How to generate complete subledger for trade creditors/vendors

(0) ShareShare
ReportReport
Posted on by Community Member

I am currently trying to reconcile our vendor trial balance accounts to the subledger and am working with the following reports:

- Vendor SL GL reconciliation (General ledger>reports>vendor>vendor)

- Vendor aging (Accounts payable>status>vendor aging)

- Vendor balance list (Accounts payable>status>vendor balance list)

- Vendor detailed due day list, vendor transactions and vendor invoice transactions (AP reports used for supplementary checking)

When I generate these reports, none of them agree with the vendor balances in the SL-GL reconciliation report. For one company I am checking, the vendor aging and vendor balance list agree, but they don't agree with the reconciliation report. What's more is that the subledger and the general ledger balances in the reconciliation report also don't agree.

What are the differences of these reports that they generate different balances and report would be most reliable to use as the subledger report?

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello pepper,

    The vendor balance list should normally be sufficient for the reconciliation process.

    If you can't reconcile the GL and vendor balances then there are very often manual transactions recorded on the vendor summary accounts. Can you check whether this is the case?

    In addition, the reconciliation report in GL should list you the vouchers that caused the variance between the ledgers. Have you tried analyzing those vouchers?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thanks for the prompt response.

    The composition of the transactions in the subledgers are often APVs, CVs and JVs. From what I understand, these kinds of transactions would normally flow right through the subledgers and should not be different in the trial balance. When the reconciliation report is generated and the vouchers with differences are analyzed, the trial balance figures pick up different amounts. What would be the usual cause for this?

    On your first point, I also assume that the vendor balance list functions as the subledger for each vendor although it does not contain the transaction vouchers per vendor. I look at the aging report for the breakdown. However, i cannot use it as a supplement for the reconciliation of GL and SL (in the GL module) as the vendor balance in that report does not agree with the vendor balance list. The reports are generated few minutes apart.

    In summary, I would have to reconcile 3 items: (a) reconciliation of GL and SL differences (b) agreeing the vendor balance list/vendor aging to the vendor balance of the GL SL recon report and (c) finally agreeing the correct balance to the GL balance.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi pepper,

    Unfortunately, there is no real shortcut available for that and you already found the correct reports for the reconciliation job.

    Yet, there are two things that might help

    (1) The reconciliation reports in GL should show you the vouchers that cause the difference, which limits the time required for searching

    (2) If you want to be really fast with the reconciliation, then introduce an additional 'vendor' financial dimension. If you have this, then you can make use of the Trial Balance list page to quickly identify vendor transactions that were recorded on the wrong ledger account.

    Best regards,

    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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans