Purchase Invoice rounding problem

Hello,

In AX I have a purchase order line like:

item A 6 cartons price : 14,10 discount : 5% Total amount : 80,37

If I get the invoice from the vendor, the Total amount is 80,40

The problem is the rounding, AX calculates with a rounding of 3 : 6x13,395(14,1x0,95) = 80,37
The vendor calculates with a rounding of 2 : 6x13,40 = 80.40

I checked the currency settings, it is configured with 2 decimals.
Anybody else experience this problem or have a solution?

Hi,

When posting the PO invoice, click on the totals tab and enter a round-off value of 0.03.

That’s probably the easiest way to fix this issue.

Hope it helps.

Best regards,

Ludwig

hi

In this case Ax is calculating and rounding off for 2 dicimals only. 14.16=84.6, 84.65%=4.23, 84.6-4.23=80.37 . Ax calculates discount percentage on total amt.

but vendor calculates discount on unit price or if they are not using ERP, they have done manually roundoff for 80.37 as 80.40.

Hi, yes I understand where the problem is. I dont want to do a tota round off, because this vendor has multiple items, and the total round off would be around 2,00. Is there any way to tell AX to calculate the discount in a different way?

Totals form is a non editable , so how can user enter the round -off value.[:O]

Hi,

click the invoice button of your PO and select the totals button and enter a value in the round-off value field, which is editable.

you can use multiple discount or multiple discount % if you have multiple items.

Thanks Ludwing for the screen shots.

I was looking at the Purchase order - Inquiries - Totals ( here it is not editable )