Skip to Content
Jul 07, 2016 at 05:06 AM

BOM standard Cost rollup query


Hi All,

I wonder if anyone has done a report/query for multilevel BOM standard cost rollup. Requirement is to rollup the component standard cost stored at the warehouse level up the hierarchy for more than one level of parent items. Report will calculate the cost of parent items from the addition of child item costs. The trouble is when the BOM has more than one level its not easy. Below is an example:

Here the requirement is to get a query calculating L1 cost by adding two child levels of components.

Idea behind this query is to see how far misaligned parent standard cost compered to base component costs. Since costs are maintained per warehouse new functionality around "production std cost" in 9.2 version cannot be used.