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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Vendor to ledger reconciliation report does not match with Open vendor invoices

(0) ShareShare
ReportReport
Posted on by 92

While comparing the open vendor invoices Total Amount and it should match the Vendor to ledger reconciliation report.

However, there is a huge difference between these two. 

We have a Invoice transaction which is unsetlled wherein it is not appearing in VENDOR OPEN INVOICES LIST.

Any suggestions.

I have the same question (0)
  • Suggested answer
    BillurSamdancioglu Profile Picture
    20,825 Most Valuable Professional on at

    Hi,

    Can you please check if the field approved is set to "Yes" on that open transaction.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,853 Super User 2026 Season 1 on at

    Hi Depesh,

    Do you get difference on Vendor/Ledger reconciliation report to find if there is diff balance between ledger and vendor?

    Do have several vendor posting profiles in the organization?

  • buzz Profile Picture
    92 on at

    Hi,

    I just observed for this transaction APPROVED is set to NO, may I know how to enable this now?

    Thank you!

  • Suggested answer
    BillurSamdancioglu Profile Picture
    20,825 Most Valuable Professional on at

    Hi,

    This depends to the procedure. If you are sure that this is not managed by any workflow or approval journal postings, you can manually change on the vendor transactions by editing.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,853 Super User 2026 Season 1 on at

    You can find "Approved" function on Vendor transactions > General tab

    pastedimage1664285145021v1.png

    Before updating the invoices to approved manually, please make sure that they have been posted completely (i.e. some vendor invoices are posted via invoice register that will be posted with expenditure account via Invoice approval, it means that they should be processed on Invoice approval and then they will be updated with "Approved" on vendor trans.)

  • buzz Profile Picture
    92 on at

    Hi,

    Thank you so much for your help.

    I have tried now to enable from General Tab > Approved - YES it is available in OPEN VENDOR INVOICES  and Settle Transactions as well.

    Yes - it is correct this Invoice posted via Invoice Register still it is pending in Invoice Approval I have verified in Find Vouchers and I have got this voucher there.

    This is resolved.

    May  I know any suggestions on my first question  

    While comparing the open vendor invoices Total Amount and it should match the Vendor to ledger reconciliation report.

    However, there is a huge difference between these two.

  • buzz Profile Picture
    92 on at

    Hi,

    The vendor to ledger reconciliation report is matching the general account, but not the open vendor invoices which it should.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,853 Super User 2026 Season 1 on at

    Hi Depesh,

    Have you posted the Invoice approval journal so the invoices get approved or do you have updated the approved field manually?

    Regarding vendor to ledger reconciliation report, do you get difference on Vendor/Ledger reconciliation report?

    Do you use the same period when you compare vendor to ledger reconciliation report to open vendor invoices?

  • Suggested answer
    BillurSamdancioglu Profile Picture
    20,825 Most Valuable Professional on at

    Can you please check if the open transaction balance is the same with the trial balance.

  • buzz Profile Picture
    92 on at

    Hi,

    As you mentioned through Open Vendor Invoices > General tab > Edit I tried, I am able to enabled APPROVE option later I disabled it and checked 2nd way

    I have checked Inv. Reg only it is posted so, tried to post Inv.Approval Journal now it is available in Settle Transactions and Vendor Open Invoices as well.

    Yes, I am taking same period for report but Open vendor Invoices showing all  Invoices for Previous years as well in that case how to match?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 608

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 591 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 430

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans