Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

How to increase decimal places??

Posted on by 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

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    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 Profile Picture
    Rahul Shah 2,692 on at
    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 Profile Picture
    cpironmo on at
    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.
  • 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.

  • 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 Profile Picture
    cpironmo on at
    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 Profile Picture
    Ranulfo Davantes 45 on at
    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 Profile Picture
    cpironmo on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 291,151 Super User 2024 Season 2 on at
    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 Profile Picture
    Hammad Rauf 670 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans