Thanks for the suggestion on going into Crystal Reports and changing the
formula for the purchase order due date. My report writer was in
yesterday and it took her all of five minutes to change the formula. We
set all Job purchase order due dates to be 2 days prior to the date the
operation is to begin. We'll see how that goes then adjust it depending
on how it impacts our shop, etc.
From: Todd Anderson [SMTP:tanderson@...
Sent: Wednesday, October 11, 2000 9:37 AM
Subject: RE: [Vantage] Material Due Dates
About eight years ago I had the misfortune to be the IS manager
of a company
that produced textile machines using a S/38 with MAPICS for the
Actually, it wasn't all that bad. )
MAPICS off the shelf back scheduled almost exactly as you
Purchased components where scheduled to be delivered the day
usage. Our Purchasing Manager, Production Control Manager, and
a meeting one day to try to deal with the issues of late
components because it was killing us.
What we decided was:
* Even if material or components was delivered on the correct
usually could not get it received, issued, and moved to the
by the next day. ( Big facility - Big parts )
* To assume that vendors would always deliver on exactly the
was LUNACY !!!
* That the idea of delivering components the day before usage
is a "Just
In Time" trip invented by accountants in the early 80's in
response to super
high interest rates and makes NO sense.
* That for us the best offset was to have material /
to be delivered 5 working days before we needed it. Very few of
were more than 5 days late. Note that after a few months we
about extending this number to 10 days for extra cushion since
we were still
getting burned. ( I had left the company by this time and do
not know if it
was ever extended. )
* The solution for us was for me to modify the scheduling
MAPICS to automatically insert a 5 day buffer between all
components and the parent requirement date.
For Vantage I would suggest the following solution. Have
EPICOR add a
field to the "Job Management Configuration" screen ( SUM30-JC )
Company Configuration. This field should simply say
"Purchasing Buffer =
##" where ## is a number of days. The delivered default would
be ZERO - as
in schedule deliveries on the day required. Setting this to ONE
that scheduled deliveries should be buffered to be delivered ONE
parent requirement. Etc.
This would allow all Vantage customers to adjust the amount of
works for them.
For most companies the cost of having materials / components
delivered 1 to
10 days before usage is negligible in terms of carrying cost.
issues are whether you have room to store them and what your
performance is in regards to on time delivery.
If one of you wants to go to the trouble of calling something
like this in
as a suggestion let me know and I'll add my name to the list.
J. Rubin & Co.
From: Joe Konecny [mailto:jkonecn@...
Sent: Wednesday, October 11, 2000 7:31 AM
Subject: Re: [Vantage] Material Due Dates
This is a huge problem for us. The only thing you can do is
change it manually or set up an operation called "queue time"
and set it as the first op.
Steve Wirtz wrote:
> Does anyone have a solution for getting material due dates on
> orders to be the day before an operation is due to start,
> having purchasing manually change the date?
> We are having a problem with scheduling due dates for
> material due dates in Vantage are based upon the scheduled
start of the
> linked operation. It is difficult to have a work center ready
> a job when the material is due on the same day. Most
> arriving in the morning are at best received and moved to the
> early afternoon. We have tried to make everything as close to
> possible, but it makes no sense to set up work centers
> you know you have the materials needed. Many of our materials
> in the final product assembly and pack-out. Pack-out
operations for us
> are labor intensive and require setting up a line ahead of
> that is the one area we would rather have many materials
arrive on time
> or one day earlier.
> You can't do it with lead time because that doesn't affect the
> due date which remains the same.
> You can add move time to a work center but not to a material
> When we have another operation ahead of the one where the
> needed, then we changed the material to link to the earlier
> we can get an earlier purchase order due date.
> Most of the raw material that is bought specifically for a job
> for the first operation and creating a "purchase or receive
> operation should not be the only answer to an expensive
> product. Besides, that requires additional data collection
> some people that are already checking the materials and
> against the purchase order. Many of our materials do not
> detailed inspections and a specific receiving inspection
> not warranted. Requiring Purchasing physically to change
> order due date generated by Vantage seems to defeat the
purpose for a
> system that is supposed to make life easier.
-------------------------- eGroups Sponsor
We no longer allow attachments to files. To access/share Report
Files, please go to the following link:
(Note: If this link does not work for you the first time you
try it, go to www.egroups.com, login and be sure to save your password,
choose My Groups, choose Vantage, then choose Files. If you save the
password, the link above will work the next time you try it.)