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
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.
Here are a couple of examples:
packnum
checkbox01
checkbox02
readytoinvoice
trackingnumber
shipdate
shipviacode
MaxOrderNum
orderamt
checkbox04
72205
1
1
1
1Z0AW5861200661277
12/5/2012
UPS3
3075649
0
0
72178
1
0
1
1Z0246696769893969
12/5/2012
WSHP
3075672
0
0
The field to watch is checkbox01. If orderamt equals 0 and checkbox04 =
0 then the Actions should not trigger and checkbox01 should not be set
to 1.
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@... | 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]
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.
Here are a couple of examples:
packnum
checkbox01
checkbox02
readytoinvoice
trackingnumber
shipdate
shipviacode
MaxOrderNum
orderamt
checkbox04
72205
1
1
1
1Z0AW5861200661277
12/5/2012
UPS3
3075649
0
0
72178
1
0
1
1Z0246696769893969
12/5/2012
WSHP
3075672
0
0
The field to watch is checkbox01. If orderamt equals 0 and checkbox04 =
0 then the Actions should not trigger and checkbox01 should not be set
to 1.
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@... | 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]