Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Vendor to ledger recon...
Finance | Project Operations, Human Resources, ...
Suggested answer

Vendor to ledger reconciliation difference due to PO invoice extra line, how to resolve?

(1) ShareShare
ReportReport
Posted on by AXSHAH 528
We find the differences in the vendor to ledger reconciliation report and found some discrepancies. How to resolve this issue? 
Contacted Microsoft support and so far no progress. 
 
 
 
The investigation shows that the PO invoice in the sub-ledger is -5,292.00 whereas in the voucher the amount is -2,412.00.
 
Sub-ledger - Vendor transaction
 
 
Voucher:
 
 
The PO invoices show there is an extra line: This is causing the issue
 
 
Dynamics 365 Finance and Operations
Version 10.0.37 (10.0.1725.123)
Platform Update61 (7.0.7068.130)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Vendor to ledger reconciliation difference due to PO invoice extra line, how to resolve?
    It seems there is some data corruption on this transaction.  Best to submit a MSFT ticket and see if they can analyze and correct it for you.
  • AXSHAH Profile Picture
    AXSHAH 528 on at
    Vendor to ledger reconciliation difference due to PO invoice extra line, how to resolve?
    @Frank Hamelly
     
    The amount of 3240 was not posted anywhere. and this is the problem as we cannot adjust.
     
    @Billur
    In typical direct ledger entries would show up and we can pass the adjustment entry, in this case, there is an extra line reducing the ledger balance, whereas the vendor level balances are fine. It is caused due PO invoice lines and we have many cases. 
     
    The auditors from Big4 will question us and we have no definite answer as to what causing this issue. 
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Vendor to ledger reconciliation difference due to PO invoice extra line, how to resolve?
    Which account did the 3,240.00 post to?
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,786 Most Valuable Professional on at
    Vendor to ledger reconciliation difference due to PO invoice extra line, how to resolve?
    Hi,
     
    for these kind of discrepiencies, you can use GL journals and post transactions to GL accounts without to select the vendor account.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans