Wrong vendor retention calculation after entering total discount

(0) Share

Report

Posted on by Ahmad

Dears;

I made a PO related to a project. Each line has a vendor retention term. When I invoice the PO, the retention is calculated correctly.

For Example:

the total PO amount is --------- 15,000.

Retention is 5% -------- 750

VAT is 5% -------- 750

The invoice voucher is showing correct values. When I am doing the same PO and adding total discount 0.5%, I am getting wrong retention calculation. When I go to subledger screen in the invoice voucher I find two records for retention. The first record has 750 (the correct amount), and the second record has 250 (wrong amount). So the total retention is 1000 which is wrong. The correct amount is 750. This case only happens when total discount is entered. Without total discount it is running fine. I tried to debug and track the retention calculation but I could not find any bug there.

Any clue for this case? Please be noted that I am using Dynamics AX 2012 R3 with CU 12.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Ahmado,

Where do you add the total discount of 0.5%? At the PO header level?

Can you share a screenprint that illustrates the PO and the retention amounts that you see?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Ahmad 34 on at

Like (0)

Report
Copy link

Link copied!

Yes it is at the PO header.

Please see the following screen shots:

As you see retention should be 750 but it is showing 1000

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

The retention is calculated at the line level. Your discount is entered at the header level.

Have you tested whether entering a line discount of 0.5% for each of your lines makes a difference?

Best regards,

Ludwig

Was this reply helpful? Yes No
Ahmad 34 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig;

Yes I tried to put the discount percentage in the PO lines and unfortuantely it gave wrong retention value. Retention should be 750 but what is given is 980 or around 1000.

Any clue for this? Or can tell me what is the class or piece of code that is responsible to write the invoice voucher and subledger entries so I can trace the code there.

Thanks a lot

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Ahmado,

I currently do not have a CU12 machine available to double check.

Can you replicate the issue on a different demo/test machine?

If this is the case then I would recommend that you are getting into contact with the MS support to get this fixed for you. Might be a bug.

Best regards,

Ludwig

Was this reply helpful? Yes No