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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Account payable reconc...
Microsoft Dynamics AX (Archived)

Account payable reconciliation

(0) ShareShare
ReportReport
Posted on by Community Member

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

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

    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

  • Community Member Profile Picture
    Community Member on at

    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

    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 on at

    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.

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

    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 on at

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

    Imane.

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 Giving Solutions is Here!

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

#2
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#3
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans