Previously (in Vantage 6.1) we had a mix of manufactured parts; some using standard cost method; some average. Now in Epicor, we are in the process of converting all manufactured parts to standard and are finding that many the standard cost elements (that were unused by any Vantage transactions) for these average method parts are less than accurate. So I want to create a custom report or dashboard that contains the same actual cost info as the production detail report, but over a series of jobs for the part. This would be to verify the trend of the part cost to set the standard more accurately. Essentially, pulling actual costs from several jobs for the part to determine what the standard cost should be. Has anyone made up a dashboard, custom report or any such tool to accomplish this?
Thanks in advance for any and all suggestions!