I would appreciate any input or direction on how I can create a BPM that will trigger a warning that there is no Demand link on a job. I understand that if the job in job entry does not exist in JobProd this tells me there is no demand, but not sure how to proceed.
You can look at JobHead.ProdQty = 0… but I’m not sure what process you’d want to look for that value on.
create a query that has two entities: JobHead and JobProd… make the link an OUTER JOIN (All rows from JobHead)… then display the job number (Mark it as the Group By) from JobHead, and a calculated field that is “Count(JobProd.JobNum)”… Then you can add a subquery criteria against that calculated field to specify that you only want records where the count is zero. This will give you the list of jobs without jobprod records.
Here are the three steps above in picture form:
Step 1: The two tables joined
Step 2: The Calculated Field
Step 3: The Criteria:
1 Like
I have a BAQ that lists jobs with missing job to job demand link very similar to how Tim mentioned above but, the main manufacturing job already had a demand link to the Sales Order so my join to JobProd has to be JobHead.JobNum = JobProd.TargetJobNum to account for other JobProd records .
1 Like
Thank you. I already have a BAQ very similar to what you have provided, which shows me jobs with no demand. My request is how do I inform/warn the user when they are in Job Entry, and they are selecting “released” that they have not created a demand. In a BPM Job Entry what to use to trigger the message that there is a missing demand link.
I’ll say in an jobEntry.update create a preprocess that looks if JobHead.ProdQty is < 1 and if the jobProd has no record then prompt an error or info message, you can create a query in the BPM designer .
by joining the temp table ttJobHead to ERP.JobProd, did the trick.
thank you
I usually check when Engineered, or Released changes from false to true on a job.