Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Account payable reconciliation

Posted on by Microsoft Employee

Hello community,

I can't find no difference between Balance list report and vendor balance list report, but i get a difference in the vendor reconciliation report. How can this happen even if i've choosed the same period?

Thank you,

Imane.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Account payable reconciliation

    Thank you Ludwig. But tell me please where can i find that summary vendor account?

    Imane.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Account payable reconciliation

    Hello Imane,

    A common reason for such a difference is when people record transactions in GL on the summary vendor account.

    Other common reasons include account changes that have subsequently been made in the vendor posting profile.

    Answering this question is, however, not straightforward and requires a detailed investigation into the posted transactions.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Account payable reconciliation

    Hey Ludwig,

    Even if i don't get a difference in the reconciliation  report,  i can see the difference when i campare the vendor balance list with the GL balance. That means i have a difference , do i ?

    Can you please explain to me why there is a difference between  the result of reconciliation report and the result of vendor balance compared to GL?

    Thank you.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Account payable reconciliation

    Hello Imane.Iam,

    I think this is a matter of choice. I prefer starting with the reconciliation report and investigate the vouchers that show a difference between AP and GL.

    In addition, I usually run the vendor balance list and compare the balance shown with the vendor summary account balance. This should result in the same difference. Yet, the reconciliation report has the advantage that you can directly identify the voucher for a detailed investigation.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Account payable reconciliation

    Hey Ludwig,

    Yes i can see the difference, but i don't understand the process. Should i see the reconciliation report at first or generate the Balance list in orther to compare it with the vendor balance list? I mean what is the reliable report in here?

    Many thanks.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Account payable reconciliation

    Hello Imane,

    The vendor reconciliation report should show you the vouchers that caused the difference.

    Can you open and investigate those vouchers?

    Check especially the transaction origin that shows the association to the different subledger modules.

    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans