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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Bill of materials calc...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Bill of materials calculations

(2) ShareShare
ReportReport
Posted on by CU09101616-0 64
My client is currently migrating from another system and need to get all stock into d365.
 
The finish goods are produced in GSM ( grams per square meter  - paper unit of measure). 
 
To make the finish goods, the product is composed of:
 
Product color ( another bill of materials in L/M)
Product formula  ( another bill of materials in KG)
Product Substrate ( a raw material in 100m2)
Color pigments ( raw material in l/m)
 
The product substrate can have multiple width and weight.  The product formula can have multiple weights. 
 
The color pigments are a percentage of the product formula quantities. 
 
So taking this into consideration, how can we setup different weights per product if the bill of material UNIT is different? The main issue I'm facing is that the stock unit for the substrate is 100m2 and I'm not sure how to convert it to kg.
 
Thanks
 
Categories:
Dynamics 365 Supply Chain Management
I have the same question (0)
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,538 Super User 2025 Season 2 on at
    Good morning, afternoon, or evening :) depending on your location!
    Hope you are well today.
     
    To address the challenges of managing different units of measure (e.g., GSM, KG, L/M, and 100m²) in Dynamics 365 and accurately calculating weights, here’s a structured approach to setting up and handling your Bill of Materials (BOM):
    Steps to Handle Different Units:
     
    1. Define Unit of Measure Conversions:
      • Use the Unit of Measure Conversion feature in Dynamics 365 to set up conversions between units.
      • For example:
        • Convert 100m² substrate into KG based on the weight per square meter. If you know the GSM (grams per square meter), you can use the formula: [ \text{Weight (kg)} = \frac{\text{Substrate area (m²)} \times \text{GSM (g/m²)}}{1000} ]
      • Set up this conversion formula in the system for consistent calculations.
    2. Set Up Product Dimensions:
      • Configure Product Dimensions for items like substrate to account for width and weight variations.
      • Use these dimensions in BOM calculations to adjust material quantities dynamically.
    3. Use BOM Templates for Different Products:
      • Create BOM templates in Dynamics 365 for each product configuration. For example:
        • One template for substrates with variable widths and weights.
        • Another for formulas with multiple weight options.
      • Include unit conversions directly in these templates.
    4. Automate Calculations with Custom Fields or Plugins:
      • Add custom fields to automate the calculation of weights based on unit conversions (e.g., GSM → KG).
      • If complex calculations are needed, create a custom plugin or script to handle conversions and update the BOM dynamically.
    5. Set Up Relationships Between Components:
      • Establish relationships between components, such as:
        • Color Pigments: Use percentage-based calculations tied to the Product Formula's weight.
        • Substrate: Link substrate variations to product configurations via dimensions.
    6. Validate BOM Configuration:
      • Test your BOM configurations thoroughly in a sandbox environment to ensure unit conversions and dependencies work as expected.
    7. Stock Migration and Initialization:
      • During migration, ensure all stock data is accurately converted to the new unit of measure system.
      • Use Excel templates or data migration tools in Dynamics to import BOM and stock details.
     
    Example Configuration:
    Component Unit of Measure Conversion/Formula
    Product Substrate 100m² GSM × Area ÷ 1000
    Product Formula KG Direct entry
    Product Color L/M Direct entry
    Color Pigments % of Formula Formula Weight × Percentage ÷ 100
     
    Tools to Use in Dynamics:
    • Unit Groups: Define unit groups for GSM, KG, L/M, and m².
    • Product Configuration: Use product configuration settings to handle variations in substrate dimensions and formula weights.
    • Custom Calculations: Use JavaScript or Power Automate to handle dynamic unit conversions.
     
     
    Hope this helps!
     
     
     
     
     
  • Adis Profile Picture
    Adis 6,069 Super User 2025 Season 2 on at
    Hey,
     
    What you can also do. Instead of calculating the exact weight, you can calculate an approximate value - if it is possible. The BOM quantities are important in order to deliver the good from warehouse to production floor, however, you can weight the exact consumption and consume it during production. 
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 301 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Siv Sagar Profile Picture

Siv Sagar 105 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans