Shop Order Cost Variance Report Can be downloaded to Excel

HI @ronhu ,

There is no direct way to get this value into an excel sheet as a list against the shop order number, because the Shop Orders Costs overview screen also does not have a column for this Calc. Variance field. If it was there in the overview screen, you can easily export the output to an excel.

As I believe, the best way to get this is to create a SQL type quick report with the desired columns against the shop order number, so that you can easily export the quick report output result into an excel.

However, this field ‘Calc. Variance’ is not directly available as a column in any of the tables in the database. This field is configured as a client field. So, this needs debugging from the client level as well, to find the exact calculation performed when populating the data for this screen. After finding out that, it’s a simple task to develop the quick report including that logic.

Best Regards

Thushitha

Hi, I think you should add a small idea in IFS Community to add the Calc Variance column to Shop Orders Costs overview page.

I think Matt’s proposal will work fine in a pure standard cost business environment where you maintain your Part Cost, cost set 1 amounts. For other valuation methods it will not work so good - well it (Total Std Accum Cost - (Actual Accumulated Cost Total + Total Std-Operation Scrapped) will not be the same amount as the Calc Variance field in the WIP status tab.

Best Regards,

Mats