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
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.
[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.
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 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
Is BOM PROD01 active on item PROD01? You pick an approved BOM on the first, but the second uses the current active BOM.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156