Microsoft Dynamics AX (Archived)

BOM item cost price

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

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

All responses (5)

Answers (0)

Suggested answer

Weaveriski 23,616 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 23,616 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 23,616 on at

Like (0)

Report

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.