web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Rounding Off Price in ...
Microsoft Dynamics AX (Archived)

Rounding Off Price in Purchase Order

(0) ShareShare
ReportReport
Posted on by Community Member

Dear All,

My client wants 6 decimal places for Prices. I customized the EDT for AmountCur and set it to display 6 decimal places. I have configured in Currencies the rounding rule and have also set in trade agreement a purchase price of 6 decimal places. My units are also configured to 6 decimal places. Nonetheless, in PO form, it automatically populate the unit price rounded to 2 decimal places. I'm running out of places to configure, any ideas? I need it not to round off. I have come across this and i agree that ax should cater decimal places greater than 2.

Thank you,

Lyka Tasis

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at
    Re: Rounding Off Price in Purchase Order

    Dear Corey,

    I was able to display 6 decimal places and fix the rounding via correct configuration of rounding rules in the Currencies form.

    I changed the NoOfDecimals of the following EDT to 6 and synchronize afterwards:

    • Amount
    • Price
    • PriceRoundOff

    My mistake was, I was adjusting the Rounding Rules of Purchase Orders. With this setup, you could set the Agreements up to 6 decimal places but it would automatically round off to 2 decimal places in purchase line. I adjust the Rounding Rules of Prices and it turned okay.

     

    I read the code and by default, if the rounding rule is 0, the round amount is 0.01.

    Hope this helps.

  • Suggested answer
    Corey Warawa Profile Picture
    Corey Warawa on at
    Re: Rounding Off Price in Purchase Order

    Lyka,

    We are using the "Price unit" field on the Price/Discount tab on the PO line.  As an example if we want a unit price of $1.463 we type $14.63 in the unit price field (only 14.6 is displayed in the form), then we put "10" in the price unit field.  This will result in AX moving the decimal point 1 position to the left.

    We have not been able to determine a way to display more than 2 decimal places in the PO Details form.

    Corey

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 2

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans