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

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?

  • 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,265 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,927 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans