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

Announcements

No record found.

News and Announcements icon
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 213
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,811 Super User 2026 Season 1 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
    11,676 Super User 2026 Season 1 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
    10,972 Super User 2026 Season 1 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,666 Super User 2026 Season 1 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,945 Super User 2026 Season 1 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
    98,012 Super User 2026 Season 1 on at
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    21,573 Super User 2026 Season 1 on at
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    6,213 Super User 2026 Season 1 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,161 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,046 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 932 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans