Hmmm...well I'm getting close. Here's my BPM:
Method: SalesOrder.ChangePartNum
Condition: number of rows in the 'IsPartCheckbox05Set' query is not less than 1
Query: for each ttOrderDtl where ttOrderDtl.RowMod = 'A' or ttOrderDtl.RowMod = 'U' ,
each Part where Part.Company = ttOrderDtl.Company and Part.PartNum = ttOrderDtl.PartNum and Part.Checkbox05 = True.
End.
Action: show informational message based on the Part Has eData template
This doesn't do anything. However changing the condition to add an OR condition to check if the PartNum equals a certain value triggers the Action, so I know I'm getting that far. Based on my tracing, this method gets called every time one adds/removes/updates a Part on a Sales Order.
Basically I want to check to see if Checkbox05 on the associated Part record for the Part being added or modified is set to True. That would trigger the first half of the business rule.
The next step would be to add logic to determine if the sales order also contains a part with a given PartNum. The point is that if I put Parts on the Sales Order with Checkbox05=True I also have to add this other part.
Hmm...would this be a good use of a sales kit?
-bws
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ross Hughes
Sent: Tuesday, April 21, 2009 11:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] SalesOrder BPM
Can you check at a different stage in the process? It may work on update
but if you have multiple parts on the order it would have to loop through
them, and every time the order updated.
Maybe something like a post-directive on the SalesOrder.GetNewOrderDetail
(or whatever exactly it is called...not in front of me). Run a 'query is
not less than one' condition with a query sort of like:
for each ttOrderDtl where ttOrderDtl.RowMod = 'A' or ttOrderDtl.RowMod = 'U'
,
First Part WHERE part.Company = ttOrderDtl.Company AND Part.checkbox01 =
True.
End.
Then select whatever action you need from there.
Ross
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Tuesday, April 21, 2009 3:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SalesOrder BPM
I want to write a BPM that checks to see if a Checkbox flag is set on
a Part when saving a Sales Order.
In looking at the temp tables available in a Pre-Processing directive
on SalesOrder.Update() I'm not sure how I'd accomplish this.
Can someone point me in the right direction?
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>
[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
------------------------------------
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
Method: SalesOrder.ChangePartNum
Condition: number of rows in the 'IsPartCheckbox05Set' query is not less than 1
Query: for each ttOrderDtl where ttOrderDtl.RowMod = 'A' or ttOrderDtl.RowMod = 'U' ,
each Part where Part.Company = ttOrderDtl.Company and Part.PartNum = ttOrderDtl.PartNum and Part.Checkbox05 = True.
End.
Action: show informational message based on the Part Has eData template
This doesn't do anything. However changing the condition to add an OR condition to check if the PartNum equals a certain value triggers the Action, so I know I'm getting that far. Based on my tracing, this method gets called every time one adds/removes/updates a Part on a Sales Order.
Basically I want to check to see if Checkbox05 on the associated Part record for the Part being added or modified is set to True. That would trigger the first half of the business rule.
The next step would be to add logic to determine if the sales order also contains a part with a given PartNum. The point is that if I put Parts on the Sales Order with Checkbox05=True I also have to add this other part.
Hmm...would this be a good use of a sales kit?
-bws
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ross Hughes
Sent: Tuesday, April 21, 2009 11:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] SalesOrder BPM
Can you check at a different stage in the process? It may work on update
but if you have multiple parts on the order it would have to loop through
them, and every time the order updated.
Maybe something like a post-directive on the SalesOrder.GetNewOrderDetail
(or whatever exactly it is called...not in front of me). Run a 'query is
not less than one' condition with a query sort of like:
for each ttOrderDtl where ttOrderDtl.RowMod = 'A' or ttOrderDtl.RowMod = 'U'
,
First Part WHERE part.Company = ttOrderDtl.Company AND Part.checkbox01 =
True.
End.
Then select whatever action you need from there.
Ross
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Tuesday, April 21, 2009 3:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SalesOrder BPM
I want to write a BPM that checks to see if a Checkbox flag is set on
a Part when saving a Sales Order.
In looking at the temp tables available in a Pre-Processing directive
on SalesOrder.Update() I'm not sure how I'd accomplish this.
Can someone point me in the right direction?
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>
[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
------------------------------------
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