How to increase decimal places??

(0) Share

Report

Posted on by Hammad Rauf

670

How to increase decimal places from 2 to 4 in Ax 2009 in all forms(Purchasing, Selling, Items movement and costing e.t.c)

I need urgent help on this..

*This post is locked for comments

All responses (12)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: How to increase decimal places??

Not really correct, no. If you intend to change decimal places, it is your, and your developers' responsibility to find all places that uses that EDT/table field, rounding rule, or any pieces of code that does hardcoded rounding, then change it, so your system does not break.

Generally speaking, decimal places can be changed just fine, you have to do it the right way though.
Rahul Shah 2,692 on at

Like (0)

Report

RE: How to increase decimal places??

Hi Andre,

For one of our customers, we had setup the decimal precision up to four decimals for the UOMs (sales unit, inventory unit etc) and later we had an issue while processing the product return. By default AX shows inventory up to 2 decimal places in GUI (not sure if we can change this behavior as well) and hence I assume it is advisable to set up decimal precision up to 2 decimal places as well. Is my assumption correct or?

Regards

-Rahul
cpironmo on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: How to increase decimal places??

Hi,

Just to explain my problem earlier and review the solution offered, we have received a purchase invoice with amounts to 5 decimal places.

When we try to enter this into AX, we can obviously only enter up to 4 decimal places.

Now I have a problem that when these 5 decimal place unit prices are multiplied by the quantity the difference between reporting only 4 decimal places to 5 decimal place will differ rendering the system incorrect

Could I remove the unit price and just enter a new net amount, but this then may be subject to some form of rounding, which is where my problem lies. Is there a way of getting around such roundung.

The solution given doesnt seem correct as there is no Per Series on the Purchase order form this is BOM functionality and is not where this problem lies.

If there is no solution then there is a huge gap in the AX functionality and I cannot see how it can be used accurately.

I also changed the regional settings on my computer but to no avail.
Christopher Mercado 106 on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: How to increase decimal places??

The decimal amounts being displayed for example like journals, bank accounts, etc. is dependent upon the Regional Settings of your computer. If you increase the decimal to 4 on your Windows Settings, after you restart AX you will see the change the display on the decimals.
Denis Patrakov on at

Like (0)

Report

Re: Re: Re: Re: Re: How to increase decimal places??

[quote user="Chris Ironmonger"]is there an option you know of to adjust the PO total to match the PI[/quote]Here it is:[quote user="André Arnaud de Calavon"]When specifying a price u can also specify the price unit. If you need a cost price of 3.5436. You can specifiy a price of 354.36 per 100.[/quote]And it's absolutely useless to modify extended data types (EDTs) properties for prices and amounts as anyway the system rounds amounts in too many places (especially in classes related to posting to the general ledger). And if somehow you manage to get a PO with a total that has more then 2 decimals (like 100.0123) you just wouldn't be able to post an invoice for such a PO as the system will try to post a rounded amount to the GL (it always rounds amounts posted to the GL) and would complain that the amount wouldn't match your PO total.
cpironmo on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: How to increase decimal places??

I'm not quite sure what the problem is but with the decimal places, I've looked into changing the data type properties of such data types as money and any inherited types but this seems a very long winded and dangerous path to go down as other applicaiton object will utilise such data types.

Hopefully someone can help with this problem as I need it resolving before we can process certain purchase invoices in this fiscal period. !?!?!?!?!!?
Ranulfo Davantes 45 on at

Like (0)

Report

Re: Re: Re: Re: Re: How to increase decimal places??

Hi All,
I am having the same issue on decimal places.
There is this function Modify Data Type (under Administration>Setup>System>Modify Data Type) which allows user to change the amount decimal places (user defined). I don't however understand the rationale, while it allow user to modify the amount length and amount decimal place in the table, the amount field in journal window do not follow the setting performed in the Modify Data Type window but, the other data type (e.g. account length) accepts the changes in both window and table.
Don't you think this is a product bug?
cpironmo on at

Like (0)

Report

Re: Re: Re: Re: How to increase decimal places??

Andre,

I'm currently having a similar problem,, I understand it will be too much to change the decimal places in the data types but is there an option you know of to adjust the PO total to match the PI.
Chris
André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

Re: Re: Re: How to increase decimal places??

Hi,

Due to the many data types and the extendings it is not recommended to increase the standard decimal places. Troughout the whole system base types are used in coding.

When specifying a price u can also specify the price unit. If you need a cost price of 3.5436. You can specifiy a price of 354.36 per 100.

If you still want to adjust the decimal places you have to take a deep look in the sructure of extended data type and probably have to change lot of coding. We tried to do it some years ago but found too much disadvantages.

regards,

André
Hammad Rauf 670 on at

Like (0)

Report

Re: Re: How to increase decimal places??

@ Mr. Yousef and Henke

For example we enter cost amount in Movement Journal of Inventory but it is upto 2 decimals i want to increase it to 4 in the system where ever the cost of the item is entered and more over the impact of it in the system shall be available in 4 decimal places as well.