: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.
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?
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