web
You’re offline. This is a read only version of the page.
close
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
Suggested Answer

How to create a Formula (BOM) based on Amount

(0) ShareShare
ReportReport
Posted on by 39

Hi All,

There is a requirement from the customer, is there a way to create and approve a formula (BOM) based on Amount?   

Formula can be able to create based on Amount and they can approve and activate??

Example: Let's say customer wants to produce a coffee and they have fixed amount to produce one coffee about 10 USD, so within that 10 USD we can adjust raw materials like

item 1: coffee powder 4 USD

item 2: milk 3 USD

item 3: sugar 3 USD.

like this can we able to manage or create a formula (BOM)?? if so, could anyone help in this regard.

Thanks in advance!

Regards,

Mannem.

I have the same question (0)
  • Suggested answer
    Hana Xue Profile Picture
    Microsoft Employee on at

    Hi Mannem,

    The cost roll-up and sales price calculations are known as bill of materials (BOM) calculations, and you initiate them from the Calculations page.

    To calculate costs for a single manufactured item, you initiate BOM calculations from the Item price page. The Calculations page inherits the item identifier. The costing version, BOM version, route version, calculation quantity, calculation date, and site must be specified. When you activate an item's cost record, you update the charges for the item's base cost information, which is displayed in the Item price form as well.  You can check the link for more information.

    BOM calculations - Supply Chain Management | Dynamics 365 | Microsoft Learn

    Formula designer - Supply Chain Management | Dynamics 365 | Microsoft Learn

    The screenshot shows the information about create a new formula in D365, more details are in the following link, you can check it as needed.

    pastedimage1682043156418v1.png

    Dynamics 365: BOMs or Formulas - What’s the Deal? | Ellipse Solutions

    Best Regards,

    Hana

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…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 284 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 178 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans