I added the following to the beginning of the query.
and ttJobClosing.JobClosed = True
Add this after the last Rowmod = 'U' inside of the parenthesis.
Travis L. McMullen
Senior Information Systems Support Technician
ComSonics, Inc.
Harrisonburg, VA 22801
Phone: 540-434-5965 x1274
Toll Free: 1-800-336-9681 x1274
Mobile: 540-435-1920
Fax: 540-434-9847
E-Mail: tmcmullen@...
and ttJobClosing.JobClosed = True
Add this after the last Rowmod = 'U' inside of the parenthesis.
Travis L. McMullen
Senior Information Systems Support Technician
ComSonics, Inc.
Harrisonburg, VA 22801
Phone: 540-434-5965 x1274
Toll Free: 1-800-336-9681 x1274
Mobile: 540-435-1920
Fax: 540-434-9847
E-Mail: tmcmullen@...
On Tue, Aug 16, 2011 at 6:34 PM, Victor Cortes <vcortes@...>wrote:
> **
>
>
> Travis thanks again for the notes on the BPM this worked perfectly. One
> question though, how can I modified this so that it will allow you to
> Complete the Job but not close it?
>
> Thank you so much,
>
> Victor
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Victor Cortes
> Sent: Thursday, August 11, 2011 3:01 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Trigger Alert on Job Close when a Open DMR for
> same job exists.
>
> Thank You so Much Travis. I will try this.
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
>
> Behalf
> Of McMullen, Travis
> Sent: Monday, August 08, 2011 12:29 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] Trigger Alert on Job Close when a Open DMR for
> same job exists.
>
> No problem.
>
> I created a Pre-Processing Method Directive for the JobClosing.CloseJob
> Business Method. For the conditions, I used "number or rows in the
> designed
> query is not less than 1". You'll notice designed is blue so it can be
> clicked so code can be entered. Here is the code that I used.
>
> for each ttJobClosing where (ttJobClosing.RowMod = 'A' or
> ttJobClosing.RowMod = 'U') , first DMRHead where DMRHead.Company =
> ttJobClosing.Company and DMRHead.JobNum = ttJobClosing.JobNum and
> DMRHead.OpenDMR = True no-lock
>
> Under Actions, I chose "raise exception based on the designed template".
> Again, designed is blue; click on designed and enter the message that
> you
> want the user to see the conditions are met. We used the following:
>
> "There is an Open DMR tied to this Job. The Job cannot be marked as
> Complete or Closed."
>
> Let me know if you have more questions.
>
> Travis L. McMullen
> Senior Information Systems Support Technician
> ComSonics, Inc.
> Harrisonburg, VA 22801
> Phone: 540-434-5965 x1274
> Toll Free: 1-800-336-9681 x1274
> Mobile: 540-435-1920
> Fax: 540-434-9847
> E-Mail: tmcmullen@... <mailto:tmcmullen%40comsonics.com>
>
> On Mon, Aug 8, 2011 at 3:19 PM, Victor Cortes
> <vcortes@... <mailto:vcortes%40triumphgroup.com> >wrote:
>
>
> > **
> >
> >
> > Yes, that would be exactly what I need. Travis would you mind sharing
> > how you setup the BPM with me? I am not so great with BPMs. You would
> be
> > a Hero.
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
>
> Behalf
> > Of McMullen, Travis
> > Sent: Monday, August 08, 2011 12:14 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: Re: [Vantage] Trigger Alert on Job Close when a Open DMR for
> > same job exists.
> >
> >
> > I had to write a BPM for this that looked for Open DMR's with that
> > particular Job Number. If an Open DMR was found, I raised an exception
> > so
> > they could not save the record until the DMR was closed.
> >
> > Travis L. McMullen
> > Senior Information Systems Support Technician
> > ComSonics, Inc.
> > Harrisonburg, VA 22801
> > Phone: 540-434-5965 x1274
> > Toll Free: 1-800-336-9681 x1274
> > Mobile: 540-435-1920
> > Fax: 540-434-9847
> > E-Mail: tmcmullen@... <mailto:tmcmullen%40comsonics.com>
> >
> > On Mon, Aug 8, 2011 at 2:55 PM, vacortes21 <vcortes@...
> <mailto:vcortes%40triumphgroup.com> >
>
> > wrote:
> >
> > > **
> > >
> > >
> > > Finance is closing Jobs that have Open DMRs. how can i have Vantage
> > pop-up
> > > an alert or warning if a Open DMR exists for that Job when Finance
> > tries to
> > > close the Job.
> > >
> > > thanks in advance.
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access.
> )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> > This message has been processed via your triumphgroup.com e-mail
> > address.
> >
> > __________________________________________________________
> > This email has been scanned by the MessageLabs Email Security System.
> > For more information please visit http://www.messagelabs.com/email
> > __________________________________________________________
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
> This message has been processed via your triumphgroup.com e-mail
> address.
>
> __________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> __________________________________________________________
>
> This message has been processed via your triumphgroup.com e-mail
> address.
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]