Has anyone done a modification or event handler to change the way the cost on customer order lines/releases is pulled? For example: a utility that would run every evening and update the co line cost to match the current unit cost? Similar to how the Job BOM and Current BOM roll-ups run and update all active jobs with current cost, we would like to be able to update our customer margin reports with more realistic costing. We are actual average costing and from the time the order is placed to the time we ship the costs can vary dramatically.
We are on-prem CSI 10.