Hello, this is a question for those of you who use the BOM Cost report.
If I have a part in the BOM that has an approved revision that was approved before today’s date, the top level BOM will include the cost of that part as if it is being manufactured, whether or not the part is designated as purchased on manufactured. The only way I have been able to figure out how to work around this is to temporarily set the approved date for the lower level parts to a date in the future and to not have any active, approved revisions with an approval date in the past. This will cause the BOM cost report to pull the average cost of the item instead of an estimated cost to manufacture the lower level part with the rev.
I won’t bore you with the specifics but we have parts we purchase that were entered with multiple revs, and to get purchasing to have the active rev with our supplier, I have to have a rev for the part with an approval date in the past. If I do not, our purchaser has to pick a rev next to the part list, rather than the most recent approved rev showing up by defualt. If we do not have the REV on our PO to our supplier it would cause an issue. Setting the date in the future causes this PO line to not have a rev by default, so I can’t work around this by setting the approved date in the future permanently.
Is there a system or report level setting somewhere where I can make the BOM cost report respect the purchased or manufactured setting on the part rather than what it is doing?