BPM to check that material is issued

Hi,
I have this BPM that triggers a pop up to warn that material is not issued. I only want this to trigger on the final operation. I get an error when I try to add in the JobAsmbl.FinalOp = True field. I am not sure where to add it.

for each ttLaborDtl where (ttLaborDtl.RowMod = ‘U’ or ttLaborDtl.RowMod = ‘A’)

[AND JobAsmbl.FinalOp = True - This is where I think it should go but I get an error when I put it here]

, each JobMtl where (JobMtl.RequiredQty > 0 AND not JobMtl.IssuedQty = JobMtl.RequiredQty) and (ttLaborDtl.Company = JobMtl.Company and ttLaborDtl.JobNum = JobMtl.JobNum) no-lock

Thanks,
Melissa

FinalOP is numeric. You want to check against the labordtl.oprseq. For speed don’t put the conditions in the where clause use an If then next to skip records you don’t want.

If JobAsmbl.FinalOp <> laborDtl.OprSeq then next.

Thanks for the suggestion. I am getting the error:

“JobAsmbl.FinalOpr must be a quoted constant or an unabbreviated. unambiguous biffer/field reference for buffers known to query” ?

You need a find or for each with JobAsmbl

I do something similar but I do the check for issued materials at job close.

Good afternoon,
Due to long lead times, we want to stock some material at a vendor for use in their production process. We would purchase the material and send it to the vendor. They would produce our item and sell it to us at their price less the material cost. We don’t really want to have to issue jobs for this process.
My thought was to sell the raw material to the vendor and discount it out to $0.00. The vendor would then produce our item and sell it back to us at Gross Price less material allowance (which we would discount out).
I can’t find anywhere on our P.O. where we could enter a discount amount in order to preserve the costing.
Does anyone have a better idea?
Thanks in advance.
Kerry TravisControllerInternational Name Plate Supplies Limited

Sorry, I didn’t change the subject when I entered my own question.
Good afternoon,
Due to long lead times, we want to stock some material at a vendor for use in their production process. We would purchase the material and send it to the vendor. They would produce our item and sell it to us at their price less the material cost. We don’t really want to have to issue jobs for this process.
My thought was to sell the raw material to the vendor and discount it out to $0.00. The vendor would then produce our item and sell it back to us at Gross Price less material allowance (which we would discount out).
I can’t find anywhere on our P.O. where we could enter a discount amount in order to preserve the costing.
Does anyone have a better idea?
Thanks in advance.
Kerry TravisControllerInternational Name Plate Supplies Limited Visit Topic or reply to this email to respond.

Hi there, not sure if this got resolved but what is the full code for checking that material is issued to the job.

would it be possible for you to share the full code for this?

I think this is what I had mocked up out of our routine. It validates, but has not been tested. Our final audit is FINAUD, so that was easiest for me to check. If you have various final operations, then you will need to check JobAsmbl for the final op number.

Alert on not enough material issued.p (1.4 KB)