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 :
Small and medium business | Business Central, N...
Suggested Answer

How to handle cost for item

(5) ShareShare
ReportReport
Posted on by 191
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,764 Super User 2025 Season 2 on at
    You can either select a specific purchase (via Applies-To item entry).
    Or You can use Item variants.
  • Suggested answer
    KrisMan Profile Picture
    70 on at
    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
    10,079 on at
    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
    5,789 on at
    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
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,639 Super User 2025 Season 2 on at
    Hello,
     
    You can use Item variants. Different Variant wise Different Costing will work and in the Prod BOM also you can select the Item Variant wise.
  • Suggested answer
    Valentin Castravet Profile Picture
    31,340 Super User 2025 Season 2 on at
    What’s your costing method: FIFO, Average, or something else?
     
    Business Central automatically manages item costs based on that setting, so we’d need more details to give an accurate answer. From what you’ve described, it sounds like the system already handles what you’re trying to achieve.
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    95,395 Super User 2025 Season 2 on at
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,378 Super User 2025 Season 2 on at
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    6,148 on at
    Hi,
     
    Business Central does not allow multiple costs for the same item directly in a BOM. If the style is the same but prices differ, you have two standard options:
    > Create separate item numbers for each cost (e.g., EXT2Y-A, EXT2Y-B, EXT2Y-C) and include the correct item in the BOM. This is the most common approach for accurate costing and inventory tracking.
    > Use Item Variants for style differences.
    For inventory transfers and BOM accuracy, separate items or cost-specific variants are recommended because Business Central calculates assembly cost based on the item’s cost setup.
     
    Regards
    Rishabh

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,990

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,576 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,028 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans