Forecasting Future Demand Report

Yahoo Archive
1
Careful using PartDtl as I recall it is distorted by any Min O/H or Safeties set for parts.

--- Original Message ---
From:"adam.whipp" <adam.whipp@...>
Sent:Thu 7/1/10 9:56 am
To:vantage@yahoogroups.com
Subj:[Vantage] Re: Forecasting Future Demand Report

You'll want to start with the PartDtl table -- this holds all of the supply / demand records for each part. There is a field for the type of record and then you have to calculate whether that would be a negative or a positive (supply or demand) as all of the the quantities are stored as positive in the database. Hope that helps!

Adam Whipp

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> I am in the process of constructing a report to show the forward future demand of parts.
>
> To summarise, I need a report similar to the info that is displayed in the Time Phase Inquiry. I know there is a Time Phased Material Req'ments report, however, this is constructed in plain text and cannot be modified.
>
> Has anyone constructed a similar report? Which table does the due date on the time phase live in?
>
> Any help would be greatly appreciated.
>
> Regards,
>
> Michael
>
> Vantage 8.03.406
>
2
Hello,

I am in the process of constructing a report to show the forward future demand of parts.

To summarise, I need a report similar to the info that is displayed in the Time Phase Inquiry. I know there is a Time Phased Material Req'ments report, however, this is constructed in plain text and cannot be modified.

Has anyone constructed a similar report? Which table does the due date on the time phase live in?

Any help would be greatly appreciated.

Regards,

Michael

Vantage 8.03.406
3
You'll want to start with the PartDtl table -- this holds all of the supply / demand records for each part. There is a field for the type of record and then you have to calculate whether that would be a negative or a positive (supply or demand) as all of the the quantities are stored as positive in the database. Hope that helps!

Adam Whipp

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> I am in the process of constructing a report to show the forward future demand of parts.
>
> To summarise, I need a report similar to the info that is displayed in the Time Phase Inquiry. I know there is a Time Phased Material Req'ments report, however, this is constructed in plain text and cannot be modified.
>
> Has anyone constructed a similar report? Which table does the due date on the time phase live in?
>
> Any help would be greatly appreciated.
>
> Regards,
>
> Michael
>
> Vantage 8.03.406
>
4
Thanks for this. I'm kind of getting there. It's just something to replace the Time Phased Material report as this isn't Epicor's best piece of work!!

Michael

--- In vantage@yahoogroups.com, "adam.whipp" <adam.whipp@...> wrote:
>
> You'll want to start with the PartDtl table -- this holds all of the supply / demand records for each part. There is a field for the type of record and then you have to calculate whether that would be a negative or a positive (supply or demand) as all of the the quantities are stored as positive in the database. Hope that helps!
>
> Adam Whipp
>
> --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hello,
> >
> > I am in the process of constructing a report to show the forward future demand of parts.
> >
> > To summarise, I need a report similar to the info that is displayed in the Time Phase Inquiry. I know there is a Time Phased Material Req'ments report, however, this is constructed in plain text and cannot be modified.
> >
> > Has anyone constructed a similar report? Which table does the due date on the time phase live in?
> >
> > Any help would be greatly appreciated.
> >
> > Regards,
> >
> > Michael
> >
> > Vantage 8.03.406
> >
>
5
It's an on the fly Progress app that constucts a temp table (which I believe is called TimePhas or something like that.

Nothing permanently in there to read dynamically.

--- Original Message ---
From:"michael.hutcheson@..." <michael.hutcheson@...>
Sent:Thu 7/1/10 5:04 am
To:vantage@yahoogroups.com
Subj:[Vantage] Forecasting Future Demand Report

Hello,

I am in the process of constructing a report to show the forward future demand of parts.

To summarise, I need a report similar to the info that is displayed in the Time Phase Inquiry. I know there is a Time Phased Material Req'ments report, however, this is constructed in plain text and cannot be modified.

Has anyone constructed a similar report? Which table does the due date on the time phase live in?

Any help would be greatly appreciated.

Regards,

Michael

Vantage 8.03.406