Microsoft Dynamics AX (Archived)

How to enter purchase order line with unit price more than two decimals

(0) Share

Report

Posted on by BanuReddy

287

Hi guys,

Can anyone suggest me how to enter POline unit price with three decimals instead of two decimals?

Ex:

Now the system allows us to enter unit price for the purchase line in two digits.

8171.Capture.JPG

If i enter three decimals,

1781.Capture1.JPG

The system converts this three decimals to two decimals and doing round off from 1.256 to 1.26

My requirement is the unit price must allow us to enter three decimals and it should not do round off. Because rounding off to two decimals affects my net amount calculation.

Waiting for your suggestion, as soon as possible.

Thanks in advance.

Banu.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello Banu,

Is this a country specific requirement?

In D365FO there is a new functionality for the UAE that allows using 3 decimal places.

As far as I am informed this is not available for other countries.

For which country do you need that?

Best regards,

Ludwig

Was this reply helpful? Yes No
BanuReddy 287 on at

Like (0)

Report

Hi Ludwig,

This is not country specific requirement. As of now we need this for USA country.

My Purchase team discussed to us, there is a scenario where our vendor sends the unit price for the item in three decimals. They are asking suggestion form us, how to enter the unit price if we receive in three decimals instead of two decimals.

My first line shows excel calculation, second line shows ax calculation.

Thanks,

Banu.

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (1)

Report

Hi Banu.

As already mentioned from Ludwig this is not easy. In my projects I was always able to discuss and explain this issue. At the end we always used the field "price unit". So there is no need for 3 or more digits.

If you have a price like 10,123 per piece you can enter a price of 10123,00 per 1.000 pieces. So the calculation of net amount is correct.

I agree, it is not optimal but a solution without coding.

Best regards

Christoph

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Banu,

Using more than 2 decimal places is complex. You can find a couple of threads where this is discussed.

Yet, as a workaround, can't you specify the price per 100 pcs instead of per peace?

Based on your example, this should overcome the problem.

Best regards

Ludwig

Was this reply helpful? Yes No
BanuReddy 287 on at

Like (0)

Report

Thanks Ludwig for your input.

Was this reply helpful? Yes No
BanuReddy 287 on at

Like (0)

Report

Thanks Christoph for your input.

Was this reply helpful? Yes No