Purchase Order Cost Update

When we create work orders and attach the route, if there is a route step that includes sending the product to an outside supplier for processing such as plating, the route will generate a purchase order in the route step. The purchase order will pull the cost for the process from either the Supplier Catalog or from the Item/Branch (F4105).

Before sending the product to the supplier we need to update the cost to reflect the current cost from the supplier. I'm looking into ways to accomplish an update of the cost for all open work orders of this type. In my analysis, I created a work order and it pulled the cost from the Supplier Catalog (F41061). I updated the Supplier Catalog by expiring the current cost and entering a new cost.