Is it possible to import to Vantage from Excel
TIA
Chuck
TIA
Chuck
If you purchase the import/export utility from Epicor's Custom Programming goup. Est. Cost - $2500.
If you just want to import BOM's, you can do single level BOM's through the Advanced Bill of Material module, if you have it.
Troy Funte
Liberty Electronics
If you just want to import BOM's, you can do single level BOM's through the Advanced Bill of Material module, if you have it.
Troy Funte
Liberty Electronics
----- Original Message -----
From: chuck_metcalf@...
To: vantage@yahoogroups.com
Sent: Friday, July 13, 2001 2:15 PM
Subject: [Vantage] Vantage
Is it possible to import to Vantage from Excel
TIA
Chuck
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
You can also import directly to excel via ODBC.
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, July 13, 2001 2:24 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage
If you purchase the import/export utility from Epicor's Custom Programming
goup. Est. Cost - $2500.
If you just want to import BOM's, you can do single level BOM's through the
Advanced Bill of Material module, if you have it.
Troy Funte
Liberty Electronics
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, July 13, 2001 2:24 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage
If you purchase the import/export utility from Epicor's Custom Programming
goup. Est. Cost - $2500.
If you just want to import BOM's, you can do single level BOM's through the
Advanced Bill of Material module, if you have it.
Troy Funte
Liberty Electronics
----- Original Message -----
From: chuck_metcalf@...
To: vantage@yahoogroups.com
Sent: Friday, July 13, 2001 2:15 PM
Subject: [Vantage] Vantage
Is it possible to import to Vantage from Excel
TIA
Chuck
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>You can also import directly to excel via ODBC.I'm sure Dick is refering to reading from the database through ODBC, not
writing records to the database through ODBC, but this is a point well worth
belabouring:
if you write to the database using ODBC "ALL RELATED SUPPORT WILL BE
BILLABLE", to quote epicor. ODBC Bypasses the progress write triggers. It
is possible to import from Excel to ODBC, but you risk corrupting your
database, and having to pay through the nose for billable support. The
$2500 for the import utility may seem steep up front, but would probably be
your best bet if you need the most seamless import possible. The only
alternative is to write your own 4GL import code, which could possibly
present some billable support issues if you mess up.
Our policy is that any needs we have to write to the database will be
facilitated using Epicor software. The risks are just to great to put our
entire production database on the line for the sake of saving a few data
entry manhours.
$.02 TMJ
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, July 13, 2001 2:24 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage
If you purchase the import/export utility from Epicor's Custom Programming
goup. Est. Cost - $2500.
If you just want to import BOM's, you can do single level BOM's through the
Advanced Bill of Material module, if you have it.
Troy Funte
Liberty Electronics
----- Original Message -----
From: chuck_metcalf@...
To: vantage@yahoogroups.com
Sent: Friday, July 13, 2001 2:15 PM
Subject: [Vantage] Vantage
Is it possible to import to Vantage from Excel
TIA
Chuck
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Chuck,
I would have responded to your question when first posted, but I've
just finished the 2nd draft of a bear of a report, and just noticed
your post.
What tables would you like populated? I've written routines that
take Excel CSV and place in tables. Vantage triggers should be OK
with certain shared variables declared. The trick in Vantage would
be filling other fields not in the CSV, where correctly
creating/calculated contents is important.
An example of creating records in Vantage... I've managed to write a
program that clocks off jobs for our robot employees, fills in
quantity, time fields and others, then clocks off employee. It then
clocks the employee back in recreating the laborhed and recreates the
job labordtl. All this because Vantage doesn't support > 24 hours on
job.
Can you describe what you're trying to solve?
Lonnie Drew
lonniedrew@...
I would have responded to your question when first posted, but I've
just finished the 2nd draft of a bear of a report, and just noticed
your post.
What tables would you like populated? I've written routines that
take Excel CSV and place in tables. Vantage triggers should be OK
with certain shared variables declared. The trick in Vantage would
be filling other fields not in the CSV, where correctly
creating/calculated contents is important.
An example of creating records in Vantage... I've managed to write a
program that clocks off jobs for our robot employees, fills in
quantity, time fields and others, then clocks off employee. It then
clocks the employee back in recreating the laborhed and recreates the
job labordtl. All this because Vantage doesn't support > 24 hours on
job.
Can you describe what you're trying to solve?
Lonnie Drew
lonniedrew@...
--- In vantage@y..., chuck_metcalf@a... wrote:
> Is it possible to import to Vantage from Excel
>
> TIA
>
> Chuck
Lonnie,
This may be a bit far fetched. I would like my production control people to
be able to use a Palm device to keep notes. I would then like to be able to
upload this information into Vantage. The info I am really interested in
would be a date we input in the user field in jobhead, and memo's.
Chuck
-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Friday, July 13, 2001 2:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage
Chuck,
I would have responded to your question when first posted, but I've
just finished the 2nd draft of a bear of a report, and just noticed
your post.
What tables would you like populated? I've written routines that
take Excel CSV and place in tables. Vantage triggers should be OK
with certain shared variables declared. The trick in Vantage would
be filling other fields not in the CSV, where correctly
creating/calculated contents is important.
An example of creating records in Vantage... I've managed to write a
program that clocks off jobs for our robot employees, fills in
quantity, time fields and others, then clocks off employee. It then
clocks the employee back in recreating the laborhed and recreates the
job labordtl. All this because Vantage doesn't support > 24 hours on
job.
ld
Can you describe what you're trying to solve?
Lonnie Drew
lonniedrew@...
This may be a bit far fetched. I would like my production control people to
be able to use a Palm device to keep notes. I would then like to be able to
upload this information into Vantage. The info I am really interested in
would be a date we input in the user field in jobhead, and memo's.
Chuck
-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Friday, July 13, 2001 2:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage
Chuck,
I would have responded to your question when first posted, but I've
just finished the 2nd draft of a bear of a report, and just noticed
your post.
What tables would you like populated? I've written routines that
take Excel CSV and place in tables. Vantage triggers should be OK
with certain shared variables declared. The trick in Vantage would
be filling other fields not in the CSV, where correctly
creating/calculated contents is important.
An example of creating records in Vantage... I've managed to write a
program that clocks off jobs for our robot employees, fills in
quantity, time fields and others, then clocks off employee. It then
clocks the employee back in recreating the laborhed and recreates the
job labordtl. All this because Vantage doesn't support > 24 hours on
job.
ld
Can you describe what you're trying to solve?
Lonnie Drew
lonniedrew@...
--- In vantage@y..., chuck_metcalf@a... wrote:
> Is it possible to import to Vantage from Excel
>
> TIA
>
> Chuck
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Lonnie,
Would you please consider posting your program that handles your robot
employees on the group website?
This would be a big benefit to my company and possibly others out there.
Thanks!
Steve Sanders
Delta Centrifugal Corp
-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Friday, July 13, 2001 2:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage
Chuck,
I would have responded to your question when first posted, but I've
just finished the 2nd draft of a bear of a report, and just noticed
your post.
What tables would you like populated? I've written routines that
take Excel CSV and place in tables. Vantage triggers should be OK
with certain shared variables declared. The trick in Vantage would
be filling other fields not in the CSV, where correctly
creating/calculated contents is important.
An example of creating records in Vantage... I've managed to write a
program that clocks off jobs for our robot employees, fills in
quantity, time fields and others, then clocks off employee. It then
clocks the employee back in recreating the laborhed and recreates the
job labordtl. All this because Vantage doesn't support > 24 hours on
job.
Can you describe what you're trying to solve?
Lonnie Drew
lonniedrew@...
Would you please consider posting your program that handles your robot
employees on the group website?
This would be a big benefit to my company and possibly others out there.
Thanks!
Steve Sanders
Delta Centrifugal Corp
-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Friday, July 13, 2001 2:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage
Chuck,
I would have responded to your question when first posted, but I've
just finished the 2nd draft of a bear of a report, and just noticed
your post.
What tables would you like populated? I've written routines that
take Excel CSV and place in tables. Vantage triggers should be OK
with certain shared variables declared. The trick in Vantage would
be filling other fields not in the CSV, where correctly
creating/calculated contents is important.
An example of creating records in Vantage... I've managed to write a
program that clocks off jobs for our robot employees, fills in
quantity, time fields and others, then clocks off employee. It then
clocks the employee back in recreating the laborhed and recreates the
job labordtl. All this because Vantage doesn't support > 24 hours on
job.
Can you describe what you're trying to solve?
Lonnie Drew
lonniedrew@...
--- In vantage@y..., chuck_metcalf@a... wrote:
> Is it possible to import to Vantage from Excel
>
> TIA
>
> Chuck
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Steve,
I'll have to ask management. They've paid quite a few bucks for me
to build this and other programs that save time without Epicor custom
programming. Don't get me wrong, Epicor would do an overall better
job than I (diplomatically said, don't you think). But we've had so
many issues and user requests pop up that I've had to learn this
stuff.
Lonne
Lonnie
I'll have to ask management. They've paid quite a few bucks for me
to build this and other programs that save time without Epicor custom
programming. Don't get me wrong, Epicor would do an overall better
job than I (diplomatically said, don't you think). But we've had so
many issues and user requests pop up that I've had to learn this
stuff.
Lonne
Lonnie
--- In vantage@y..., "Steve Sanders" <ssanders@d...> wrote:
> Lonnie,
> Would you please consider posting your program that handles your
robot
> employees on the group website?
> This would be a big benefit to my company and possibly others out
there.
> Thanks!
> Steve Sanders
> Delta Centrifugal Corp
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Friday, July 13, 2001 2:54 PM
> To: vantage@y...
> Subject: [Vantage] Re: Vantage
>
>
> Chuck,
>
> I would have responded to your question when first posted, but
I've
> just finished the 2nd draft of a bear of a report, and just
noticed
> your post.
>
> What tables would you like populated? I've written routines that
> take Excel CSV and place in tables. Vantage triggers should be OK
> with certain shared variables declared. The trick in Vantage
would
> be filling other fields not in the CSV, where correctly
> creating/calculated contents is important.
>
> An example of creating records in Vantage... I've managed to
write a
> program that clocks off jobs for our robot employees, fills in
> quantity, time fields and others, then clocks off employee. It
then
> clocks the employee back in recreating the laborhed and recreates
the
> job labordtl. All this because Vantage doesn't support > 24
hours on
> job.
>
> Can you describe what you're trying to solve?
>
> Lonnie Drew
> lonniedrew@c...
>
> --- In vantage@y..., chuck_metcalf@a... wrote:
> > Is it possible to import to Vantage from Excel
> >
> > TIA
> >
> > Chuck
>
>
> To access the Files Section of our Yahoo!Group for Report Builder
and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
> linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
Chuck,
There would't be a problem is your company is not using all user
fields in JobHead, OrdeRel, or wherever user fields available. My
only concern is the format exported from the Palm.
Thad had a good point regarding the dangers of direct manipulation of
the database. You do have to be extremely careful and there are
tricks involved - the most important is using the training db over
and over until sure. I would be curious to know what other Vantage
companies have been successful directly modifying data and what they
have encountered.
Lonnie
There would't be a problem is your company is not using all user
fields in JobHead, OrdeRel, or wherever user fields available. My
only concern is the format exported from the Palm.
Thad had a good point regarding the dangers of direct manipulation of
the database. You do have to be extremely careful and there are
tricks involved - the most important is using the training db over
and over until sure. I would be curious to know what other Vantage
companies have been successful directly modifying data and what they
have encountered.
Lonnie
--- In vantage@y..., "Charles Metcalf" <chuck_metcalf@a...> wrote:
> Lonnie,
>
> This may be a bit far fetched. I would like my production control
people to
> be able to use a Palm device to keep notes. I would then like to be
able to
> upload this information into Vantage. The info I am really
interested in
> would be a date we input in the user field in jobhead, and memo's.
>
> Chuck
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Friday, July 13, 2001 2:54 PM
> To: vantage@y...
> Subject: [Vantage] Re: Vantage
>
>
> Chuck,
>
> I would have responded to your question when first posted, but I've
> just finished the 2nd draft of a bear of a report, and just noticed
> your post.
>
> What tables would you like populated? I've written routines that
> take Excel CSV and place in tables. Vantage triggers should be OK
> with certain shared variables declared. The trick in Vantage would
> be filling other fields not in the CSV, where correctly
> creating/calculated contents is important.
>
> An example of creating records in Vantage... I've managed to write a
> program that clocks off jobs for our robot employees, fills in
> quantity, time fields and others, then clocks off employee. It then
> clocks the employee back in recreating the laborhed and recreates
the
> job labordtl. All this because Vantage doesn't support > 24 hours
on
> job.
> ld
> Can you describe what you're trying to solve?
>
> Lonnie Drew
> lonniedrew@c...
>
> --- In vantage@y..., chuck_metcalf@a... wrote:
> > Is it possible to import to Vantage from Excel
> >
> > TIA
> >
> > Chuck
>
>
>
> To access the Files Section of our Yahoo!Group for Report Builder
and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
> linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Lonnie,
Tell them that many others on the group have also, but they have shared
and you will be able to benefit from that also.
Steve
-----Original Message-----
From: Lonnie Drew [SMTP:lonniedrew@...]
Sent: Friday, July 13, 2001 4:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage
Steve,
I'll have to ask management. They've paid quite a few bucks for
me
to build this and other programs that save time without Epicor
custom
programming. Don't get me wrong, Epicor would do an overall
better
job than I (diplomatically said, don't you think). But we've
had so
many issues and user requests pop up that I've had to learn this
stuff.
Lonne
Lonnie
Tell them that many others on the group have also, but they have shared
and you will be able to benefit from that also.
Steve
-----Original Message-----
From: Lonnie Drew [SMTP:lonniedrew@...]
Sent: Friday, July 13, 2001 4:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage
Steve,
I'll have to ask management. They've paid quite a few bucks for
me
to build this and other programs that save time without Epicor
custom
programming. Don't get me wrong, Epicor would do an overall
better
job than I (diplomatically said, don't you think). But we've
had so
many issues and user requests pop up that I've had to learn this
stuff.
Lonne
Lonnie
--- In vantage@y..., "Steve Sanders" <ssanders@d...> wrote:
> Lonnie,
> Would you please consider posting your program that handles
your
robot
> employees on the group website?
> This would be a big benefit to my company and possibly others
out
there.
> Thanks!
> Steve Sanders
> Delta Centrifugal Corp
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Friday, July 13, 2001 2:54 PM
> To: vantage@y...
> Subject: [Vantage] Re: Vantage
>
>
> Chuck,
>
> I would have responded to your question when first posted,
but
I've
> just finished the 2nd draft of a bear of a report, and just
noticed
> your post.
>
> What tables would you like populated? I've written routines
that
> take Excel CSV and place in tables. Vantage triggers should
be OK
> with certain shared variables declared. The trick in
Vantage
would
> be filling other fields not in the CSV, where correctly
> creating/calculated contents is important.
>
> An example of creating records in Vantage... I've managed to
write a
> program that clocks off jobs for our robot employees, fills
in
> quantity, time fields and others, then clocks off employee.
It
then
> clocks the employee back in recreating the laborhed and
recreates
the
> job labordtl. All this because Vantage doesn't support > 24
hours on
> job.
>
> Can you describe what you're trying to solve?
>
> Lonnie Drew
> lonniedrew@c...
>
> --- In vantage@y..., chuck_metcalf@a... wrote:
> > Is it possible to import to Vantage from Excel
> >
> > TIA
> >
> > Chuck
>
>
> To access the Files Section of our Yahoo!Group for Report
Builder
and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must
have
already
> linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor
To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Steve and Steve,
Tell you what I'm gonna do..
In order to bypass the question of ownership of code, or at least the
entire program, I'll export interesting portions of the program to a
text file, make notations regarding variables declared, general flow
of the program, limitations of the program, etc. I'll try to have it
today.
If anyone would like to build this or something like it, either post
to the group or contact me off list. I'll be glad to share what I've
learned using Provision.
Lonnie
lonniedrew@...
ldrew@...
Tell you what I'm gonna do..
In order to bypass the question of ownership of code, or at least the
entire program, I'll export interesting portions of the program to a
text file, make notations regarding variables declared, general flow
of the program, limitations of the program, etc. I'll try to have it
today.
If anyone would like to build this or something like it, either post
to the group or contact me off list. I'll be glad to share what I've
learned using Provision.
Lonnie
lonniedrew@...
ldrew@...
--- In vantage@y..., Steve Wirtz <SWirtz@m...> wrote:
> Lonnie,
>
> Tell them that many others on the group have also, but they have
shared
> and you will be able to benefit from that also.
>
> Steve
>
> -----Original Message-----
> From: Lonnie Drew [SMTP:lonniedrew@c...]
> Sent: Friday, July 13, 2001 4:29 PM
> To: vantage@y...
> Subject: [Vantage] Re: Vantage
>
> Steve,
>
> I'll have to ask management. They've paid quite a few bucks
for
> me
> to build this and other programs that save time without Epicor
> custom
> programming. Don't get me wrong, Epicor would do an overall
> better
> job than I (diplomatically said, don't you think). But we've
> had so
> many issues and user requests pop up that I've had to learn
this
>
> stuff.
>
> Lonne
>
> Lonnie
>
> --- In vantage@y..., "Steve Sanders" <ssanders@d...> wrote:
> > Lonnie,
> > Would you please consider posting your program that handles
> your
> robot
> > employees on the group website?
> > This would be a big benefit to my company and possibly
others
> out
> there.
> > Thanks!
> > Steve Sanders
> > Delta Centrifugal Corp
> > -----Original Message-----
> > From: Lonnie Drew [mailto:lonniedrew@c...]
> > Sent: Friday, July 13, 2001 2:54 PM
> > To: vantage@y...
> > Subject: [Vantage] Re: Vantage
> >
> >
> > Chuck,
> >
> > I would have responded to your question when first posted,
> but
> I've
> > just finished the 2nd draft of a bear of a report, and
just
> noticed
> > your post.
> >
> > What tables would you like populated? I've written
routines
> that
> > take Excel CSV and place in tables. Vantage triggers
should
> be OK
> > with certain shared variables declared. The trick in
> Vantage
> would
> > be filling other fields not in the CSV, where correctly
> > creating/calculated contents is important.
> >
> > An example of creating records in Vantage... I've managed
to
>
> write a
> > program that clocks off jobs for our robot employees,
fills
> in
> > quantity, time fields and others, then clocks off
employee.
> It
> then
> > clocks the employee back in recreating the laborhed and
> recreates
> the
> > job labordtl. All this because Vantage doesn't support >
24
>
> hours on
> > job.
> >
> > Can you describe what you're trying to solve?
> >
> > Lonnie Drew
> > lonniedrew@c...
> >
> > --- In vantage@y..., chuck_metcalf@a... wrote:
> > > Is it possible to import to Vantage from Excel
> > >
> > > TIA
> > >
> > > Chuck
> >
> >
> > To access the Files Section of our Yahoo!Group for Report
> Builder
> and
> > Crystal Reports and other 'goodies', please go to:
> > http://groups.yahoo.com/group/vantage/files/. Note: You
must
> have
> already
> > linked your email address to a yahoo id to enable access.
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms
of
> Service.
> >
> >
> >
> > [Non-text portions of this message have been removed]
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
> already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
Has anyone who uses MRP and makes direct to order, figured out a way
to have MRP take inventory into consideration, rather than building a
job.
to have MRP take inventory into consideration, rather than building a
job.
We are a job shop with repeat business. Each of our jobs will
generate more parts than on order. We put these parts into stock. We
make to order, and we also run MRP. My problem is, how do I set up so
that MRP will check inventory when it calculates what I need to make.
Any help or insight would be greatly appreciated.
TIA
Chuck
generate more parts than on order. We put these parts into stock. We
make to order, and we also run MRP. My problem is, how do I set up so
that MRP will check inventory when it calculates what I need to make.
Any help or insight would be greatly appreciated.
TIA
Chuck
We bought MRP last fall, haven't implemented yet (various reasons), but when
I was talking with Epicor support they told me we couldn't mix order types.
If we wanted to use existing inventory we should make to stock and ship from
stock. In those instances where we want to only make enough for the Sales
Order we keep the minimum and lot quantities at zero.
Warren R. Eddy
Information Services Manager
National Tube Form, LLC
Phone: (219) 478-2363 ext 217
Fax: (219) 478-1043
Warren.Eddy@...
-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Wednesday, July 25, 2001 1:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage
We are a job shop with repeat business. Each of our jobs will
generate more parts than on order. We put these parts into stock. We
make to order, and we also run MRP. My problem is, how do I set up so
that MRP will check inventory when it calculates what I need to make.
Any help or insight would be greatly appreciated.
TIA
Chuck
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
I was talking with Epicor support they told me we couldn't mix order types.
If we wanted to use existing inventory we should make to stock and ship from
stock. In those instances where we want to only make enough for the Sales
Order we keep the minimum and lot quantities at zero.
Warren R. Eddy
Information Services Manager
National Tube Form, LLC
Phone: (219) 478-2363 ext 217
Fax: (219) 478-1043
Warren.Eddy@...
-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Wednesday, July 25, 2001 1:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage
We are a job shop with repeat business. Each of our jobs will
generate more parts than on order. We put these parts into stock. We
make to order, and we also run MRP. My problem is, how do I set up so
that MRP will check inventory when it calculates what I need to make.
Any help or insight would be greatly appreciated.
TIA
Chuck
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Try making to stock not to order. Pick one part or one customer and use to
test. You will find trade offs. Like you can't go from Order Tracker to Job
Tracker, you will have to go to Part Tracker, TimePhase, then job tracker
but you may like this better. Works for us.
Patrick
-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Wednesday, July 25, 2001 1:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage
We are a job shop with repeat business. Each of our jobs will
generate more parts than on order. We put these parts into stock. We
make to order, and we also run MRP. My problem is, how do I set up so
that MRP will check inventory when it calculates what I need to make.
Any help or insight would be greatly appreciated.
TIA
Chuck
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
test. You will find trade offs. Like you can't go from Order Tracker to Job
Tracker, you will have to go to Part Tracker, TimePhase, then job tracker
but you may like this better. Works for us.
Patrick
-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Wednesday, July 25, 2001 1:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage
We are a job shop with repeat business. Each of our jobs will
generate more parts than on order. We put these parts into stock. We
make to order, and we also run MRP. My problem is, how do I set up so
that MRP will check inventory when it calculates what I need to make.
Any help or insight would be greatly appreciated.
TIA
Chuck
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Where is the PrimBin located. I thought it was in PartWhse, but when
I look at it now it is Obsolete-PrimBin.
Thanks
Chuck
I look at it now it is Obsolete-PrimBin.
Thanks
Chuck
I don't know if this is what you are looking for... but in 5.0 Part.PrimWhse has been moved to a new table called PartPlant.PrimWhse.
A bunch of fields in the Part Table were moved to the PartPlant table to accomodate using various "Plants" in Vantage.
Troy Funte
Liberty Electronics
A bunch of fields in the Part Table were moved to the PartPlant table to accomodate using various "Plants" in Vantage.
Troy Funte
Liberty Electronics
----- Original Message -----
From: chuck_metcalf@...
To: vantage@yahoogroups.com
Sent: Thursday, July 26, 2001 12:54 PM
Subject: [Vantage] Vantage
Where is the PrimBin located. I thought it was in PartWhse, but when
I look at it now it is Obsolete-PrimBin.
Thanks
Chuck
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Look in PartPlant. Have fun changing all your reports (if you are upgrading for 3.0).
Alex Neutgens
Controller
Circuit Check, Inc.
Phone 763-694-4110
Fax 763-694-4151
-----Original Message-----
From: chuck_metcalf@... [SMTP:chuck_metcalf@...]
Sent: Thursday, July 26, 2001 11:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage
<< File: ATT00018.htm >>
Alex Neutgens
Controller
Circuit Check, Inc.
Phone 763-694-4110
Fax 763-694-4151
-----Original Message-----
From: chuck_metcalf@... [SMTP:chuck_metcalf@...]
Sent: Thursday, July 26, 2001 11:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage
<< File: ATT00018.htm >>
Does anyone print a picture of the part on the work order or on the
shipper. Any guidance would be appreciated.
Chuck
shipper. Any guidance would be appreciated.
Chuck
Chuck,
We print a digital picture of the part on our Job Traveler. I have
an Access DB setup to hold the part # and corresponding picture.
That picture was added to Vantage's existing Job Traveler with a
subreport. If you need some more info e-mail me @
bstenglein@....
Brian Stenglein
Clow Stamping Company
We print a digital picture of the part on our Job Traveler. I have
an Access DB setup to hold the part # and corresponding picture.
That picture was added to Vantage's existing Job Traveler with a
subreport. If you need some more info e-mail me @
bstenglein@....
Brian Stenglein
Clow Stamping Company
--- In vantage@y..., chuck_metcalf@a... wrote:
> Does anyone print a picture of the part on the work order or on the
> shipper. Any guidance would be appreciated.
> Chuck