# Accumulated labor hours **URL:** \ **Category:** Epicor ERP 10\ **Tags:** mes, job-costing, e10\ **Created:** [May 10, 2023, 4:01pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678 "2023-05-10T16:01:38Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Rookie](https://www.epiusers.help/user_avatar/www.epiusers.help/rookie/32/53649_2.png) [@Rookie](https://www.epiusers.help/u/Rookie)\ **Post date:** [May 10, 2023, 4:01pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/1 "2023-05-10T16:01:38Z")
How can I see the accumulated labor hours by Job/Asm/Op? ---
**Author:** ![NateS](https://www.epiusers.help/user_avatar/www.epiusers.help/nates/32/18519_2.png) [@NateS](https://www.epiusers.help/u/NateS)\ **Post date:** [May 10, 2023, 4:34pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/2 "2023-05-10T16:34:50Z")
In this case you want to build a BAQ. Start with your jobhead table, then join in your jobasm and joboper tables. This get you the basic list of all the jobs/asms/ops. Now you need to figure out the hours charged against those ops. Add in your labordtl table and join it based on the job/asm/op to the joboper table. Then return the LaborHrs from the labordtl table. You can use the groupong and summarize features in the BAQ columns to roll up your information by job, or asm or op. You can use filters on the job table to make sure you are only looking at open jobs (closed=false). you may need to use some subqueries to get the exact summary groupings you need. Let us know! I hope this helps! Good luck! Nate Something like this: ```sql select [JobOper].[JobNum] as [JobOper_JobNum], [JobOper].[AssemblySeq] as [JobOper_AssemblySeq], [JobOper].[OprSeq] as [JobOper_OprSeq], [LaborDtl].[LaborHrs] as [LaborDtl_LaborHrs] from Erp.JobHead as JobHead inner join Erp.JobAsmbl as JobAsmbl on JobHead.Company = JobAsmbl.Company and JobHead.JobNum = JobAsmbl.JobNum inner join Erp.JobOper as JobOper on JobAsmbl.Company = JobOper.Company and JobAsmbl.JobNum = JobOper.JobNum and JobAsmbl.AssemblySeq = JobOper.AssemblySeq inner join Erp.LaborDtl as LaborDtl on JobOper.Company = LaborDtl.Company and JobOper.JobNum = LaborDtl.JobNum and JobOper.AssemblySeq = LaborDtl.AssemblySeq and JobOper.OprSeq = LaborDtl.OprSeq where (JobHead.JobClosed = false) ``` ---
**Author:** ![Rookie](https://www.epiusers.help/user_avatar/www.epiusers.help/rookie/32/53649_2.png) [@Rookie](https://www.epiusers.help/u/Rookie)\ **Post date:** [May 10, 2023, 5:21pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/3 "2023-05-10T17:21:26Z")
I have an LaborTrans BAQ similar to what you recommend. What I’m ultimately looking for is a field within Epicor that keeps a total of labor hours by Job/Asm/Op. Ideally, it would keep a running total by LaborDtl.Seq to include in the LaborTrans BAQ. The last entry for a given Op would be the total hours for that Op. The JobOpper\_ActProdHours appears to do sum the labor hours, but is (from what I have determined) actual the accumulated Burden Hours. In order for this to be a true total of labor ours, one must set the Burden Hours to “Burden = Labor” , and I’ve read that in most cases one would want that to be set to “Split Burden”. ---
**Author:** ![hackaphreaka](https://www.epiusers.help/user_avatar/www.epiusers.help/hackaphreaka/32/56320_2.png) [@hackaphreaka](https://www.epiusers.help/u/hackaphreaka)\ **Post date:** [May 10, 2023, 5:38pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/4 "2023-05-10T17:38:52Z")
I think JobOpDtl.ActProdHours does what you want. "Total Actual Production Hours. A summary of non-setup LaborDtl.BurdenHrs. This includes REWORK hours. This is maintained via write/delete triggers on the LaborDtl file. Along with JobOper.ActReworkHours it is used to reduce the shop load if the system is configured to remove load by actual hours (JCSyst.RemoveLoad = ““H””). " ---
**Author:** ![Rookie](https://www.epiusers.help/user_avatar/www.epiusers.help/rookie/32/53649_2.png) [@Rookie](https://www.epiusers.help/u/Rookie)\ **Post date:** [May 10, 2023, 6:11pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/5 "2023-05-10T18:11:09Z")
> [@hackaphreaka](#): > > I think JobOpDtl.ActProdHours does what you want. I added JobOpDtl.ActProdHours linking it to JobOper and the value is zero (0). ![image](https://www.epiusers.help/uploads/default/original/3X/2/c/2c8dd1ccb04629e18ad090042685910fdccaa108.png) ![image](https://www.epiusers.help/uploads/default/original/3X/7/0/70eda39e337703c6d3191f834bb3c3c0baea6357.png) ---
**Author:** ![klincecum](https://www.epiusers.help/user_avatar/www.epiusers.help/klincecum/32/100137_2.png) [@klincecum](https://www.epiusers.help/u/klincecum)\ **Post date:** [May 11, 2023, 1:27am UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/6 "2023-05-11T01:27:52Z")
Sorry to interrupt, but I love that wavy split in the last picture. Would you mind sharing how you did that? ---
**Author:** ![Rookie](https://www.epiusers.help/user_avatar/www.epiusers.help/rookie/32/53649_2.png) [@Rookie](https://www.epiusers.help/u/Rookie)\ **Post date:** [May 11, 2023, 12:59pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/7 "2023-05-11T12:59:12Z")
Kevin, it’s a feature of SnagIt, the screen capture software that I use, called Cut Out. It allows you to select from a number of different break line patterns, both horizontal and vertical, and thereby reduce the size of screenshots by cutting out parts of an image that are not pertinent. ![image](https://www.epiusers.help/uploads/default/original/3X/f/2/f2ed4c7935cf942cdb07eed88ee7e19f48a0c657.png) Any insight on accumulated labor hours? ---
**Author:** ![klincecum](https://www.epiusers.help/user_avatar/www.epiusers.help/klincecum/32/100137_2.png) [@klincecum](https://www.epiusers.help/u/klincecum)\ **Post date:** [May 11, 2023, 1:43pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/8 "2023-05-11T13:43:14Z")
> [@Rookie](#): > > it’s a feature of SnagIt Sweet, I will check that out. Thank you. > [@Rookie](#): > > Any insight on accumulated labor hours? I pulled a @josecgomez … TLDR 🤣 ![picard too long didnt read GIF](https://media1.giphy.com/media/2d98nRiVVB6HS/giphy.webp?cid=e90edba3ss57m6e3h1frzu52jflibcbqagst9299o09rkmga&ep=v1_gifs_search&rid=giphy.webp&ct=g) ---
**Author:** ![Rookie](https://www.epiusers.help/user_avatar/www.epiusers.help/rookie/32/53649_2.png) [@Rookie](https://www.epiusers.help/u/Rookie)\ **Post date:** [May 11, 2023, 1:57pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/9 "2023-05-11T13:57:31Z")
> [@Rookie](#): > > How can I see the accumulated labor hours by Job/Asm/Op? Kevin, this is the Reader’s Digest version. ---
**Author:** ![gpayne](https://www.epiusers.help/user_avatar/www.epiusers.help/gpayne/32/55751_2.png) [@gpayne](https://www.epiusers.help/u/gpayne)\ **Post date:** [May 11, 2023, 2:17pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/10 "2023-05-11T14:17:07Z")
JobOper.ActProdHours holds that data ---
**Author:** ![Rookie](https://www.epiusers.help/user_avatar/www.epiusers.help/rookie/32/53649_2.png) [@Rookie](https://www.epiusers.help/u/Rookie)\ **Post date:** [May 11, 2023, 5:51pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/11 "2023-05-11T17:51:39Z")
> [@Rookie](#): > > The JobOpper\_ActProdHours appears to do sum the labor hours, but is (from what I have determined) actual the accumulated Burden Hours. In order for this to be a true total of labor ours, one must set the Burden Hours to “Burden = Labor” , and I’ve read that in most cases one would want that to be set to “Split Burden”. Greg, the JobOper\_ActProdHours doesn’t appear to be accurate. ![image](https://www.epiusers.help/uploads/default/original/3X/c/4/c4ce819f6b39e2a712fed586288dea6f7f2bf5ff.png) Thoughts? ---
**Author:** ![gpayne](https://www.epiusers.help/user_avatar/www.epiusers.help/gpayne/32/55751_2.png) [@gpayne](https://www.epiusers.help/u/gpayne)\ **Post date:** [May 11, 2023, 6:12pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/12 "2023-05-11T18:12:37Z")
We are manual labor, so labor hours equal burden hours and costs tye out. ---
**Author:** ![vingeance](https://www.epiusers.help/user_avatar/www.epiusers.help/vingeance/32/80673_2.png) [@vingeance](https://www.epiusers.help/u/vingeance)\ **Post date:** [November 20, 2023, 5:51pm UTC](https://www.epiusers.help/t/accumulated-labor-hours/102678/13 "2023-11-20T17:51:21Z")
Hi Tom. We are having the same interrogation. The job operation ActProdHours is equal to zero, even though there are labor hours. Did you ever figure this out?