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 :
Finance | Project Operations, Human Resources, ...
Unanswered

Absorption decimal places

(0) ShareShare
ReportReport
Posted on by 5

Hi community, 

In our costing sheet we have to set rates with 4 decimals for our output quantity based absorptions. The system only allows for 2 decimals. While D365 store up to 6 decimals and it is easy to display them via a mod, the amount of testing required to validate the calculation is an issue and a workaround would be preferred. 

Has anybody ever encountered that type of situation and if yes, how did you solve the issue? I am interested in your feedback for both the workaround and the modification. 

Thank you, 

Darec

pastedimage1635541950971v1.png

I have the same question (0)
  • Darec Profile Picture
    5 on at

    Hello Ludwig,

    We need 4 decimal places because the legacy system allowed for that. By reducing the number of decimal places we would lose precision and over cost the products made.

    We want to absorb consumables per pound of quantity produced. The consumables are setup as backflushed items and do not appear on the formula.

    I hope this helps.

    Thank you,

    David

  • Alex VN Profile Picture
    1,994 on at

    Hi,

    I hope this document might give you some insight:

    docs.microsoft.com/.../decimal-point-precision

    Detail discussion on other thread:

    community.dynamics.com/.../how-can-i-change-the-number-of-decimal-places-to-three-for-price-and-quantity

    Work around from functional side that might be useful for you:

    www.encorebusiness.com/.../

    Regards,

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Darec,

    Why do you need 4 decimal places?

    Are you operating in a country/region that uses a currency that is denominated with 4 decimal places?

    Would be great if you could elaborate.

    Many thanks,

    Ludwig

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 503 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 288 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans