I have been tasked with creating a BAQ that lists every job and its associated Auto-receive value.
Now I’ve seen other posts about using the Erp.JobAsmbl.AutoRecOpr field.
CASE WHEN JobAsmbl.AutoRecOpr > 0 THEN 1 ELSE 0 END
However, when I go through the jobs, this is not accurate and some jobs with
AutoRecOpr > 0 are unchecked and some jobs with
AutoRecOpr = 0 are checked.
This leads me to believe that AutoRecOpr is not directly related to Auto-receive.
JobOper also has no fields that sound like they would be related to this.
Most jobs follow the logic described above. However, not all. Here’s a job that doesn’t:
Thank you very much!
Look in your job for another operation that has Auto Receive checked. Only one operation can be checked as AutoReceive = true. In your description, it sounds like you don’t care to know which operation… just that one of them is checked true. Is that accurate? Your screenshot shows that there are other operations.
Thank you very much for your reply.
You are definitely on to something… Do you know what’s going on here by chance? There are 3 Auto Receive Operation Numbers, but only one is displayed.
I see that your job has subassemblies. Are you accounting for them? I can’t tell from your BAQ grid… what tables are you joining? A lot of times I will set a table criteria on the JobOper table for AssemblySeq = 0 so that I am only getting the top most assembly.
I usually don’t deal with Jobs’ operations, assemblies, and subassemblies, so I really appreciate you pointing that out.
For my BAQ, I’m only pulling Erp.JobAsmbl with table criteria JobNum = ‘FM010370’. I was getting only distinct entries earlier, so that is why there are more now.
I expanded the Job’s Subassemblies as well as operations and the only Auto Receive checked operation is the highlighted one in Job Entry. Do you know why it would show me the Auto Receive Operation Number for every assembly if only Assembly 0’s Opr 10 is checked?
Thank you for your patience by the way
And Yes… I care only that any operation is checked, doesn’t matter which one.
I misunderstood the whole concept, my bad. I really appreciate your help on this. I believe I got it now… You’ve been a huge help, so thanks again @dr_dan !
I’ll be working with the following logic:
CASE WHEN JobAsmbl.AssemblySeq = 0 AND JobOper.AssemblySeq = JobAsmbl.AssemblySeq AND JobOper.OprSeq = JobAsmbl.AutoRecOpr THEN 1 ELSE 0 END
Glad I could help. It brings me great satisfaction to help others because I know how frustrating it can be when you can’t quite figure something out in Epicor - especially when it is outside of your comfort zone.
hah we understand each other very well then