BPM for engineering workbench

Greg, thanks for the solution. I appreciate your help!

Could someone forward a code for a BPM whereby when an engineer is adding a material to a BOM, there is a warning message that comes up when the material being added has a typecode of saleskit.

Here's what I tried in the conditions, without success.  I select the condition whereby the designated query is equal to one.  The query has EcoMtl and Part tables joined together, with a criteria of typecode = k

thanks for any suggestions

This works on EngWorkBench.Update.  If fires when the material is saved.

 

HTH

 

Condition: Number of rows in the FindKit query is not less than 1

query

for each ttECOMtl no-lock  ,  each Part no-lock  where (ttECOMtl.Company = Part.Company and ttECOMtl.MtlPartNum = Part.PartNum ) and  part.TypeCode = "K"

 

Action: raise exception.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, March 31, 2015 10:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM for engineering workbench

 

 

Could someone forward a code for a BPM whereby when an engineer is adding a material to a BOM, there is a warning message that comes up when the material being added has a typecode of saleskit.

Here's what I tried in the conditions, without success.  I select the condition whereby the designated query is equal to one.  The query has EcoMtl and Part tables joined together, with a criteria of typecode = k

thanks for any suggestions



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."