Query for Production Variance

[Former Member]

Dear Experts,

My client required variance report for production. I did for quantity variance, but they also require price variance for the production orders.

Can you please help me  for the query to get the price variance.

Thanks & regards,

Hiren

[Former Member]

Dear Nagarajan,

Thanks for your reply . This is very helpfull, but I can't understand the "Actual product cost" and "Actual component cost" could you please explain?

Thanks & Regards,

Hiren

[kothandaraman_nagarajan]

Hi,

Please check this thread

Thanks.

[Former Member]

Dear Nagarajan,

Thanks for your reply. This is helpful, but I can't understand what is "Actual product cost" and "Actual component cost" in the query. Could you please explain this?

Thanks & Regards,

Hiren

[Johan_H]

Hi Hiren,

Could you please post the query you have made for the quantity variance ?

It will be easier to adapt this query to show price information.

Regards,

Johan