I set up a data directive to send an email alert when a part is added NCR. We use inspection processing after receiving raw material into Epicor. It is also sending alerts when parts are approved into inventory from inspection processing. How do I set it up so those do NOT send alerts?
Thank you
What is your conditions widget?
This is on update so you will need to have conditions that meet what you need.
Deleted
@taustin
So when a Method is called, it’s possible for the same record to exist in the ttTable multiple times, but with different RowMod values (Add, Update, Delete,Unchanged, blank). So often times you have to make sure that your condition checks for the type of record as well. Per what @cpilinko illustrated, I think all you need is to check if there is an added row to ttNonConf.
You may also consider the NonConf Type (Inventory, RMA, Etc) in determining when you want an email notification going out.
I created a slightly different Data Directive to notify engineers who created requisitions when their parts passed/failed incoming inspection (A major headache reaching all the way back out to a completely different joined tables to finally pull the user’s email address). But fortunately what you are trying to accomplish is much simpler.
I would actually set your BPM against the RcvDtl table as I did, and then just trap for when the ttRcvDtl.FailedQty field has been changed from 0 to another.
It will be that inspection failed qty that will trigger an Non-conformance record to be created; and you’ll avoid that doubling up. You don’t need to concern yourself with the PassedQty that I also needed to trap for.
oh that would work. Thanks but what if we want the inventory NCR transactions to alert also?
You could try to capture on the PartTran table, and set your condition for STK-INS (for Inventory non-conformances), and MTL-INS (for Job Material non-conformances).
That should cover non-receiving nonconformance reporting.
Perhaps. It’s really the preliminary step, and it might be different TranType(s) you need to trap for.
The main reason I had to originally trap on the RcvDtl table was because our requisitions are on the R&D side of the business, and were generally Purchase direct to Project Job Material transactions for non-part table parts that otherwise don’t get recorded anywhere else due to not being official parts in Epicor as of yet.
Yes, that could be one reason.
Add ‘RowMod’ to your notification and see if there are two values.
You could add that and then screenshot it here to be sure.
Thank you I just created the PartTran I am having a hard time getting the NCR # (I tried a couple fields and still not showing) and Employee name/Id (I tried entry person and EmpID) to go onto the email. Neither of them are showing up
Try putting in one additional condition field - when the ttPartTran.NonConfID is more than the 0 expression
I was a little worried about that, as i felt there might be a pre-nonconformance step in the whole process; and when I initially queried my database, I looked for STK-INS transactions where the NonConfID > 0
and thus it was returning all of those with a value.
In my BAQ for STK-INS transaction types I’ll show you my parameters and output. We don’t do non-conformances from jobs, so that would be something I’d have to play around with when I have time.
Don’t you want that to be connected to the True side?
