Adam,
We run 8.03.305, and I use ServiceConnect to get at the timephase
webservice. Using this you can extract the whole time phase data for
all parts and then do what ever you like with the data. I now have a
whole bunch of reports that I just couldn't do directly in Vantage.
I am not even sure if S/C was available for 6.1, but if you have
access to it, its really, really useful.
Thanks,
Nick
We run 8.03.305, and I use ServiceConnect to get at the timephase
webservice. Using this you can extract the whole time phase data for
all parts and then do what ever you like with the data. I now have a
whole bunch of reports that I just couldn't do directly in Vantage.
I am not even sure if S/C was available for 6.1, but if you have
access to it, its really, really useful.
Thanks,
Nick
--- In vantage@yahoogroups.com, "adam.whipp" <adam.whipp@...> wrote:
>
> DUH! The partdtl table -- how did I forget about that. That is the
> missing link. I think I was trying to greatly over-complicate this
> report. Well, at least it kept me busy all day! Thank you very
much
> for the input.
>
> Adam Whipp
>
> --- In vantage@yahoogroups.com, "Jim Frice" <Jim.Frice@> wrote:
> >
> > Adam,
> > It can be done but does take some manipulation. You need the
PartDtl
> > table to be able to break down the receipts and requirements.
You
> then
> > need to create some calculated fields to give you quantity for
each
> > SourceFile. Then do your aggregate calcs to get the totals. When
we
> > created ours we did a grouping on the part number. We didn't show
> the
> > details for all the demands. We used part class as a filter an
> would run
> > it for the particular class we were interested in.
> >
> > Jim
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of adam.whipp
> > Sent: Thursday, November 20, 2008 2:52 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] V6.1 Time Phased Material Requirements Re-
> Creation
> >
> >
> >
> > Hello,
> > We are on Vantage 6.1. Has anyone tried to re-create the time
> phased
> > materials requirements report for finished goods? We wanted some
> > changes made to the stock report; I know this is a Progress
report,
> so
> > it cannot be modified, but I am having trouble re-creating it as
> well.
> > I don't see a way to use report builder to create the column
> > titled "source" because this one column is pulling from two
> different
> > tables (sales orders and jobs). It seems that no matter how the
> data
> > is grouped or sorted, there will duplicates of the jobs or
> duplicates
> > of the sales orders. I know a SQL union would work, but I don't
> > believe report builder has a way to do a SQL union. Does anyone
> know
> > what Progress is doing behind the scenes to calculate this
column?
> I
> > think either I am missing someting obvious or the IMR60.r file
for
> this
> > report is working magic. If anyone has any tips or tricks, it
would
> be
> > much appreciated. Thanks!
> >
> > Adam Whipp
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>