The Rollup BOM Costs does not recognize ASI in the costing records of lower level BOM lines and adds them up during rollup. More explanation below if not clear:
If you have Lot/Batch level costing or ASI level costing records for Raw Material with standard cost with ASI '100' = $1000 and that of ASI '101' = $1100, and let's say your BOM uses QTY 2 of Raw Material in Finished Good it will set the Finished Good cost to $4200 (Total of all ASI Costs x 2)
I can't say here how it should work or which ASI it should use. Maybe it should just give an error, or in case the end product also uses the same ASI it can copy the ASI as well.
Besides this the Rollup function needs general improvements as well (use SQL parameters instead of concatenation)
Major
The Rollup BOM Costs does not recognize ASI in the costing records of lower level BOM lines and adds them up during rollup. More explanation below if not clear:
If you have Lot/Batch level costing or ASI level costing records for Raw Material with standard cost with ASI '100' = $1000 and that of ASI '101' = $1100, and let's say your BOM uses QTY 2 of Raw Material in Finished Good it will set the Finished Good cost to $4200 (Total of all ASI Costs x 2)
I can't say here how it should work or which ASI it should use. Maybe it should just give an error, or in case the end product also uses the same ASI it can copy the ASI as well.
Besides this the Rollup function needs general improvements as well (use SQL parameters instead of concatenation)