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

I have the same question (0)

All responses (12)

Answers (0)

Community Member on at

Like (0)

Report

Re: How to increase decimal places??

Hi,

Can you please provide more details on what exactly you mean of deceimal places do you mean real fields decemial placeses???

Regards,

Yousef Shawareb

Was this reply helpful? Yes No
Henrik Nordlöf 249 User Group Leader on at

Like (0)

Report

Re: How to increase decimal places??

I'm using a swedish version so the menu names could be wrong.

Basic-Settings-Units, chose the decimal places you like for each unit.

/Henke

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,576 Super User 2025 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é

Was this reply helpful? Yes No
cpironmo 2 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

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No
cpironmo 2 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. !?!?!?!?!!?

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
cpironmo 2 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.

Was this reply helpful? Yes No