I’m currently trying (and failing) at creating a summary field. I would like summary of actual job hours in each OpCode for each assembly/sub assembly. I would like to display (1) Opcode summary of hours per assembly/subassembly (example summarize actual hours of Fab into one line per assembly/suba…

Remove the Actual Prod column. Or do you want that displayed along with a running sum of the hours for each OpCode?

Are you saying that for your first example, the highlighted field on fab, 28.55 should be all of the fab ops? Looking at what you have in the list, all of the fab ops should be 119.27 (there are 6 ops called fab). Can you explain why the total should be 28.55?

Looking at the first line, we see the sum_actual is exactly 3 x the Act Prod Hrs. This leads me to believe that his dataset has 3 BURN lines with 1.19 hrs each. Because he has GROUP BY on all displayed fields but sum_actual, separate lines are generated when the ActProdHrs differ. [image] If th…

There are zero hours logged to burn in assembly 0, but 4.79 shows up (I actually don’t have a burn operation in assembly 0). The same sum calculation is repeated over and over in my results. I need to see total hours clocked in each Operation Code per assembly. For example - my report is showing …

Copy the Query Phrase from the BAQ and paste it here. Put 3 gave characters (the backwards single quote next to the 1 key) on a line above the code you paste, and 3 more on a line after the code). Like (ignore the actual code between the opening 3 graves and closing 3 graves, it’s just an example)…

select [JobHead].[JobClosed] as [JobHead_JobClosed], [JobOper].[JobNum] as [JobOper_JobNum], [JobAsmbl].[Parent] as [JobAsmbl_Parent], [JobAsmbl].[AssemblySeq] as [JobAsmbl_AssemblySeq], [JobAsmbl].[PartNum] as [JobAsmbl_PartNum], [JobAsmbl].[Description] as [JobAsmbl_Description], [LaborDtl…

Do you have the Job Header joined directly to the Job Operation table? (I suck at reading SQL) Job Head, doesn’t have enough info to join directly to JobOper, (Usually). You’re going to get some weird stuff if you don’t do it this way. You should have Job head at table 1 joined to JobAsmbl joined …

Here are your tables, with one criteria. The joins should come in automatically if you do it this way. [image] Here are your display fields with group by [image] and here is your calculated field. [image] I did this really quick so I might have missed something, but it should work.

I didn’t have Job Head in there! Thank you so much!!! It worked!!!

It’s working quite well now - I was able to add in more details as well. See attached for my results (and details). Wondering how I get all my data on one “line”. For example ASM 0 Oper Fab I would like the line to list est. prod hours, actual hours and then rework hours. Right now rework hours …

Sum by Assembly/Sub Assembly & Op Code

Epicor ERP 10

Banderson (Brandon Anderson) February 14, 2019, 1:52am 13

Here’s a good step by step on how to do a sub query

Topic		Replies	Views
Accumulated labor hours Epicor ERP 10 e10 , mes , job-costing	12	2553	November 20, 2023
BAQ Sum JobOper Act Hors Epicor ERP 10 baq	5	691	November 2, 2022
Sums and grouping E10 Microsoft Report Builder Epicor ERP 10	2	534	January 26, 2017
Help with BAQ and subquery? Epicor ERP 10 baq	11	1744	October 18, 2021
BAQ question on adding up EstHrs on Job in SubQuery Epicor ERP 10 epicor , baq	9	848	December 15, 2023

Sum by Assembly/Sub Assembly & Op Code

Related topics