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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Set up rounding rule price to 9 digits 0.000000001

(0) ShareShare
ReportReport
Posted on by 287

Hi All, 

In our purchase order lines, we use to enter price=$2,555,555.00  in Quantity field, unit = Dollars and quantity=1 in Unit price field to do partial receive. Here we will enter the purchase order using procurement category, not the items. We noticed some difference ($81) in manual and ax sales price calculation when the rounding rule is setup to 0.0001.

Therefore i increased the rounding rule to 0.000000001 and there is no difference in ax calculation and manual calculation.  

Currency rounding rule setup form, 

Rounding-rule-setup.png

Item Transaction in project accounting and management module,

2671.Item-transaction.png

1) Increasing the rounding rule decimal to 9 digits is good idea to resolve this? 

2) Is there any alternative to fix this?

3) Increasing rounding rule will leads to any impact?

Please suggest me good solution. Thanks in advance. 

Thanks,

Banu.

*This post is locked for comments

I have the same question (0)
  • BanuReddy Profile Picture
    287 on at

    Thanks for your response Andre!

  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,714 Super User 2025 Season 2 on at

    Hi Banu,

    For procurement categories there is no setup for a price unit.

  • BanuReddy Profile Picture
    287 on at

    Hi Andre, 

    Project pricing mechanism means our customization is messing something for sales price calculation?

    or 

    you are saying entering unit price will not work when qty = 2555555.00 , Price unit=100000,00, Net amount=2555555.00, Unit=dollars?

    My client accepted the work around suggested by you , entering price unit =100000.00. That seems to working perfect for us. But net amount calculation will not happen automatically since unit price is empty.

    Can you please guide me is there any setup form in ax, where we can setup ,Price unit for the procurement category? I know for items we can setup price unit, which will be populated automatically while selecting the item in Purchase order or sales order.

    I really appreciate your help and time.

    Thanks, 

    Banu.

  • André Arnaud de Calavon Profile Picture
    301,714 Super User 2025 Season 2 on at

    Hi Banu,

    I do think that the project pricing mechanism is not working with the Unit price for sales prices.

  • BanuReddy Profile Picture
    287 on at

    Hi Andre, 

    If i Enter the unit price as 10000.00 and price unit as 100000.00 then my sales price is calculated as 135593.22, But my total sales amount is 346515932203.39 which is wrong, it should be 3465159.32.

    5824.image2.JPG

    5824.image2.JPG

    Thanks,

    Banu

  • André Arnaud de Calavon Profile Picture
    301,714 Super User 2025 Season 2 on at

    Hi Banu,

    Instead of entering the Net amount, you can also have a Unit price of 100000.00. For the sales the Unit price would then be 135593.2203

  • BanuReddy Profile Picture
    287 on at

    Hi Andre,

    Thanks for your input. It really helped me abundantly. I removed the Unit price and Entered the Price unit= 100000.00 , Quantity= 2,555,555.00, Net amount = 2,555,555.00

    Sales price calculated perfectelly.

    Thanks,

    Banu

  • BanuReddy Profile Picture
    287 on at

    Hi Andre, 

    When i enter the price unit as 100000.00, sales price is calculated perfectly. But my Net amount is not correct. 

    2703.Capture1.JPG

    2703.Capture1.JPG

    Awaiting for your response!!

  • BanuReddy Profile Picture
    287 on at

    Hi Andre, 

    Can you please guide me how to set up sales price 135593.2203 per 100000, i mean where i must do this setup?

    Thanks,

    Banu.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,714 Super User 2025 Season 2 on at

    Hi Banu,

    I do understand your question now. Have you tried to setup a sales price of 135593.2203 per 100000?

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

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans