Job History Blank Title 112228

Yahoo Archive
1
We recently found a need to check the daily labor totals on any job that has had labor applied to it thru the MES. the following is the Query used.

for each JobOper no-lock , each JobAsmbl where (JobOper.Company = JobAsmbl.Company and JobOper.JobNum = JobAsmbl.JobNum and JobOper.AssemblySeq = JobAsmbl.AssemblySeq) no-lock , each LaborDtl where (JobOper.Company = LaborDtl.Company and JobOper.JobNum = LaborDtl.JobNum and JobOper.AssemblySeq = LaborDtl.AssemblySeq and JobOper.OprSeq = LaborDtl.OprSeq) no-lock

I converted this into a BAC report that can be exported as a excel data - only format.

This makes a quick way to see not only What jobs were wroked on but in our case also the operations performed on these jobs.

Hope this helps.

Gene

--- In vantage@yahoogroups.com, "Anon" <jgiese@...> wrote:
>
> How might one be able to see what was in production at the end of a specific day? Example being, how do we know what job numbers were running on June 30th. Is there something existing in Epicor that will tell us, or is that something we would have to build?
>
2
How might one be able to see what was in production at the end of a specific day? Example being, how do we know what job numbers were running on June 30th. Is there something existing in Epicor that will tell us, or is that something we would have to build?
3
>in production at the end of a specific day?
By "in production" I assume you mean jobs with labor or material added on a specific day?
This sounds to me like something you'll want to build.

Labor & Mtl issues should be easy to find.
I'd look at the PartTran and LaborDtl tables.





--- In vantage@yahoogroups.com, "Anon" <jgiese@...> wrote:
>
> How might one be able to see what was in production at the end of a specific day? Example being, how do we know what job numbers were running on June 30th. Is there something existing in Epicor that will tell us, or is that something we would have to build?
>