Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

Decimal precision in BOM Lines and Costing sheet

(0) ShareShare
ReportReport
Posted on by 75

Dear Team,

The scenario is out of 3600 Kgs of compounded Latex you can produce 2.25 Million condoms

For One condom, the compounded latex comes to .0016 because averagely a condom weighs 1.6 grams

When I define this in BOM, while running costing version, it is not picking up .0016 because it picks only two decimals

How this can be solved

If I use formulas, then the precision would be higher

But costing version run, is picking only 2 decimals from BOM Line

Any way to solve this

Thanks

Vivek

  • Verified answer
    Andreas Raithel Profile Picture
    4,941 Super User 2025 Season 1 on at
    RE: Decimal precision in BOM Lines and Costing sheet

    For small quanities in BOM line you can use fileds "quantiy" and "per series", e.g. "quantiy = 1,6 " (grams) and "per series =1.000" to get small values of consumption to the BOM line.

    For small prices general (your other post) you can use "price quanitity" to handle small prices in a convenient way (sales, purschase, costing). "Price Quantity" is used to shift the decimal separator to left to get more decimals, also in calculations

    Hope this helps.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Zain Mehmood Profile Picture

Zain Mehmood 126 Moderator

#2
Siv Sagar Profile Picture

Siv Sagar 109 Super User 2025 Season 1

#3
Laurens vd Tang Profile Picture

Laurens vd Tang 50 Super User 2025 Season 1

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans