[6.1] BAM alert for entry of nonconforming inventory or job mat

Having been called out by name...
Scott,
I would deal with the two methods of NC separately.
First, the easy one...watch the LaborDtl table for LaborDtl.DiscrepQty.
This would be the items entered as NC from the job.
The second is a little more tricky. I would watch PartWhse.OnHandQty linked
to PartTrans "FIND LAST WHERE" (link appropriate fields) and examine the
PartTrans.TranType for "STK-INS". This would not be a perfect solution, but
should work most of the time.
Let us know if I was out in left field on this one. If you would like some
additional help, just let me know.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lepley, Scott A.
Sent: Wednesday, January 25, 2006 2:32 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] [6.1] BAM alert for entry of nonconforming inventory
or job material


Hello group,



I'm hoping that Aaron or one of you other BAM gurus may have already created
what I want or you at least can suggest some ways that I can create it. I
would like to have an alert generated whenever someone enters nonconforming
inventory or job material. I am already having an alert sent when a PO
receipt is received to inspection, but setting up that alert was relatively
easy because the RcvDtl table is one that is available in BAM.
Unfortunately, neither the NonConf table nor the PartTran table is available
in BAM. The only way I can envision accomplishing this is to monitor the
OnHandQty and IssuedQty fields, in the PartWhse and JobMtl tables,
respectively, and then create joins to the PartTran table and set conditions
for the alerts according to transaction type or sysdate. However, at the
present time, my reach exceeds my grasp; I'm perplexed as to how to convert
this notion to reality. Any suggestions?



Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.532
Hello group,



I'm hoping that Aaron or one of you other BAM gurus may have already created
what I want or you at least can suggest some ways that I can create it. I
would like to have an alert generated whenever someone enters nonconforming
inventory or job material. I am already having an alert sent when a PO
receipt is received to inspection, but setting up that alert was relatively
easy because the RcvDtl table is one that is available in BAM.
Unfortunately, neither the NonConf table nor the PartTran table is available
in BAM. The only way I can envision accomplishing this is to monitor the
OnHandQty and IssuedQty fields, in the PartWhse and JobMtl tables,
respectively, and then create joins to the PartTran table and set conditions
for the alerts according to transaction type or sysdate. However, at the
present time, my reach exceeds my grasp; I'm perplexed as to how to convert
this notion to reality. Any suggestions?



Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.532





[Non-text portions of this message have been removed]