Skip to main content

I have a strange problem. I have developed a SQL Quick Report which execute perfectly: returns 19 rows as expected but no data is shown in some of the columns. These columns are related to Shop Order Costs.

  1. So if I log in to IEE,  go the the SQL QR and execute it: the cost columns are empty for all 19 rows.
  2. If I open the Shop Order Costs form, filter to the same order_no than the SQL QR: I can see the costs. Now if I go back and execute the SQL QR I get: 19 rows and all the empty cost columns are now full of number!

What the hell is going on? Anyone have ideas?

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 

Terms & ConditionsCookie settingsAccessibility statement