Thanks for taking a look Jose.
The issue is that when a zero dollar sales order is shipped and
OrderHed.Checkbox04 is false, the condition is still evaluating to TRUE.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Friday, December 07, 2012 11:57 AM
To: Vantage
Subject: Re: [Vantage] BPM Condition Help - BUMP
Joe
I just imported it in, and it looks like it works. I did ONLY the Query
Step and then Display Info Message and it works every time. Maybe the
rest of your BPM is what is causing problems?
for each ttShipHead where ttShipHead.Company = CUR-COMP and
ttShipHead.RowMod = 'U' , each ShipDtl no-lock where shipdtl.Company =
ttShipHead.Company and ShipDtl.PackNum = ttShipHead.PackNum , each
OrderHed no-lock where (OrderHed.CheckBox04 = true Or OrderHed.OrderAmt
OrderHed.OrderNum )
*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
The issue is that when a zero dollar sales order is shipped and
OrderHed.Checkbox04 is false, the condition is still evaluating to TRUE.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Friday, December 07, 2012 11:57 AM
To: Vantage
Subject: Re: [Vantage] BPM Condition Help - BUMP
Joe
I just imported it in, and it looks like it works. I did ONLY the Query
Step and then Display Info Message and it works every time. Maybe the
rest of your BPM is what is causing problems?
for each ttShipHead where ttShipHead.Company = CUR-COMP and
ttShipHead.RowMod = 'U' , each ShipDtl no-lock where shipdtl.Company =
ttShipHead.Company and ShipDtl.PackNum = ttShipHead.PackNum , each
OrderHed no-lock where (OrderHed.CheckBox04 = true Or OrderHed.OrderAmt
>0) and (ShipDtl.Company = OrderHed.Company and ShipDtl.OrderNum =
OrderHed.OrderNum )
*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Fri, Dec 7, 2012 at 11:42 AM, Joe Rojas <jrojas@...> wrote:
> **
>
>
> Ops.
>
> It's called ExportCustShipUpdate.bpm
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Joe Rojas
> Sent: Friday, December 07, 2012 11:40 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] BPM Condition Help - BUMP
>
>
> Thanks Jose.
> I uploaded it to the BPMs folder.
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
>
> us about our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not
> the named addressee you should not disseminate, distribute or copy
> this e-mail. Please notify the sender immediately by e-mail if you
> have received this e-mail by mistake. Please note that any views or
> opinions presented in this email are solely those of the author and do
> not necessarily represent those of the company.
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not
> the named addressee you should not disseminate, distribute or copy
this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> -----Original Message-----
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]
> On
>
> Behalf
> Of Jose Gomez
> Sent: Friday, December 07, 2012 10:35 AM
> To: Vantage
> Subject: Re: [Vantage] BPM Condition Help - BUMP
>
> Export / Upload your BPM and i'll take a look
>
> Tjankls!
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@... <mailto:jose%40josecgomez.com>
> http://www.josecgomez.com <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Fri, Dec 7, 2012 at 10:23 AM, Joe Rojas <jrojas@...
> <mailto:jrojas%40matsinc.com> > wrote:
>
> > **
> >
> >
> > E9.04.507A
> >
> > Hello,
> >
> > I am trying to use the BPM condition of "number of rows in the
> > designed query is not less than 1" for the first time and I'm not
> > sure
>
> > I'm setting it up correctly.
> >
> > I'm adding this condition to an existing method directive that is
> > designed to set fields that determine if the packing slip should
> > auto print when a shipment is marked as shipped. It is on the method
> > CustShip.Update
> >
> > The new condition that I need to add is to check to see if any of
> > the associated orders for this shipment have a value of $0 (unless
> > OrderHed.CheckBox04 is true).
> >
> > The query I designed looks like this:
> >
> > for each ttShipHead where ttShipHead.Company = CUR-COMP and
> > ttShipHead.RowMod = 'U' , each ShipDtl no-lock where shipdtl.Company
> > =
>
> > ttShipHead.Company and ShipDtl.PackNum = ttShipHead.PackNum , each
> > OrderHed no-lock where (OrderHed.CheckBox04 = true Or
> > OrderHed.OrderAmt
> > > 0) and (ShipDtl.Company = OrderHed.Company and ShipDtl.OrderNum =
> > OrderHed.OrderNum )
> >
> > The expectation is that if the number of rows returned is 1 or
> > greater, the condition would evaluate as true and the method
> > directive
>
> > would process the Actions.
> >
> > I created BAQ to monitor the results and the method directive is
> > behaving as though the new condition doesn't exist. It seems to be
> > evaluating to true regardless of the order amount.
> >
> > Any ideas of what I have wrong?
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com
>
> Ask us about our clean, green and
>
> > beautiful matting and flooring
> >
> > This message is intended only for the individual named. If you are
> > not
>
> > the named addressee you should not disseminate, distribute or copy
> this e-mail.
> > Please notify the sender immediately by e-mail if you have received
> > this e-mail by mistake. Please note that any views or opinions
> > presented in this email are solely those of the author and do not
> > necessarily represent those of the company.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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
>
> [Non-text portions of this message have been removed]
>
>
>
[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/.
(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