You may be able to do this with a BAQ without adding BPMs. I have not
fully tested this.
Master Table = JobOper
Alias Table Join to JobOper renaming it JobPriorOper.
Find First or Last to get just one operation prior not all, depends if
your sorting.
Criteria = JobPriorOper.OprSeq < JobOper.OprSeq.
EXPECTED WORK you can filter for Actual Time or Pieces turned in.
AVALIABLE WORK filter if prior operation is complete.
Since your bringing all the fields you can tune as you like.
for each JobOper no-lock , first JobPriorOper no-lock where
(JobOper.Company = JobPriorOper.Company and JobOper.JobNum =
JobPriorOper.JobNum and JobOper.AssemblySeq = JobPriorOper.AssemblySeq )
and JobPriorOper.OprSeq < JobOper.OprSeq .
It would be fantastic if Epicor would two fields to each JobOper record.
PriorOperationSequence and NextOperationSequence this would make
creating BAQs for all kinds of Scheduling stuff much easier.
Patrick Winter
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Wednesday, June 13, 2012 08:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Grouping a Dashboard
What I am looking to do is I am re-creating the Work Queue\Priority
Dispatch
report Functionality in a Dashboard. I placed a UD field on Job
Operation
(JobOper.ShortChar01) and through 4 different BPMs I have setup this
field
to update with a status of either CURRENT, AVAILABLE or EXPECTED. Much
like
the Priority Dispatch Report uses.
Now I want to create a Dashboard that will display Jobs that have been
released and is scheduled for a Resource or Resource Group and show in
three
different groups corresponding to the Job Operation status. I have the
BAQ
and Dashboard built that does this, and with the code from the group to
automatically open the groups, but want it Grouped in the exact order of
CURRENT at the Top, AVAILABLE in the middle and EXPECTED at the bottom.
Instead of it being AVAILABLE, CURRENT EXPECTED or visa-versa.
The plan is to then run a large display next to these Resources or
Resource
Groups (Machines or Departments) using these Dashboards so the operator
of a
Machine or the Department can easily see what the status is on all Jobs
related to that Machine or Department. Then possibly place a button on a
Dashboard where they can clock into and out of Jobs\Operations without
using
MES. Then the goal would be to try to go without needing Job Travelers.
The Dashboards make scheduling more dynamic\real time without having to
talk
directly to an operator or department, we do a lot of rearranging with
the
schedule on a day to day basis due to rush jobs.
Scott
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Jose Gomez
Sent: Tuesday, June 12, 2012 7:32 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Grouping a Dashboard
Add te grouping and sorting then right click save layout go into dev
mode
and make a small change. save
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Tue, Jun 12, 2012 at 6:05 PM, litzer1 <scott.litzau@...
<mailto:scott.litzau%40olympusgrp.com> >wrote:
------------------------------------
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
[Non-text portions of this message have been removed]
fully tested this.
Master Table = JobOper
Alias Table Join to JobOper renaming it JobPriorOper.
Find First or Last to get just one operation prior not all, depends if
your sorting.
Criteria = JobPriorOper.OprSeq < JobOper.OprSeq.
EXPECTED WORK you can filter for Actual Time or Pieces turned in.
AVALIABLE WORK filter if prior operation is complete.
Since your bringing all the fields you can tune as you like.
for each JobOper no-lock , first JobPriorOper no-lock where
(JobOper.Company = JobPriorOper.Company and JobOper.JobNum =
JobPriorOper.JobNum and JobOper.AssemblySeq = JobPriorOper.AssemblySeq )
and JobPriorOper.OprSeq < JobOper.OprSeq .
It would be fantastic if Epicor would two fields to each JobOper record.
PriorOperationSequence and NextOperationSequence this would make
creating BAQs for all kinds of Scheduling stuff much easier.
Patrick Winter
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Wednesday, June 13, 2012 08:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Grouping a Dashboard
What I am looking to do is I am re-creating the Work Queue\Priority
Dispatch
report Functionality in a Dashboard. I placed a UD field on Job
Operation
(JobOper.ShortChar01) and through 4 different BPMs I have setup this
field
to update with a status of either CURRENT, AVAILABLE or EXPECTED. Much
like
the Priority Dispatch Report uses.
Now I want to create a Dashboard that will display Jobs that have been
released and is scheduled for a Resource or Resource Group and show in
three
different groups corresponding to the Job Operation status. I have the
BAQ
and Dashboard built that does this, and with the code from the group to
automatically open the groups, but want it Grouped in the exact order of
CURRENT at the Top, AVAILABLE in the middle and EXPECTED at the bottom.
Instead of it being AVAILABLE, CURRENT EXPECTED or visa-versa.
The plan is to then run a large display next to these Resources or
Resource
Groups (Machines or Departments) using these Dashboards so the operator
of a
Machine or the Department can easily see what the status is on all Jobs
related to that Machine or Department. Then possibly place a button on a
Dashboard where they can clock into and out of Jobs\Operations without
using
MES. Then the goal would be to try to go without needing Job Travelers.
The Dashboards make scheduling more dynamic\real time without having to
talk
directly to an operator or department, we do a lot of rearranging with
the
schedule on a day to day basis due to rush jobs.
Scott
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Jose Gomez
Sent: Tuesday, June 12, 2012 7:32 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Grouping a Dashboard
Add te grouping and sorting then right click save layout go into dev
mode
and make a small change. save
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Tue, Jun 12, 2012 at 6:05 PM, litzer1 <scott.litzau@...
<mailto:scott.litzau%40olympusgrp.com> >wrote:
> **[Non-text portions of this message have been removed]
>
>
> I would like to have a Dashboard that when it opens it Groups in a
> Specific Order and not sort Alphabetically (ascending or Descending).
> Is this possible?
>
> Scott
>
>
>
------------------------------------
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
[Non-text portions of this message have been removed]