BPM Logic on Order Job Wizard

Yahoo Archive
1
Jose,

Thanks for the quick response, but no go. The query by itself in the BAQ works fine (except that I can't use the "ttOrderJobWiz" table, I use JobProd instead).

I'll keep messing with it... thank goodness it's Friday and I can chew on it over the weekend when I'm not cleaning the gutters...

Ernie

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Change the condition to is greater than Zero
> Also run that same code in a BAQ with an Order NUmber you know and make sure
> it works properly
>
> *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/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Fri, Mar 18, 2011 at 1:33 PM, Elizabeth <gracefulthreads@...>wrote:
>
> >
> >
> > I'm trying to create a BPM to stop the Order Job Wizard business object if
> > the customer is on credit hold. There are only 6 processes in the object,
> > and nothing works. Every customer, whether on hold or not, triggers the
> > action (raise an exception).
> >
> > The condition is "number of rows in the 'OrderJobWizCreditHold' query is
> > not less than 1", and the query logic is:
> >
> > for each ttJWOrderRel no-lock where ttJWOrderRel.RowMod = 'A' ,
> > each OrderHed no-lock where (ttJWOrderRel.Company = OrderHed.Company and
> > ttJWOrderRel.OrderNum = OrderHed.OrderNum ) ,
> > each Customer no-lock where Customer.CreditHold = "TRUE" and
> > (OrderHed.Company = Customer.Company and OrderHed.CustNum = Customer.CustNum
> > )
> >
> > Any idea what I'm missing?
> >
> > Ernie Lowell
> > Diba Industries
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
2
I'm trying to create a BPM to stop the Order Job Wizard business object if the customer is on credit hold. There are only 6 processes in the object, and nothing works. Every customer, whether on hold or not, triggers the action (raise an exception).

The condition is "number of rows in the 'OrderJobWizCreditHold' query is not less than 1", and the query logic is:

for each ttJWOrderRel no-lock where ttJWOrderRel.RowMod = 'A' ,
each OrderHed no-lock where (ttJWOrderRel.Company = OrderHed.Company and ttJWOrderRel.OrderNum = OrderHed.OrderNum ) ,
each Customer no-lock where Customer.CreditHold = "TRUE" and (OrderHed.Company = Customer.Company and OrderHed.CustNum = Customer.CustNum )

Any idea what I'm missing?

Ernie Lowell
Diba Industries
3
Change the condition to is greater than Zero
Also run that same code in a BAQ with an Order NUmber you know and make sure
it works properly

*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/>

*Quis custodiet ipsos custodes?*



On Fri, Mar 18, 2011 at 1:33 PM, Elizabeth <gracefulthreads@...>wrote:

>
>
> I'm trying to create a BPM to stop the Order Job Wizard business object if
> the customer is on credit hold. There are only 6 processes in the object,
> and nothing works. Every customer, whether on hold or not, triggers the
> action (raise an exception).
>
> The condition is "number of rows in the 'OrderJobWizCreditHold' query is
> not less than 1", and the query logic is:
>
> for each ttJWOrderRel no-lock where ttJWOrderRel.RowMod = 'A' ,
> each OrderHed no-lock where (ttJWOrderRel.Company = OrderHed.Company and
> ttJWOrderRel.OrderNum = OrderHed.OrderNum ) ,
> each Customer no-lock where Customer.CreditHold = "TRUE" and
> (OrderHed.Company = Customer.Company and OrderHed.CustNum = Customer.CustNum
> )
>
> Any idea what I'm missing?
>
> Ernie Lowell
> Diba Industries
>
>
>


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