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

Community site session details

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

Mismatch in Ledger transactionand sub ledger transaction

(0) ShareShare
ReportReport
Posted on by 22

:Mismatch in Ledger Transaction and Sub Ledger Transaction


Vendor Retention amount is wrongly calculated between the ledger transaction and the sub ledger journal transaction.
The invoice is created to retain the retention amount, but the retention amount in the invoice line is correct but the voucher transaction is wrong.

pastedimage1598248793670v1.png

pastedimage1598248813411v2.png

The accounting distribution created the price variation for the Line 1 and Line 2, for those lines also retention 5% is calculated and added to the actual retention amount.
Actual Retention Amount 96,811.65
Line 1 Distribution amount(1222884 * 5% Retention) 61144.2
Line 2 Distribution amount(519480 * 5% Retention) 25974
Total 1,83,929.85

Why the system created the price variation for Line 1 and Line 2 and Ledger transaction is become wrong. How to fix this issue?

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Mismatch in Ledger transactionand sub ledger transaction

    Hi,

    Can you let us know what AX2012 version you operate?

    If you have this information, take a look at LCS for available hotfixes especially if you operate an older AX2012 version to ensure that the system behavior that you experience is not caused by a bug that has already been fixed by MS via a hotfix release.

    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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,206

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 596 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans