Creating an accurate Time Phased Material Report

Thanks Rob. I will look into some more material regarding SQL!

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> Like I said, our IT group did the magic - using perhaps a DTS package to bring the data over from Vantage into our SQL table in 4 or 5 multitable queries into Vantage.
>
> SQL is worth learning (and simple - you'll quickly get results).
>
> Just take off your OOP programming thinking cap!
> /:o
> Rob
>
> --- Original Message ---
> From:"asrayon" <asrayon@...>
> Sent:Thu 7/1/10 10:40 am
> To:vantage@yahoogroups.com
> Subj:[Vantage] Re: Creating an accurate Time Phased Material Report
>
> Robert, that sounds like a pretty simple way of doing things. I actually prefer excel rather than have everything performed in Vantage. I however am not familiar with SQL programming and do not have the first clue about how to create these tables. I looked at some material online regarding SQL and it seems similar to C+. I am just not sure where and how these tables are created in respect to Vantage. Is there another program necessary to create these tables?
>
> Thank you,
>
> Adolfo
>
> --- In vantage@yahoogroups.com, robertb_versa@ wrote:
> >
> > 'Cheat' and do it in excel. Our IT group did a beautiful thing & created a nightly data extract process to create our own SQL table of all O/H, supply jobs & POs and all Order & job requirements.
> >
> > It also contains other info pertinent to us.
> >
> > The snapshot SQL table is then read into excel & orders/jobs w/ part shortages are ID'ed (and can be viewed by various criteria - like on time impact or shipment $ delay impact, etc.,).
> >
> > We had this developed on our legacy system but Progress 8.03.4xx cringes at big direct SQL queries. I tried multiple BAQ exports but that overwhelmed excel (too many massive vlookup arrays).
> >
> > It's not 'live' - but it works.
> >
> > Rob
> >
> > --- Original Message ---
> > From:"Rob Bucek" <rbucek@>
> > Sent:Wed 6/30/10 1:02 pm
> > To:<vantage@yahoogroups.com>
> > Subj:RE: [Vantage] Re: Creating an accurate Time Phased Material Report
> >
> > Or better yet the job is scheduled 'late', past the customer required
> > date. How do others deal with that, especially when you are finitely
> > scheduling.
> >
> >
> >
> > Rob Bucek
> >
> > Manufacturing Engineer
> >
> > PH: (715) 284-5376 ext 311
> >
> > Mobile: (715)896-0590
> >
> > FAX: (715)284-4084
> >
> > <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 asrayon
> > Sent: Wednesday, June 30, 2010 11:41 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Creating an accurate Time Phased Material Report
> >
> >
> >
> >
> >
> > Thank you for your response, Gary.
> >
> > I am noticing that the scheduler affects the Time Phased Material
> > Requirements (TPMR) directly. The problem is that one person runs the
> > scheduler and one person purchases material using the TPMR. If the
> > person in charge of the scheduler runs the scheduler, then the parts
> > that have not been released to the floor yet will move around and dates
> > will change. Yesterday I saw that an order that was placed by one of our
> > customers for August parts said that the material should be ordered
> > yesterday June 29th. However, the order will be "out of the month"
> > financially and does not need to be ordered until sometime in July. I am
> > not sure if there is a way to fix these types of things... How do you
> > work around your scheduler?
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "ajrgcw117" <ajrgary@> wrote:
> > >
> > > I am curren
>
Hello everyone,

I have been put in charge of ensuring that the time phase material report for my company is accurate. Also, ensuring that the scheduling portion of Vantage is accurate as well. Has anyone else dealt with a similar situation?

We do have some constraints when it comes to scheduling. i.e. some of our customers have a higher priority than others and therefore these jobs will push lower priority jobs back further in to the schedule.

Basically, we are looking to have material on time when needed and have an accurate inventory level while also having an accurate scheduler.

Thank you
I am currently using this report every day. It gives me enough time to keep the inventory levels where they need to be. It also looks into future jobs as they are entered in the system. If the part requirements are in your MOM then once the new job is entered the part requirements shows up in the time phased report. it all depends on how well the jobs are scheduled. our job shippment dates change all the time and it gives me enough lead time to place the orders.

Gary

--- In vantage@yahoogroups.com, "asrayon" <asrayon@...> wrote:
>
> Hello everyone,
>
> I have been put in charge of ensuring that the time phase material report for my company is accurate. Also, ensuring that the scheduling portion of Vantage is accurate as well. Has anyone else dealt with a similar situation?
>
> We do have some constraints when it comes to scheduling. i.e. some of our customers have a higher priority than others and therefore these jobs will push lower priority jobs back further in to the schedule.
>
> Basically, we are looking to have material on time when needed and have an accurate inventory level while also having an accurate scheduler.
>
> Thank you
>
Thank you for your response, Gary.

I am noticing that the scheduler affects the Time Phased Material Requirements (TPMR) directly. The problem is that one person runs the scheduler and one person purchases material using the TPMR. If the person in charge of the scheduler runs the scheduler, then the parts that have not been released to the floor yet will move around and dates will change. Yesterday I saw that an order that was placed by one of our customers for August parts said that the material should be ordered yesterday June 29th. However, the order will be "out of the month" financially and does not need to be ordered until sometime in July. I am not sure if there is a way to fix these types of things... How do you work around your scheduler?

--- In vantage@yahoogroups.com, "ajrgcw117" <ajrgary@...> wrote:
>
> I am currently using this report every day. It gives me enough time to keep the inventory levels where they need to be. It also looks into future jobs as they are entered in the system. If the part requirements are in your MOM then once the new job is entered the part requirements shows up in the time phased report. it all depends on how well the jobs are scheduled. our job shippment dates change all the time and it gives me enough lead time to place the orders.
>
> Gary
>
> --- In vantage@yahoogroups.com, "asrayon" <asrayon@> wrote:
> >
> > Hello everyone,
> >
> > I have been put in charge of ensuring that the time phase material report for my company is accurate. Also, ensuring that the scheduling portion of Vantage is accurate as well. Has anyone else dealt with a similar situation?
> >
> > We do have some constraints when it comes to scheduling. i.e. some of our customers have a higher priority than others and therefore these jobs will push lower priority jobs back further in to the schedule.
> >
> > Basically, we are looking to have material on time when needed and have an accurate inventory level while also having an accurate scheduler.
> >
> > Thank you
> >
>
Or better yet the job is scheduled 'late', past the customer required
date. How do others deal with that, especially when you are finitely
scheduling.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<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 asrayon
Sent: Wednesday, June 30, 2010 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Creating an accurate Time Phased Material Report





Thank you for your response, Gary.

I am noticing that the scheduler affects the Time Phased Material
Requirements (TPMR) directly. The problem is that one person runs the
scheduler and one person purchases material using the TPMR. If the
person in charge of the scheduler runs the scheduler, then the parts
that have not been released to the floor yet will move around and dates
will change. Yesterday I saw that an order that was placed by one of our
customers for August parts said that the material should be ordered
yesterday June 29th. However, the order will be "out of the month"
financially and does not need to be ordered until sometime in July. I am
not sure if there is a way to fix these types of things... How do you
work around your scheduler?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"ajrgcw117" <ajrgary@...> wrote:
>
> I am currently using this report every day. It gives me enough time to
keep the inventory levels where they need to be. It also looks into
future jobs as they are entered in the system. If the part requirements
are in your MOM then once the new job is entered the part requirements
shows up in the time phased report. it all depends on how well the jobs
are scheduled. our job shippment dates change all the time and it gives
me enough lead time to place the orders.
>
> Gary
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"asrayon" <asrayon@> wrote:
> >
> > Hello everyone,
> >
> > I have been put in charge of ensuring that the time phase material
report for my company is accurate. Also, ensuring that the scheduling
portion of Vantage is accurate as well. Has anyone else dealt with a
similar situation?
> >
> > We do have some constraints when it comes to scheduling. i.e. some
of our customers have a higher priority than others and therefore these
jobs will push lower priority jobs back further in to the schedule.
> >
> > Basically, we are looking to have material on time when needed and
have an accurate inventory level while also having an accurate
scheduler.
> >
> > Thank you
> >
>





[Non-text portions of this message have been removed]
'Cheat' and do it in excel. Our IT group did a beautiful thing & created a nightly data extract process to create our own SQL table of all O/H, supply jobs & POs and all Order & job requirements.

It also contains other info pertinent to us.

The snapshot SQL table is then read into excel & orders/jobs w/ part shortages are ID'ed (and can be viewed by various criteria - like on time impact or shipment $ delay impact, etc.,).

We had this developed on our legacy system but Progress 8.03.4xx cringes at big direct SQL queries. I tried multiple BAQ exports but that overwhelmed excel (too many massive vlookup arrays).

It's not 'live' - but it works.

Rob

--- Original Message ---
From:"Rob Bucek" <rbucek@...>
Sent:Wed 6/30/10 1:02 pm
To:<vantage@yahoogroups.com>
Subj:RE: [Vantage] Re: Creating an accurate Time Phased Material Report

Or better yet the job is scheduled 'late', past the customer required
date. How do others deal with that, especially when you are finitely
scheduling.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<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 asrayon
Sent: Wednesday, June 30, 2010 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Creating an accurate Time Phased Material Report





Thank you for your response, Gary.

I am noticing that the scheduler affects the Time Phased Material
Requirements (TPMR) directly. The problem is that one person runs the
scheduler and one person purchases material using the TPMR. If the
person in charge of the scheduler runs the scheduler, then the parts
that have not been released to the floor yet will move around and dates
will change. Yesterday I saw that an order that was placed by one of our
customers for August parts said that the material should be ordered
yesterday June 29th. However, the order will be "out of the month"
financially and does not need to be ordered until sometime in July. I am
not sure if there is a way to fix these types of things... How do you
work around your scheduler?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"ajrgcw117" <ajrgary@...> wrote:
>
> I am currently using this report every day. It gives me enough time to
keep the inventory levels where they need to be. It also looks into
future jobs as they are entered in the system. If the part requirements
are in your MOM then once the new job is entered the part requirements
shows up in the time phased report. it all depends on how well the jobs
are scheduled. our job shippment dates change all the time and it gives
me enough lead time to place the orders.
>
> Gary
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"asrayon" <asrayon@> wrote:
> >
> > Hello everyone,
> >
> > I have been put in charge of ensuring that the time phase material
report for my company is accurate. Also, ensuring that the scheduling
portion of Vantage is accurate as well. Has anyone else dealt with a
similar situation?
> >
> > We do have some constraints when it comes to scheduling. i.e. some
of our customers have a higher priority than others and therefore these
jobs will push lower priority jobs back further in to the schedule.
> >
> > Basically, we are looking to have material on time when needed and
have an accurate inventory level while also having an accurate
scheduler.
> >
> > Thank you
> >
>





[Non-text portions of this message have been removed]
Robert, that sounds like a pretty simple way of doing things. I actually prefer excel rather than have everything performed in Vantage. I however am not familiar with SQL programming and do not have the first clue about how to create these tables. I looked at some material online regarding SQL and it seems similar to C+. I am just not sure where and how these tables are created in respect to Vantage. Is there another program necessary to create these tables?

Thank you,

Adolfo

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> 'Cheat' and do it in excel. Our IT group did a beautiful thing & created a nightly data extract process to create our own SQL table of all O/H, supply jobs & POs and all Order & job requirements.
>
> It also contains other info pertinent to us.
>
> The snapshot SQL table is then read into excel & orders/jobs w/ part shortages are ID'ed (and can be viewed by various criteria - like on time impact or shipment $ delay impact, etc.,).
>
> We had this developed on our legacy system but Progress 8.03.4xx cringes at big direct SQL queries. I tried multiple BAQ exports but that overwhelmed excel (too many massive vlookup arrays).
>
> It's not 'live' - but it works.
>
> Rob
>
> --- Original Message ---
> From:"Rob Bucek" <rbucek@...>
> Sent:Wed 6/30/10 1:02 pm
> To:<vantage@yahoogroups.com>
> Subj:RE: [Vantage] Re: Creating an accurate Time Phased Material Report
>
> Or better yet the job is scheduled 'late', past the customer required
> date. How do others deal with that, especially when you are finitely
> scheduling.
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <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 asrayon
> Sent: Wednesday, June 30, 2010 11:41 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Creating an accurate Time Phased Material Report
>
>
>
>
>
> Thank you for your response, Gary.
>
> I am noticing that the scheduler affects the Time Phased Material
> Requirements (TPMR) directly. The problem is that one person runs the
> scheduler and one person purchases material using the TPMR. If the
> person in charge of the scheduler runs the scheduler, then the parts
> that have not been released to the floor yet will move around and dates
> will change. Yesterday I saw that an order that was placed by one of our
> customers for August parts said that the material should be ordered
> yesterday June 29th. However, the order will be "out of the month"
> financially and does not need to be ordered until sometime in July. I am
> not sure if there is a way to fix these types of things... How do you
> work around your scheduler?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "ajrgcw117" <ajrgary@> wrote:
> >
> > I am currently using this report every day. It gives me enough time to
> keep the inventory levels where they need to be. It also looks into
> future jobs as they are entered in the system. If the part requirements
> are in your MOM then once the new job is entered the part requirements
> shows up in the time phased report. it all depends on how well the jobs
> are scheduled. our job shippment dates change all the time and it gives
> me enough lead time to place the orders.
> >
> > Gary
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "asrayon" <asrayon@> wrote:
> > >
> > > Hello everyone,
> > >
> > > I have been put in charge of ensuring that the time phase material
> report for my company is accurate. Also, ensuring that the scheduling
> portion of Vantage is accurate as well. Has anyone else dealt with a
> similar situation?
> > >
> > > We do have some constraints when it comes to scheduling. i.e. some
> of our customers have a higher priority than others and therefore these
> jobs will push lower priority jobs back further in to the schedule.
> > >
> > > Basically, we are looking to have material on time when needed and
> have an accurate inventory level while also having an accurate
> scheduler.
> > >
> > > Thank you
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Like I said, our IT group did the magic - using perhaps a DTS package to bring the data over from Vantage into our SQL table in 4 or 5 multitable queries into Vantage.

SQL is worth learning (and simple - you'll quickly get results).

Just take off your OOP programming thinking cap!
/:o
Rob

--- Original Message ---
From:"asrayon" <asrayon@...>
Sent:Thu 7/1/10 10:40 am
To:vantage@yahoogroups.com
Subj:[Vantage] Re: Creating an accurate Time Phased Material Report

Robert, that sounds like a pretty simple way of doing things. I actually prefer excel rather than have everything performed in Vantage. I however am not familiar with SQL programming and do not have the first clue about how to create these tables. I looked at some material online regarding SQL and it seems similar to C+. I am just not sure where and how these tables are created in respect to Vantage. Is there another program necessary to create these tables?

Thank you,

Adolfo

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> 'Cheat' and do it in excel. Our IT group did a beautiful thing & created a nightly data extract process to create our own SQL table of all O/H, supply jobs & POs and all Order & job requirements.
>
> It also contains other info pertinent to us.
>
> The snapshot SQL table is then read into excel & orders/jobs w/ part shortages are ID'ed (and can be viewed by various criteria - like on time impact or shipment $ delay impact, etc.,).
>
> We had this developed on our legacy system but Progress 8.03.4xx cringes at big direct SQL queries. I tried multiple BAQ exports but that overwhelmed excel (too many massive vlookup arrays).
>
> It's not 'live' - but it works.
>
> Rob
>
> --- Original Message ---
> From:"Rob Bucek" <rbucek@...>
> Sent:Wed 6/30/10 1:02 pm
> To:<vantage@yahoogroups.com>
> Subj:RE: [Vantage] Re: Creating an accurate Time Phased Material Report
>
> Or better yet the job is scheduled 'late', past the customer required
> date. How do others deal with that, especially when you are finitely
> scheduling.
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <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 asrayon
> Sent: Wednesday, June 30, 2010 11:41 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Creating an accurate Time Phased Material Report
>
>
>
>
>
> Thank you for your response, Gary.
>
> I am noticing that the scheduler affects the Time Phased Material
> Requirements (TPMR) directly. The problem is that one person runs the
> scheduler and one person purchases material using the TPMR. If the
> person in charge of the scheduler runs the scheduler, then the parts
> that have not been released to the floor yet will move around and dates
> will change. Yesterday I saw that an order that was placed by one of our
> customers for August parts said that the material should be ordered
> yesterday June 29th. However, the order will be "out of the month"
> financially and does not need to be ordered until sometime in July. I am
> not sure if there is a way to fix these types of things... How do you
> work around your scheduler?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "ajrgcw117" <ajrgary@> wrote:
> >
> > I am curren