Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

BOM item cost price

Posted on by Microsoft Employee

I have a BOM item which is consisted of two raw materials as below:

cost02.png

Now i want to run the calculation for the BOM item(PROD01) to roll up the cost from two approaches.

1. Approach 1: Released Product details->Manage costs->Item price->Calculation,

Select the cost version, and click OK.

i can get the cost price 8 for the BOM item "PROD01" which is what i want.

2. Approach 2: Inventory management->Setup->Costing->Costing Versions

On the "Costing version setup" form select the cost version and click "Calculation" button to open the form as below, and select the material "PROD01" which needs to be calculated.

With almost the same configuration, but i cannot get the cost price for the BOM item by approach 2.

*This post is locked for comments

  • Suggested answer
    Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: BOM item cost price

    Your costing version is the Year2013 - this is either planned or standard, so you state it is planned, however the calculation still has to obey the settings of the costing version, and in it you state that the "fallback principle" is none, so if it cannot find a cost it returns nothing.

    You have yours set to the calculation group "Inventory Cost" but you have not said what this is set to - please remember this is, I believe, the calculation group on the components - if blank it uses the default. So what is the cost price model and alternate cost price model set to in each calculation group? It should mean if the component item has the cost price field on the released product set it will pick it up.

    My first test would be to set the fallback principle to active - if this picks up a cost then it is in the configuration of the calculation group where the issue lies or how the data is set by calculation group.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: BOM item cost price

    [quote user="Weaveriski"]

    Set the fallback principle to active and then see what it does - I am not sure of your costing settings for standard in the version or what it does from the released product but clearly it calls the code slightly differently to get the BOM Line cost - you would need a developer to look at the actual code, but the fallback principle should work as your items have cost (at that level it may ONLY check the entries in the costing version and as you have none it returns 0).

    [/quote]


    Hi Steven

    I'm using "Planned Cost" cost version, and the "Cost Price Model" in the cost version is "Calculation Group", Both raw materials and BOM item are using "Weighted Average". and the "Calculation Group" for the raw material is "Inventory Cost".

    Sorry for not giving you enough information.

  • Suggested answer
    Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: BOM item cost price

    Set the fallback principle to active and then see what it does - I am not sure of your costing settings for standard in the version or what it does from the released product but clearly it calls the code slightly differently to get the BOM Line cost - you would need a developer to look at the actual code, but the fallback principle should work as your items have cost (at that level it may ONLY check the entries in the costing version and as you have none it returns 0).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: BOM item cost price

    [quote user="Weaveriski"]

    Is BOM PROD01 active on item PROD01? You pick an approved BOM on the first, but the second uses the current active BOM.

    [/quote]

    Hi Steven

    The BOM item only has one BOM version, and it was activated.

    Many thanks

  • Suggested answer
    Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: BOM item cost price

    Is BOM PROD01 active on item PROD01? You pick an approved BOM on the first, but the second uses the current active BOM.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans