Formula for WIP total in the Work In Process Report

Yahoo Archive
1
This is exactly what I needed. thank you very much for sharing this me.
2

Can someone help me duplicate the W.I.P total from the Work In Process Report?

 

I am trying to do this in a SQL query.

 

thanks in advance

3

This snippet was respectfully commandeered from one of my brother’s reports, hope it gives you a start:

 

              ,isnull((select sum (JO1.ActBurCost) from JobOper JO1 with (NOLOCK) where JO1.JobNum = JP.JobNum),0)TotalBurden

              ,isnull((select sum (JO1.ActLabCost) from JobOper JO1 with (NOLOCK) where JO1.JobNum = JP.JobNum),0)TotalLabor

              ,isnull((select sum (JM1.TotalCost) from Erp.JobMtl JM1 with (NOLOCK) where JM1.JobNum = JP.JobNum),0)TotalMaterial

              ,isnull((select sum (JA1.TotalMtlSubCost) from JobAsmbl JA1 with (NOLOCK) where JA1.JobNum = JO.JobNum),0)TotalSubContract

              ,(isnull((select sum(JM9.MtlBurCost) from Erp.JobMtl JM9 with (NOLOCK) where JM9.JobNum = JO.JobNum),0))TotalMtlBurden

 

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, July 28, 2015 2:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Formula for WIP total in the Work In Process Report

 

 

Can someone help me duplicate the W.I.P total from the Work In Process Report?

 

I am trying to do this in a SQL query.

 

thanks in advance