BPM to prevent JobMtl changes once PO has been created

Yahoo Archive
1
Bobby,  This worked perfectly!  I appreciate your help!  I was kinda on the right track, I just didn't have the links in the query right.
2

I want a BPM to prevent changes to materials on the job once either an RFQ is created or a PO is created.  the RFQ is working fine, I did a Pre-Processing Method directive, the condition is looking at whether JobMtl.RFQNum is greater than zero, then displays an informational message.  


I'm trying to figure out the best way to do the same thing if there is a PO tied to that MtlSeq number.  Suggestions?  I'm thinking it's going to be a 2 part process, but i'm not even sure where to begin.

3
I just did this about 2 weeks ago. I can post screen shots of my BPM in the morning.
4

That would be fantastic!!  Thank you

 

Sarah Cooley

Database Analyst

Lube-Power, Inc.

PH:  586-247-6500 Ext. 258

scooley@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, December 11, 2014 9:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM to prevent JobMtl changes once PO has been created

 

 

I just did this about 2 weeks ago. I can post screen shots of my BPM in the morning.

5
On the update Method for Job entry, Pre-Processing in the conditions field select the condition " Number of rows in the query is more than 0".  FOr your query copy and paste this into where it says compose query. 

for each ttJobMtl fields(company jobnum assemblyseq mtlseq) no-lock where ttjobmtl.company = Cur-Comp ,  each PORel fields(company jobnum assemblyseq jobseq) no-lock  where (ttJobMtl.Company = PORel.Company and ttJobMtl.JobNum = PORel.JobNum and ttJobMtl.AssemblySeq = PORel.AssemblySeq and ttJobMtl.mtlSeq = PORel.jobSeq )
 
and set the condition to be "More than 0"

in the actions section, select "Raise exception on the designed template" Add whatever you want to the "Designed" part. Enable and save, should, prevent parts from being updated if they are on a PO. 

Hope this helps. 

-Bobby