How to mass Calculate Std Costs for Parent items when a child std cost used in many BOM's is changed.

If I have an ingredient that changed costs (Std Cost) and it is also a component in many Intermediate BOMs and then those BOM's in many Finished Good BOMs 

- is there a way to calculate the costs on all the BOM's that are touched by that cost change without calculating the Cost for ALL items?   

Seems the BOM flag only goes down.  I am looking for something that goes up to all impacted parent items.

  • 0

    Hi  

    Short answer: there are no tools to go up all impacted parent products.  => What is the problem to re-run the calculation for all products?

    Possible workaround, would be to implement allergen process that allow to update the ITMMASTER table (ALG field) with  roll-up logic - meaning all impacted parent items - and then use this field as filter in the formula for the standard cost calculation:

    I haven't tried this but you can run some test on SEED  using the product RAW334. 

    Note: it can be quite an effort to implement allergen just for this purpose (if activity code FOA not turn on) and the workaround will reach its limits if this happens too often.

  • 0 in reply to Julien Patureau

    I created a view and tried to pull it in here in a similar fashion but it didn't allow me to use the view as it wasn't attached to the Screen. 

    if recalculating for all products, does it store a record if nothing has changed or only if it's a new value?   I don't want to get into the habit of creating a lot of data if only updating a percentage of our products.  maybe not an issue though.