Thank you everyone for your help. I ended up changing the BPM to look
at the SalesRepCode1 field and everything is working fine now. It looks
like Vantage stores the sales reps in separate fields and does not
combine them into the SalesRepList field until after processing. Now,
if only they would leave them in SalesRepCode1, 2, 3, 4 and 5 instead of
combining them......
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of advantage@...
Sent: Tuesday, November 03, 2009 2:24 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Problem with pre-processing directive
Run a trace and see what that fields default
Look at data dictionary and see what that fields default. That's the
field that has 5 tildas as place holders ~~~~~
Also try running an info message telling yourself how and when that
field populates pre and post
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: "Linda Lowney" <llowney@...
<mailto:llowney%40pridesigns.com> >
Date: Tue, 3 Nov 2009 13:54:24
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Subject: FW: [Vantage] Problem with pre-processing directive
Help! Can anyone help me out with this? I followed the instructions in
the User Guide but Vantage won't let the user save the order even after
they have corrected the problem. Is there any other way to make the
sales rep mandatory using a BPM?
Regards,
Linda
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Linda Lowney
Sent: Tuesday, November 03, 2009 1:10 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive
I tried:
Condition: Number of rows in the 'qryCkSalesperson' query is not less
than 1
Query: for each ttOrderhed where tt OrderHed.SalesRepList = ""
Action: raise exception based on the tempSlsTest3 template
I still have the same problem. The directive fires, but does not go
away after I select a salesperson.
Regards,
Linda
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Sean McDaniel
Sent: Tuesday, November 03, 2009 11:56 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive
Then your other option is to see if a query returns > 0 rows and create
your
own query
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Linda Lowney
Sent: Tuesday, November 03, 2009 11:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive
Thanks, I noticed that too. I pick the ttOrderHed table from the list
and click on the SalesRepList checkbox then hit Ok and it shows me
OrderHed instead of ttOrderHed in the condition.
Linda
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Sean McDaniel
Sent: Tuesday, November 03, 2009 11:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive
It looks like you are querying the OrderHed table instead of the
TTOrderHed
table.
The ordered would be live data, the TTORderHed is data that is at the
form
level and may or may not be at the "live" level.
If you are pre-processing then ttOrderHed contains changes made at the
form
and OrderHed would contain the original values.
If you are post-processing then ttOrderHed and OrderHed should be
identical
I would think.
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Linda Lowney
Sent: Tuesday, November 03, 2009 9:59 AM
To: Vantage@yahoogroups.com <mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
Subject: [Vantage] Problem with pre-processing directive
I'm having a problem with this method directive that is supposed to
check for a missing salesperson on an order:
Business Object: SalesOrder.Update
Conditions: the OrderHed.SalesRepList field of the changed row is equal
to the "" value
Action: raise exception based on the tmpSalesperson template
This works great and sends an error message, but when the user selects a
salesperson from the list and then presses the save button the message
pops up again. Can anyone tell me what I've done wrong?
Regards,
Linda Lowney
Software Specialist
Pride Signs
255 Pinebush Road
Cambridge, ON N1T 1B9
P 519 622 4040 ext. 258
F 519 622 4031
www.pridesigns.com <http://www.pridesigns.com>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
at the SalesRepCode1 field and everything is working fine now. It looks
like Vantage stores the sales reps in separate fields and does not
combine them into the SalesRepList field until after processing. Now,
if only they would leave them in SalesRepCode1, 2, 3, 4 and 5 instead of
combining them......
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of advantage@...
Sent: Tuesday, November 03, 2009 2:24 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Problem with pre-processing directive
Run a trace and see what that fields default
Look at data dictionary and see what that fields default. That's the
field that has 5 tildas as place holders ~~~~~
Also try running an info message telling yourself how and when that
field populates pre and post
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: "Linda Lowney" <llowney@...
<mailto:llowney%40pridesigns.com> >
Date: Tue, 3 Nov 2009 13:54:24
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Subject: FW: [Vantage] Problem with pre-processing directive
Help! Can anyone help me out with this? I followed the instructions in
the User Guide but Vantage won't let the user save the order even after
they have corrected the problem. Is there any other way to make the
sales rep mandatory using a BPM?
Regards,
Linda
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Linda Lowney
Sent: Tuesday, November 03, 2009 1:10 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive
I tried:
Condition: Number of rows in the 'qryCkSalesperson' query is not less
than 1
Query: for each ttOrderhed where tt OrderHed.SalesRepList = ""
Action: raise exception based on the tempSlsTest3 template
I still have the same problem. The directive fires, but does not go
away after I select a salesperson.
Regards,
Linda
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Sean McDaniel
Sent: Tuesday, November 03, 2009 11:56 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive
Then your other option is to see if a query returns > 0 rows and create
your
own query
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Linda Lowney
Sent: Tuesday, November 03, 2009 11:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive
Thanks, I noticed that too. I pick the ttOrderHed table from the list
and click on the SalesRepList checkbox then hit Ok and it shows me
OrderHed instead of ttOrderHed in the condition.
Linda
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Sean McDaniel
Sent: Tuesday, November 03, 2009 11:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive
It looks like you are querying the OrderHed table instead of the
TTOrderHed
table.
The ordered would be live data, the TTORderHed is data that is at the
form
level and may or may not be at the "live" level.
If you are pre-processing then ttOrderHed contains changes made at the
form
and OrderHed would contain the original values.
If you are post-processing then ttOrderHed and OrderHed should be
identical
I would think.
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Linda Lowney
Sent: Tuesday, November 03, 2009 9:59 AM
To: Vantage@yahoogroups.com <mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
Subject: [Vantage] Problem with pre-processing directive
I'm having a problem with this method directive that is supposed to
check for a missing salesperson on an order:
Business Object: SalesOrder.Update
Conditions: the OrderHed.SalesRepList field of the changed row is equal
to the "" value
Action: raise exception based on the tmpSalesperson template
This works great and sends an error message, but when the user selects a
salesperson from the list and then presses the save button the message
pops up again. Can anyone tell me what I've done wrong?
Regards,
Linda Lowney
Software Specialist
Pride Signs
255 Pinebush Road
Cambridge, ON N1T 1B9
P 519 622 4040 ext. 258
F 519 622 4031
www.pridesigns.com <http://www.pridesigns.com>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]