Question

Shop order cost variances by material and operation

  • 24 August 2023
  • 2 replies
  • 115 views

Userlevel 3
Badge +8

I know we can get variances by cost bucket for the shop order as a whole but how can we determine estimated to actual variances by material line and operation. I cannot seem to find a standard report to provide this,

 

In the past, i suggested that a report or query be developed using shop order material history shop order operations  history and shop order labor history to gather the actual costs and line them to the shop order material records and operations to get the estimated times and quantities required.

 

Does anyone have any other options for performance reporting on shop orders? 


2 replies

Badge +2

This is also needed by my customer!

Badge +1

Create a report by Excel Add-in Business reporter.

Using 4 data sources:

  • Shop Order - High level SO Information.
  • Shop Order Material - Material lines.
  • Shop Order Operation - ACT & Planned time.
  • Operation History.  

 

Reply