Updatable Dashboard - Job number verification process

I am getting stuck at the point of creating the query designer. I bring
in the LaborDtl but the display tab does not allow me to select any
fields. It is grayed out. I cannot duplicate creating the code in your
previous email when composing the query using the Editor. How are you
configuring it?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Thursday, May 09, 2013 1:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process





It doesn't matter which tables..everything you have selected under the
display tab falls under ttresults. The format is
ttresults.tablename_fieldname

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@... <mailto:cchang%40apog.com> > wrote:

When I try adding the ttResults table into the design query, I am
getting an application error stating that it "could not load file or
assembly...or one of its dependencies. The system cannot find the file
specified." Do I need to upload the updatable BAQ .dll file somewhere?
What tables did you join together in your designed query?

________________________________

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 Rob Bucek
Sent: Thursday, May 09, 2013 12:48 PM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

I have tested this, it does work.. it assumes you are bringing in
labordtl.jobnum

In baq designer, update tab\update processing under Advanced BPM
processing (button), in the tree highlight the update method, choose new
preprocessing. Give it a name, enable it, check prevent endless loops.
Create a condition, choose the number of rows in the designed query.
Configure it per instructions provided in previous email, same as
actions. Save your BPM, regenerate BPM directive and test.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 11:47 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Where would I need to insert this code? I tried inserting it in the
'compose query' screen but an error message comes up indicating "Unable
to find any table in the query". Do I need to bring in the JobHed table
into the query?

________________________________

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 Rob Bucek
Sent: Thursday, May 09, 2013 11:00 AM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

My last email contained what you needed to do in the updateable baq to
validate the job number

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 10:41 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: RE: [Vantage] Updatable Dashboard - Job number verification
process

In the application Help, this is what it states:

To complete this functionality, you can monitor the data users enter by
creating Business Process Management (BPM) directives. As users enter
data through an updatable BAQ, you can set up Updatable BAQ methods that
validate whether the data being entered is correct, send email alerts,
or cause other processes to run.

I am trying to create a BPM directive to "validate whether the data
being entered is correct" when updating.

________________________________

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%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> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Thursday, May 09, 2013 9:42 AM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, so from what I'm reading, your job number is being pulled in from an
existing labor dtl record. You are not allowing new record creation
through the BAQ. Why would you need to validate the job number at all?
If it wasn't valid it wouldn't exist in the labordtl record in the first
place. If you are not changing it to a different job number, just
updating quantity, don't make the jobnum field updateable. If you really
need to validate this, your query would look something like this...

On a pre-process against the update method

Using number of rows in the designed query is equal to 0

for each ttresults where ttresults.RowMod = 'U' no-lock,
each jobhead where jobhead.company = ttresults.labordtl_company and
jobhead.jobnum = ttresults.labordtl_jobnum.

So if no rows are returned, execute your actions.. which could be raise
exception, show message, execute 4gl code, etc..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Chang, Chia
Sent: Thursday, May 09, 2013 8:50 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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.

My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.

________________________________

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%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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: 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%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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%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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: 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%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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%40yahoogroups.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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%40yahoogroups.com> <mailto:vantage%40yahoogroups.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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto: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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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/links

[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]

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





[Non-text portions of this message have been removed]
When creating an updatable dashboard and setting the job number field as updatable, the system does not verify if the job number is a valid job number upon saving. Is this standard updatable dashboard functionality or is there a way to allow the updatable dashboard to utilize standard Epicor verification processes?
If you don't want them to create new job numbers, why make the job number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable Dashboard - Job number verification process



When creating an updatable dashboard and setting the job number field as updatable, the system does not verify if the job number is a valid job number upon saving. Is this standard updatable dashboard functionality or is there a way to allow the updatable dashboard to utilize standard Epicor verification processes?



[Non-text portions of this message have been removed]
They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process





If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

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





[Non-text portions of this message have been removed]
Ok, I think I follow what you are trying to do now, you would create a preprocessing BPM through the update tab on the updateable baq (use the number of rows in the designed query) to verify if that job was an existing job number, if not, then cancel the update and give them a message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable Dashboard - Job number verification process



They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 cchang015
Sent: Tuesday, May 07, 2013 10:44 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]
I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process





Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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 Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 cchang015
Sent: Tuesday, May 07, 2013 10:44 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]
In order for me to help you more i need more info on how your baq is constructed..what tables have you brought in, what take specially are you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID


"Chang, Chia" <cchang@...> wrote:



I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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 Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 cchang015
Sent: Tuesday, May 07, 2013 10:44 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]
To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID


"Chang, Chia" <cchang@...> wrote:



I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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 Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 cchang015
Sent: Tuesday, May 07, 2013 10:44 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]



------------------------------------

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
Is this when they add new records? If you're looking at an existing entry and updating quantity would they change the job number? You'd have to validate a lot more than just the job number in that case.


Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable Dashboard - Job number verification process



To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@...<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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 Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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 Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 cchang015
Sent: Tuesday, May 07, 2013 10:44 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] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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

Reply via web post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1MzcEc2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=120537>

Reply to sender <mailto:cchang@...?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20number%20verification%20process>

Reply to group <mailto:vantage@yahoogroups.com?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20number%20verification%20process>

Start a New Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4NA--> (7)

Recent Activity:

* New Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzEzNjgwNDg0MzY->
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/links



[Non-text portions of this message have been removed]
Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.



My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process





Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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 Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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 Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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 Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@... <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<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/links

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





[Non-text portions of this message have been removed]
Ok, so from what I'm reading, your job number is being pulled in from an existing labor dtl record. You are not allowing new record creation through the BAQ. Why would you need to validate the job number at all? If it wasn't valid it wouldn't exist in the labordtl record in the first place. If you are not changing it to a different job number, just updating quantity, don't make the jobnum field updateable. If you really need to validate this, your query would look something like this...

On a pre-process against the update method

Using number of rows in the designed query is equal to 0

for each ttresults where ttresults.RowMod = 'U' no-lock,
each jobhead where jobhead.company = ttresults.labordtl_company and jobhead.jobnum = ttresults.labordtl_jobnum.

So if no rows are returned, execute your actions.. which could be raise exception, show message, execute 4gl code, etc..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chang, Chia
Sent: Thursday, May 09, 2013 8:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable Dashboard - Job number verification process



Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.

My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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 Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@...<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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 Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com> <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 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: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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%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> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com> <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@...<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<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/links

[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]
We do not want it to validate upon retrieval of the existing record but
validate upon updating the job number field. I understand your
questioning of why we are doing this but I am looking at other
applications of validation perhaps other fields in the future and would
like to know a way to do this. It seems odd to me that the system will
allow the user to update the Job Number field without any validation.
Regardless of the application use, all we are looking for is when we set
the Job Number field to be updatable and make a change to the Job Number
that is invalid, click save or update, the system will allow all entries
regardless if the updated Job Number exists or not.



We are trying to set up a validation process upon any field when
updating existing records in an updatable BAQ.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Thursday, May 09, 2013 9:42 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process





Ok, so from what I'm reading, your job number is being pulled in from an
existing labor dtl record. You are not allowing new record creation
through the BAQ. Why would you need to validate the job number at all?
If it wasn't valid it wouldn't exist in the labordtl record in the first
place. If you are not changing it to a different job number, just
updating quantity, don't make the jobnum field updateable. If you really
need to validate this, your query would look something like this...

On a pre-process against the update method

Using number of rows in the designed query is equal to 0

for each ttresults where ttresults.RowMod = 'U' no-lock,
each jobhead where jobhead.company = ttresults.labordtl_company and
jobhead.jobnum = ttresults.labordtl_jobnum.

So if no rows are returned, execute your actions.. which could be raise
exception, show message, execute 4gl code, etc..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Thursday, May 09, 2013 8:50 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.

My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.

________________________________

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 Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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 Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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 Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 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>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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/>
<http://groups.yahoo.com/group/vantage/files/>
<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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<http://groups.yahoo.com/group/vantage/files/>
<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/links

[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]
In the application Help, this is what it states:

To complete this functionality, you can monitor the data users enter by
creating Business Process Management (BPM) directives. As users enter
data through an updatable BAQ, you can set up Updatable BAQ methods that
validate whether the data being entered is correct, send email alerts,
or cause other processes to run.

I am trying to create a BPM directive to "validate whether the data
being entered is correct" when updating.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Thursday, May 09, 2013 9:42 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process





Ok, so from what I'm reading, your job number is being pulled in from an
existing labor dtl record. You are not allowing new record creation
through the BAQ. Why would you need to validate the job number at all?
If it wasn't valid it wouldn't exist in the labordtl record in the first
place. If you are not changing it to a different job number, just
updating quantity, don't make the jobnum field updateable. If you really
need to validate this, your query would look something like this...

On a pre-process against the update method

Using number of rows in the designed query is equal to 0

for each ttresults where ttresults.RowMod = 'U' no-lock,
each jobhead where jobhead.company = ttresults.labordtl_company and
jobhead.jobnum = ttresults.labordtl_jobnum.

So if no rows are returned, execute your actions.. which could be raise
exception, show message, execute 4gl code, etc..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Thursday, May 09, 2013 8:50 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.

My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.

________________________________

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 Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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 Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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 Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 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>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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/>
<http://groups.yahoo.com/group/vantage/files/>
<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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<http://groups.yahoo.com/group/vantage/files/>
<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/links

[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]
My last email contained what you needed to do in the updateable baq to validate the job number

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chang, Chia
Sent: Thursday, May 09, 2013 10:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable Dashboard - Job number verification process



In the application Help, this is what it states:

To complete this functionality, you can monitor the data users enter by
creating Business Process Management (BPM) directives. As users enter
data through an updatable BAQ, you can set up Updatable BAQ methods that
validate whether the data being entered is correct, send email alerts,
or cause other processes to run.

I am trying to create a BPM directive to "validate whether the data
being entered is correct" when updating.

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Thursday, May 09, 2013 9:42 AM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, so from what I'm reading, your job number is being pulled in from an
existing labor dtl record. You are not allowing new record creation
through the BAQ. Why would you need to validate the job number at all?
If it wasn't valid it wouldn't exist in the labordtl record in the first
place. If you are not changing it to a different job number, just
updating quantity, don't make the jobnum field updateable. If you really
need to validate this, your query would look something like this...

On a pre-process against the update method

Using number of rows in the designed query is equal to 0

for each ttresults where ttresults.RowMod = 'U' no-lock,
each jobhead where jobhead.company = ttresults.labordtl_company and
jobhead.jobnum = ttresults.labordtl_jobnum.

So if no rows are returned, execute your actions.. which could be raise
exception, show message, execute 4gl code, etc..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 8:50 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.

My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.

________________________________

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 Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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 Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
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: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@...<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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%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><mailto:vantage%40yahoogroups.com>] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com> <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 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><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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%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><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com> <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@...<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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/links

[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]
Where would I need to insert this code? I tried inserting it in the
'compose query' screen but an error message comes up indicating "Unable
to find any table in the query". Do I need to bring in the JobHed table
into the query?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Thursday, May 09, 2013 11:00 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process





My last email contained what you needed to do in the updateable baq to
validate the job number

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Thursday, May 09, 2013 10:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

In the application Help, this is what it states:

To complete this functionality, you can monitor the data users enter by
creating Business Process Management (BPM) directives. As users enter
data through an updatable BAQ, you can set up Updatable BAQ methods that
validate whether the data being entered is correct, send email alerts,
or cause other processes to run.

I am trying to create a BPM directive to "validate whether the data
being entered is correct" when updating.

________________________________

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 Rob Bucek
Sent: Thursday, May 09, 2013 9:42 AM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, so from what I'm reading, your job number is being pulled in from an
existing labor dtl record. You are not allowing new record creation
through the BAQ. Why would you need to validate the job number at all?
If it wasn't valid it wouldn't exist in the labordtl record in the first
place. If you are not changing it to a different job number, just
updating quantity, don't make the jobnum field updateable. If you really
need to validate this, your query would look something like this...

On a pre-process against the update method

Using number of rows in the designed query is equal to 0

for each ttresults where ttresults.RowMod = 'U' no-lock,
each jobhead where jobhead.company = ttresults.labordtl_company and
jobhead.jobnum = ttresults.labordtl_jobnum.

So if no rows are returned, execute your actions.. which could be raise
exception, show message, execute 4gl code, etc..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 8:50 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.

My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.

________________________________

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 Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
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: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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%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> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: 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%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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%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>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 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>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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%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>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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/links

[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]
I have tested this, it does work.. it assumes you are bringing in labordtl.jobnum

In baq designer, update tab\update processing under Advanced BPM processing (button), in the tree highlight the update method, choose new preprocessing. Give it a name, enable it, check prevent endless loops. Create a condition, choose the number of rows in the designed query. Configure it per instructions provided in previous email, same as actions. Save your BPM, regenerate BPM directive and test.



Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chang, Chia
Sent: Thursday, May 09, 2013 11:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Updatable Dashboard - Job number verification process



Where would I need to insert this code? I tried inserting it in the
'compose query' screen but an error message comes up indicating "Unable
to find any table in the query". Do I need to bring in the JobHed table
into the query?

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Thursday, May 09, 2013 11:00 AM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

My last email contained what you needed to do in the updateable baq to
validate the job number

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 10:41 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

In the application Help, this is what it states:

To complete this functionality, you can monitor the data users enter by
creating Business Process Management (BPM) directives. As users enter
data through an updatable BAQ, you can set up Updatable BAQ methods that
validate whether the data being entered is correct, send email alerts,
or cause other processes to run.

I am trying to create a BPM directive to "validate whether the data
being entered is correct" when updating.

________________________________

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 Rob Bucek
Sent: Thursday, May 09, 2013 9:42 AM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, so from what I'm reading, your job number is being pulled in from an
existing labor dtl record. You are not allowing new record creation
through the BAQ. Why would you need to validate the job number at all?
If it wasn't valid it wouldn't exist in the labordtl record in the first
place. If you are not changing it to a different job number, just
updating quantity, don't make the jobnum field updateable. If you really
need to validate this, your query would look something like this...

On a pre-process against the update method

Using number of rows in the designed query is equal to 0

for each ttresults where ttresults.RowMod = 'U' no-lock,
each jobhead where jobhead.company = ttresults.labordtl_company and
jobhead.jobnum = ttresults.labordtl_jobnum.

So if no rows are returned, execute your actions.. which could be raise
exception, show message, execute 4gl code, etc..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 8:50 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.

My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.

________________________________

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 Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: 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%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: 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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@...<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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%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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com> <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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%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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com> <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%40yahoogroups.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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@...<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto: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%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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/links

[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]
When I try adding the ttResults table into the design query, I am
getting an application error stating that it "could not load file or
assembly...or one of its dependencies. The system cannot find the file
specified." Do I need to upload the updatable BAQ .dll file somewhere?
What tables did you join together in your designed query?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Thursday, May 09, 2013 12:48 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process





I have tested this, it does work.. it assumes you are bringing in
labordtl.jobnum

In baq designer, update tab\update processing under Advanced BPM
processing (button), in the tree highlight the update method, choose new
preprocessing. Give it a name, enable it, check prevent endless loops.
Create a condition, choose the number of rows in the designed query.
Configure it per instructions provided in previous email, same as
actions. Save your BPM, regenerate BPM directive and test.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Thursday, May 09, 2013 11:47 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Where would I need to insert this code? I tried inserting it in the
'compose query' screen but an error message comes up indicating "Unable
to find any table in the query". Do I need to bring in the JobHed table
into the query?

________________________________

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 Rob Bucek
Sent: Thursday, May 09, 2013 11:00 AM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

My last email contained what you needed to do in the updateable baq to
validate the job number

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 10:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

In the application Help, this is what it states:

To complete this functionality, you can monitor the data users enter by
creating Business Process Management (BPM) directives. As users enter
data through an updatable BAQ, you can set up Updatable BAQ methods that
validate whether the data being entered is correct, send email alerts,
or cause other processes to run.

I am trying to create a BPM directive to "validate whether the data
being entered is correct" when updating.

________________________________

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 Rob Bucek
Sent: Thursday, May 09, 2013 9:42 AM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, so from what I'm reading, your job number is being pulled in from an
existing labor dtl record. You are not allowing new record creation
through the BAQ. Why would you need to validate the job number at all?
If it wasn't valid it wouldn't exist in the labordtl record in the first
place. If you are not changing it to a different job number, just
updating quantity, don't make the jobnum field updateable. If you really
need to validate this, your query would look something like this...

On a pre-process against the update method

Using number of rows in the designed query is equal to 0

for each ttresults where ttresults.RowMod = 'U' no-lock,
each jobhead where jobhead.company = ttresults.labordtl_company and
jobhead.jobnum = ttresults.labordtl_jobnum.

So if no rows are returned, execute your actions.. which could be raise
exception, show message, execute 4gl code, etc..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 8:50 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: RE: [Vantage] Updatable Dashboard - Job number verification
process

Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.

My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.

________________________________

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%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> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: 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%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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%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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: 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%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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%40yahoogroups.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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%40yahoogroups.com> <mailto:vantage%40yahoogroups.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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@... <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto: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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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/links

[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]
I just have the labor detail table

Sent from my Verizon Wireless 4G LTE DROID


"Chang, Chia" <cchang@...> wrote:



When I try adding the ttResults table into the design query, I am
getting an application error stating that it "could not load file or
assembly...or one of its dependencies. The system cannot find the file
specified." Do I need to upload the updatable BAQ .dll file somewhere?
What tables did you join together in your designed query?

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Thursday, May 09, 2013 12:48 PM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

I have tested this, it does work.. it assumes you are bringing in
labordtl.jobnum

In baq designer, update tab\update processing under Advanced BPM
processing (button), in the tree highlight the update method, choose new
preprocessing. Give it a name, enable it, check prevent endless loops.
Create a condition, choose the number of rows in the designed query.
Configure it per instructions provided in previous email, same as
actions. Save your BPM, regenerate BPM directive and test.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 11:47 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Where would I need to insert this code? I tried inserting it in the
'compose query' screen but an error message comes up indicating "Unable
to find any table in the query". Do I need to bring in the JobHed table
into the 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 Rob Bucek
Sent: Thursday, May 09, 2013 11:00 AM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

My last email contained what you needed to do in the updateable baq to
validate the job number

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 10: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] Updatable Dashboard - Job number verification
process

In the application Help, this is what it states:

To complete this functionality, you can monitor the data users enter by
creating Business Process Management (BPM) directives. As users enter
data through an updatable BAQ, you can set up Updatable BAQ methods that
validate whether the data being entered is correct, send email alerts,
or cause other processes to run.

I am trying to create a BPM directive to "validate whether the data
being entered is correct" when updating.

________________________________

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 Rob Bucek
Sent: Thursday, May 09, 2013 9:42 AM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, so from what I'm reading, your job number is being pulled in from an
existing labor dtl record. You are not allowing new record creation
through the BAQ. Why would you need to validate the job number at all?
If it wasn't valid it wouldn't exist in the labordtl record in the first
place. If you are not changing it to a different job number, just
updating quantity, don't make the jobnum field updateable. If you really
need to validate this, your query would look something like this...

On a pre-process against the update method

Using number of rows in the designed query is equal to 0

for each ttresults where ttresults.RowMod = 'U' no-lock,
each jobhead where jobhead.company = ttresults.labordtl_company and
jobhead.jobnum = ttresults.labordtl_jobnum.

So if no rows are returned, execute your actions.. which could be raise
exception, show message, execute 4gl code, etc..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Chang, Chia
Sent: Thursday, May 09, 2013 8:50 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> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.

My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.

________________________________

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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: 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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: 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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@...<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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%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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com> <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%40yahoogroups.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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com> <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@...<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto: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%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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/links

[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]





[Non-text portions of this message have been removed]
It doesn't matter which tables..everything you have selected under the display tab falls under ttresults. The format is ttresults.tablename_fieldname

Sent from my Verizon Wireless 4G LTE DROID


"Chang, Chia" <cchang@...> wrote:



When I try adding the ttResults table into the design query, I am
getting an application error stating that it "could not load file or
assembly...or one of its dependencies. The system cannot find the file
specified." Do I need to upload the updatable BAQ .dll file somewhere?
What tables did you join together in your designed query?

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Thursday, May 09, 2013 12:48 PM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

I have tested this, it does work.. it assumes you are bringing in
labordtl.jobnum

In baq designer, update tab\update processing under Advanced BPM
processing (button), in the tree highlight the update method, choose new
preprocessing. Give it a name, enable it, check prevent endless loops.
Create a condition, choose the number of rows in the designed query.
Configure it per instructions provided in previous email, same as
actions. Save your BPM, regenerate BPM directive and test.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 11:47 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Where would I need to insert this code? I tried inserting it in the
'compose query' screen but an error message comes up indicating "Unable
to find any table in the query". Do I need to bring in the JobHed table
into the 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 Rob Bucek
Sent: Thursday, May 09, 2013 11:00 AM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

My last email contained what you needed to do in the updateable baq to
validate the job number

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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 Chang, Chia
Sent: Thursday, May 09, 2013 10: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] Updatable Dashboard - Job number verification
process

In the application Help, this is what it states:

To complete this functionality, you can monitor the data users enter by
creating Business Process Management (BPM) directives. As users enter
data through an updatable BAQ, you can set up Updatable BAQ methods that
validate whether the data being entered is correct, send email alerts,
or cause other processes to run.

I am trying to create a BPM directive to "validate whether the data
being entered is correct" when updating.

________________________________

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 Rob Bucek
Sent: Thursday, May 09, 2013 9:42 AM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, so from what I'm reading, your job number is being pulled in from an
existing labor dtl record. You are not allowing new record creation
through the BAQ. Why would you need to validate the job number at all?
If it wasn't valid it wouldn't exist in the labordtl record in the first
place. If you are not changing it to a different job number, just
updating quantity, don't make the jobnum field updateable. If you really
need to validate this, your query would look something like this...

On a pre-process against the update method

Using number of rows in the designed query is equal to 0

for each ttresults where ttresults.RowMod = 'U' no-lock,
each jobhead where jobhead.company = ttresults.labordtl_company and
jobhead.jobnum = ttresults.labordtl_jobnum.

So if no rows are returned, execute your actions.. which could be raise
exception, show message, execute 4gl code, etc..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Chang, Chia
Sent: Thursday, May 09, 2013 8:50 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> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Yes you are right that they would need to validate a lot more but I want
to start off with a simple BPM PreProcess on the job number first and
then go from there. How would I even start to use the BPM processing
query editor to validate against the job number using the LaborDtl
table? The updatable BAQ query already has criteria set up and will
filter on existing data only and we are currently not allowing new
records to be created in the updatable dashboard.

My concern for future updatable dashboards is that if we make "any"
field available, there is no system validation to stop a user from
updating the fields with invalid data and that they are writing directly
into the database. Even when I pull in an existing entry into the
dashboard, the system does not validate if the updated job number exists
or not when saving. I would like to put some BPM processing validation
to prevent this from happening in the BPM processing query editor.

________________________________

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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 4:42 PM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Is this when they add new records? If you're looking at an existing
entry and updating quantity would they change the job number? You'd have
to validate a lot more than just the job number in that case.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 4:27 PM
To: 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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

To keep it simple, I am bringing in the LaborDtl table only in my BAQ
and want to update the Labor Qty and Job Number from the LaborDtl table.
And then set a PreProcessing BPM to verify that the Job Number is valid
upon updating. Where I am stuck at is in the Advanced BPM Processing
query editor to validate the Job Number on the LaborDtl table.

-----Original Message-----
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%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>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 2:39 PM
To: 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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Updatable Dashboard - Job number verification
process

In order for me to help you more i need more info on how your baq is
constructed..what tables have you brought in, what take specially are
you getting the job number field from..

Sent from my Verizon Wireless 4G LTE DROID

"Chang, Chia" <cchang@...<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com>> wrote:

I am not able to get the "designed query" editor to do what I am looking
for. I am pulling in the job number from the LaborDtl table but having
a hard time using the preprocessing BPM within the editor. When I go to
compose my query using the editor, how would I create the BAQ to make it
work to validate for an existing job number?

________________________________

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%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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 08, 2013 11:29 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com> <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

Ok, I think I follow what you are trying to do now, you would create a
preprocessing BPM through the update tab on the updateable baq (use the
number of rows in the designed query) to verify if that job was an
existing job number, if not, then cancel the update and give them a
message as to why the transaction was canceled.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%40yahoogroups.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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chang, Chia
Sent: Wednesday, May 08, 2013 9:15 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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

They are only updating the job number and are not creating new job
numbers. Is there a validation process in updatable dashboards?

________________________________

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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Rob Bucek
Sent: Tuesday, May 07, 2013 10:49 AM
To:
'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com> <mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com><mailto:%26%2339%3Bvantage%
40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>
<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: RE: [Vantage] Updatable Dashboard - Job number verification
process

If you don't want them to create new job numbers, why make the job
number field updateable?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40
web654
12.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of cchang015
Sent: Tuesday, May 07, 2013 10:44 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> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updatable Dashboard - Job number verification process

When creating an updatable dashboard and setting the job number field as
updatable, the system does not verify if the job number is a valid job
number upon saving. Is this standard updatable dashboard functionality
or is there a way to allow the updatable dashboard to utilize standard
Epicor verification processes?

[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]

------------------------------------

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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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

Reply via web
post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwZzllY2k4BF9
TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMjA1Mzc
Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzY4MDQ4NDM2?act=reply&messageNum=12053
7>

Reply to sender <mailto:cchang@...<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
<mailto:cchang%40apog.com> <mailto:cchang%40apog.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Reply to group <mailto: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%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
?subject=RE%3A%20%5BVantage%5D%20Updatable%20Dashboard%20-%20Job%20numbe
r%20verification%20process>

Start a New
Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjaHVwZzNzBF
9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsaw
NudHBjBHN0aW1lAzEzNjgwNDg0MzY->

Messages in this
topic<http://groups.yahoo.com/group/vantage/message/120484;_ylc=X3oDMTM2
M3BlY2hwBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJ
ZAMxMjA1MzcEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzY4MDQ4NDM2BHRwY0lkAzEyMDQ4
NA--> (7)

Recent Activity:

* New
Photos<http://groups.yahoo.com/group/vantage/spnew;_ylc=X3oDMTJkaDNqZDNw
BF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNs
awN2cGhvdARzdGltZQMxMzY4MDQ4NDM2> 2
* New
Files<http://groups.yahoo.com/group/vantage/files;_ylc=X3oDMTJlNWY2YmNwB
F9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsa
wN2ZmlsZXMEc3RpbWUDMTM2ODA0ODQzNg--> 5
Visit Your
Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjazlmcGdiBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2h
wBHN0aW1lAzEzNjgwNDg0MzY->
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/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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/links

[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]





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