Existing data not visible in SQL Quick Report

The data that I do not see until I open the Shop Order Costs form is from “shop_order_variance2” view.

Anyone knows which API method should be invoked in an SQL query to populate the “shop_order_variance2” view?

Any suggestion to get the Standard costs and the Actual Costs from another view(s)?

Hi ​@clilouise

I checked, shop_order_variance2 view is based on a temporary table and system does not store data there.

You can use Shop Order Costs screen to get different Shop Order details like Estimated Cost, Standard Cost, WIP Cost, Actual Cost, etc.

Regards 

Abdul Rehman 

Hi ​@Abdul,

Do you know in which other view I could access the data for an SQL Quick Report?

Hi ​@clilouise,

I am not sure about your business requirements, though, there multiple screens are available to get different types of Shop Order Costs. 

Attaching screenshots for reference.

Regards

Abdul Rehman

​@clilouise Try the SHOP_ORDER_COST_DETAIL view.  It should have the same data generated from the Shop_Order_Cost_Util_API.  If that doesn’t work, then try some of the public procedures available in the Shop_Order_Cost_Util_API.