Skip to main content

Notifications

Announcements

No record found.

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

  • Darec Profile Picture
    Darec 5 on at
    RE: Absorption decimal places

    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
    Alex VN 1,994 on at
    RE: Absorption decimal places

    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
    Ludwig Reinhard Microsoft Employee on at
    RE: Absorption decimal places

    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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,476 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans