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

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
Harisgillani Profile Picture

Harisgillani 4

#2
dekion Profile Picture

dekion 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans