Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans