If you could post it or send it my way, I would like to take a look at it.
Thank you
Jeff
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W, Spolarich
Sent: Friday, January 30, 2009 5:35 PM
To: vantage
Subject: Re: [Vantage] Re: Priority Dispatch Report
I have a BAQ and Report that shows basically what¹s available to be worked
in in WIP per area sorted based on Sales Order due date showing stuff that¹s
coming due or overdue first. Our techs use it to figure out ³what I need to
work on first² and its a lot easier to deal with than the stock Priority
Dispatch report.
I can send it/post it if you¹d like.
-bws
On 1/30/09 2:17 PM, "Lynn" <lynn.khalife@...
<mailto:lynn.khalife%40core-mfg.com> > wrote:
[Non-text portions of this message have been removed]
Thank you
Jeff
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W, Spolarich
Sent: Friday, January 30, 2009 5:35 PM
To: vantage
Subject: Re: [Vantage] Re: Priority Dispatch Report
I have a BAQ and Report that shows basically what¹s available to be worked
in in WIP per area sorted based on Sales Order due date showing stuff that¹s
coming due or overdue first. Our techs use it to figure out ³what I need to
work on first² and its a lot easier to deal with than the stock Priority
Dispatch report.
I can send it/post it if you¹d like.
-bws
On 1/30/09 2:17 PM, "Lynn" <lynn.khalife@...
<mailto:lynn.khalife%40core-mfg.com> > wrote:
><mailto:vantage%40yahoogroups.com> , "Jeff
>
>
> You won't be able to "re-create" the report unless you decide to
> start completely from scratch and build your own BAQ and write a BAQ
> report.
>
> The Priority Dispatch Report is not based on any actual database
> table. It is based on a (temporary) view called JCR65. No one knows
> how the Epicor developers arrive at this view.
>
> This is what you should do:
>
> You can basically know what is in the view by going to the Report
> Data Definitions for PrioDisp. Use the Duplicate Report command in
> the Actions menu to Copy the PrioDisp to a new name. Then click on
> the JCR65 table and then click on the "Excluded Fields" tab. Add any
> additional fields that you want.
>
> Then decide what table (from the Data Dictionary) to get your desired
> field from. Add that table to your PrioDis2 data definition then
> select your desired field(s).
>
> Then, add a New Relationship between the JCR65 and your new table.
> Here's the other part people have trouble with: The drop-downs don't
> seem to work for this data definition. All you need to do to
> overcome this problem is simply to manually type your desired table
> and field names. This will work.
>
> When your linking is properly completed, everything else will work
> just as it normally does when you modify Epicor-provided Crystal
> Reports.
>
> Lynn
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Stockard" <jeff.stockard@...>[Non-text portions of this message have been removed]
> wrote:
>> >
>> > Does anyone know where the Priority Dispatch Report gets the data
> from. My
>> > scheduling agent wants the Job Due date on the Priority Dispatch
> Report but
>> > I don't know how to add this to the Crystal report without re-
> creating the
>> > entire report. Is there an easier way to do this?
>> >
>> > Thank you
>> >
>> > Jeff
>> >
>> >
>> >
>> > [Non-text portions of this message have been removed]
>> >
>
>
>
[Non-text portions of this message have been removed]