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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

How to handle cost for item

(3) ShareShare
ReportReport
Posted on by 129
How do we handle this:  we have items ( for example EXT2Y) that is the same style but different prices ... how do we handle that in the BOM  ??  as that is part of the problem for inventory transfer.
 
Cost 1  = 34
Cost 2 = 45
Cost 3  = 48 
I have the same question (0)
  • KasparsSemjonovs Profile Picture
    4,683 Super User 2025 Season 2 on at
    How to handle cost for item
    You can either select a specific purchase (via Applies-To item entry).
    Or You can use Item variants.
  • Suggested answer
    KrisMan Profile Picture
    32 on at
    How to handle cost for item
    It sounds like you have an item that has different items in the bill of materials.
    So it sounds like you need to have multiple items, each with a different bill of materials which correctly reflects the components in it.
     
    Alternatively, you can make the item an Assembly Item - Assemble to Order
    Then in the components of the BOM, you can list the prefered part with qty=1, and the optional parts with qty=0 (to do this you need to enter qty 1, move off the line, then come back to the line and set the qty to 0 on the optional part)
    This way you have assembly with qty 1 next to the mandatory parts, and qty 0 next to the optional parts.
     
    Then when you put the item on the sales order, and open the assembly components, you can select the parts the customer wants, then use Roll Up Price, to correctly calculate the price based on the parts chosen.
     
    PS it will also help to refer to Costs and Prices differently, costs are what it cost to purchase/make it, price is the sales amount. So technically your asking for costs and prices in the one q.
     
    If you can provide better detail, the community can answer more precisely.
  • Suggested answer
    Sumit Singh Profile Picture
    8,385 on at
    How to handle cost for item
    Hi, 
     
    There might be the case that I am not fully understood the question. 
     
    Sharing below approach as per my understanding. 

    Maybe you can use variants and try. I haven’t run the complete process, but you can try, maybe it helps;-
    • Create Item Variants for EXT2Y:
      • EXT2Y-01 → Cost 34
      • EXT2Y-02 → Cost 45
      • EXT2Y-03 → Cost 48
    • Assign these variants in the BOM lines, if variant field is not visible, please add it using personlisation. 
    Please try first in sandbox environment.
     
  • Suggested answer
    OussamaSabbouh Profile Picture
    1,232 on at
    How to handle cost for item
    Hello,
     
    Use item variants or separate items:
    If same style, different prices → create variants (each with its own cost).
    If completely different products → create different item numbers.
    Then update your BOM to use the right item or variant; Business Central will calculate costs accordingly.
     
    Regards,
    Oussama Sabbouh

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 2,039

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 1,863

#3
YUN ZHU Profile Picture

YUN ZHU 1,736 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans