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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Vendor reconciliation report

(0) ShareShare
ReportReport
Posted on by 220

Hi 

Hope you are all good

Is there any report available for vendor reconciliation with vendor invoice turnover? Invoice turnover showing correct balance or turnover but in Financial report when I generate report for creditor that time balance is different. I just wondering if any other report for reconciliation in D365FO

THANKS 

I have the same question (0)
  • Suggested answer
    Ramit Paul Profile Picture
    22,797 Most Valuable Professional on at

    Hi,

    have you explored the vendor to ledger reconciliation report in AP module?

  • MRizwan Profile Picture
    220 on at

    Yes but that report not showing data

  • Suggested answer
    Ramit Paul Profile Picture
    22,797 Most Valuable Professional on at

    Can you check if you have selected "Difference only"?

    If so, it will only show you if there is any difference, hence if there is no mismatch between vendor and ledger balance, then there will be no data.

    You can make that to  'No' the generate the report.

  • MRizwan Profile Picture
    220 on at

    Hi 

    Thanks, I can generate this report now with data and will update you after accounts department reply. 

    Regards

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Muhammad,

    For reconciling the vendor subledger, most people I work with use the following reports:

    * vendor balance list

    * vendor aging report

    * vendor to ledger reconciliation

    * vendor invoice turnover.

    The should be sufficient to ensure the data tie together and are consistent with what you see in GL.

    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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans