Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Vendor/Ledger Reconcil...
Microsoft Dynamics AX (Archived)

Vendor/Ledger Reconciliation report

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Dear Experts,

I faced a strange issue related to Vendor/Ledger Reconciliation report  and PO invoice with COD term (cash on delivery payment term).

I posted 1 PO invoice with COD payment term, AX posted 1 voucher number and 2 journal number

Voucher number 1

Journal 1

Dr Expense 10

Cr Vendor code A (Ledger account A) 10

Journal 2

Dr Vendor code A(Ledger account A) 10

Cr Cash

-> So the value of Vendor balance = 0 = ledger balance A

But the report Vendor/Ledger Reconciliation showing as below:

Ledger A, Voucher 1, journal 2, Vendor code A, ledger balance is 10, vendor balance 0, difference is 10

Does anyone know the reason and how to fix it?

Thank in advance,

Best regards,

Thu Ngo

Vendor/Ledger Reconciliation report

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor/Ledger Reconciliation report

    Hi Thu Ngo,

    There are a couple of related fixed available on LCS. Please also check them. If you are not sure which one might fit get into contact with the MS support. You pay for it anyway and they should be able to point you to the correct fix.

    Best regards

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor/Ledger Reconciliation report

    Hi Ludwig,

    I discussed with our TC, he said this is not related to the issue.

    Best regards,

    Thu Ngo,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor/Ledger Reconciliation report

    Hello Thu Ngo,

    AX2012R3CU12 was released in Nov 2016.

    In Jan 2017 the following hotfix was released that seems to address the issue you describe:

    KB 4010849Vendor balance posting type repeated on COD invoice

    Can you check and install this fix with the help of a developer to check whether it resolves the issue?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor/Ledger Reconciliation report

    Hi Ludwig,

    We used AX2012,R3 CU12. Please refer to the screenprints  I took in our test environment: Transactions and report

    COD.PNG

    Best regards,

    Thu Ngo,

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor/Ledger Reconciliation report

    Hi Thu Ngo,

    Is it possible that you make screenprints of your COD term, the transactions posted and the variance you see in the reconciliation report?

    Also let us know what AX2012 version you operate R2, R3, CU10, 11, etc.

    Many thanks and 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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,401 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans