Crystal Invoices

Yahoo Archive
1
We use this same configuration in our system.

MFGODBCServer=(Your ODBC connection name)
MFGODBCDbse=Vantage Server Name
MFGODBCUser=(ODBC UserName)
MFGODBCpasswd=(ODBC pwd)
This is at the end of the Vantage.mfg file (location is V:\mfgsys61\)
Note: We have to re-edit this file every time we add a user.

Mitch Appleby
IS Admin
Dubuque Stamping & Mfg
___________________________________________________
--- In vantage@yahoogroups.com, "Frances Skidmore" <Frances@...> wrote:
>
> OK, I don't have a Vantage.vtg file. Should I create one? where
should
> it be located?
> I do have a mfgsys.ini in my mfgsys61 directory.
> Thanks
> Frances Skidmore
> Entek Corporation
> Phone: 405-364-5588
> FAX: 405-364-4727
> Email: Frances@... <mailto:Frances@...
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of David Gartner
> Sent: Thursday, February 28, 2008 11:53 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Crystal Invoices
>
>
>
> To all those who helped me over the years including this solution,
>
> You need to add these lines to your Vantage.vtg file.
>
> VantageODBCServer=(Your ODBC connection name)
> VantageODBCDbse=(Vantage Server Name)
> VantageODBCUser=(ODBC UserName)
> VantageODBCpasswd=(ODBC pwd)
>
> Since it works when previewing in Crystal, those are the values
needed.
>
> David Gartner
> EPG Companies Inc.
>
>
>
> _____
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]
On
> Behalf Of
> Frances Skidmore
> Sent: Thursday, February 28, 2008 10:51 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Crystal Invoices
>
> Vantage 6.10.504
> Crystal 8.5.3.975
>
> I had to add some user data from the part master to my Crystal invoice
> form using ODBC. I can print the form without error from within
> Crystal. It prompts me for the ODBC user id when I print or preview
the
> invoice. No errors.
>
> When I try to print from Vantage, I never get a prompt for user id -
> just error 599. How do I fix this??
>
> Frances Skidmore
> Entek Corporation
> Phone: 405-364-5588
> FAX: 405-364-4727
> Email: Frances@entek. <mailto:Frances%40entek.net> net
> <mailto:Frances@entek. <mailto:Frances%40entek.net> net>
>
> <http://geo.yahoo
>
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
>
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
> > >
> com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
> Id=62953/stime=1204216581/nc1=4507179/nc2=3848642/nc3=4836044>
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
2
Here is the semi-urgent situation:

We produce, in this circumstance, aluminum frames for towable RVs.
This market means that 90% of our items are made to order. From the
information I have, Sales Kits do not seem to want to work with non-
stock items.

We have sales kits setup for customer units. These kits include all
of the walls and roof for unit XYZ. The BOM for unit XYZ contains
parts ABC1, ABC2, ABC3... Each of which have their own
materials/operations.

Currently, XYZ is set up as a Manufactured item. This creates
jobs/travelers for production. However, when it gets to shipping
they see to ship XYZ, without having any knowledge if which parts
make up XYZ.


Any recommendation to maintain the customer ordering a single part,
with shipping seeing the individual parts is so greatly appreciated.
This has already begun affecting our customer service.


Adam Long
3
You should run your sales order picklist. It will list all of the components for that sales order that are part of the kit

Adam Long <xcsdm@...> wrote: Here is the semi-urgent situation:

We produce, in this circumstance, aluminum frames for towable RVs.
This market means that 90% of our items are made to order. From the
information I have, Sales Kits do not seem to want to work with non-
stock items.

We have sales kits setup for customer units. These kits include all
of the walls and roof for unit XYZ. The BOM for unit XYZ contains
parts ABC1, ABC2, ABC3... Each of which have their own
materials/operations.

Currently, XYZ is set up as a Manufactured item. This creates
jobs/travelers for production. However, when it gets to shipping
they see to ship XYZ, without having any knowledge if which parts
make up XYZ.

Any recommendation to maintain the customer ordering a single part,
with shipping seeing the individual parts is so greatly appreciated.
This has already begun affecting our customer service.

Adam Long






---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

[Non-text portions of this message have been removed]
4
From what I can tell, this only works correctly if the components of
the kit are stock parts.

Adam Long

--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> You should run your sales order picklist. It will list all of the
components for that sales order that are part of the kit
>
> Adam Long <xcsdm@...> wrote: Here is the semi-urgent situation:
>
> We produce, in this circumstance, aluminum frames for towable RVs.
> This market means that 90% of our items are made to order. From the
> information I have, Sales Kits do not seem to want to work with non-
> stock items.
>
> We have sales kits setup for customer units. These kits include all
> of the walls and roof for unit XYZ. The BOM for unit XYZ contains
> parts ABC1, ABC2, ABC3... Each of which have their own
> materials/operations.
>
> Currently, XYZ is set up as a Manufactured item. This creates
> jobs/travelers for production. However, when it gets to shipping
> they see to ship XYZ, without having any knowledge if which parts
> make up XYZ.
>
> Any recommendation to maintain the customer ordering a single part,
> with shipping seeing the individual parts is so greatly appreciated.
> This has already begun affecting our customer service.
>
> Adam Long
>
>
>
>
>
>
> ---------------------------------
> Looking for last minute shopping deals? Find them fast with Yahoo!
Search.
>
> [Non-text portions of this message have been removed]
>
5
We are finding the same issue. We thought we could get around it by
using configured within configured parts (now in 8.03.404)without
the sales kit, this logic seems to be able to get the right job(s)
launched, but the sales order line will then only show the parent
number and the packing/shipping of these is suspect. Connecting the
sales kit method with non-stock parts and then jobs is what we need
also.

This is an open item on our implementation right now.

Brad Boes
Metalworks

--- In vantage@yahoogroups.com, "Adam Long" <xcsdm@...> wrote:
>
> From what I can tell, this only works correctly if the components
of
> the kit are stock parts.
>
> Adam Long
>
> --- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@> wrote:
> >
> > You should run your sales order picklist. It will list all of the
> components for that sales order that are part of the kit
> >
> > Adam Long <xcsdm@> wrote: Here is the semi-urgent
situation:
> >
> > We produce, in this circumstance, aluminum frames for towable
RVs.
> > This market means that 90% of our items are made to order. From
the
> > information I have, Sales Kits do not seem to want to work with
non-
> > stock items.
> >
> > We have sales kits setup for customer units. These kits include
all
> > of the walls and roof for unit XYZ. The BOM for unit XYZ
contains
> > parts ABC1, ABC2, ABC3... Each of which have their own
> > materials/operations.
> >
> > Currently, XYZ is set up as a Manufactured item. This creates
> > jobs/travelers for production. However, when it gets to shipping
> > they see to ship XYZ, without having any knowledge if which
parts
> > make up XYZ.
> >
> > Any recommendation to maintain the customer ordering a single
part,
> > with shipping seeing the individual parts is so greatly
appreciated.
> > This has already begun affecting our customer service.
> >
> > Adam Long
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Looking for last minute shopping deals? Find them fast with
Yahoo!
> Search.
> >
> > [Non-text portions of this message have been removed]
> >
>
6
We set up our Kit Part as non-stock (but it doesnt really matter as the top level kit part acts like a phantom) Our top level components that are under the kit parent display on the sales order (if you click on kit components check box on the summary page) We do process jobs for the stock components and receive those to inventory. On customer shipment engry the demand link will show ship from inventory. When we ship the parent kit item the inventory is automatically relieved for the component items. About the only thing we dont like is having to issue these to stock. Would be nice to be able to ship all the components from their respective jobs

brad_boes <bboes@...> wrote: We are finding the same issue. We thought we could get around it by
using configured within configured parts (now in 8.03.404)without
the sales kit, this logic seems to be able to get the right job(s)
launched, but the sales order line will then only show the parent
number and the packing/shipping of these is suspect. Connecting the
sales kit method with non-stock parts and then jobs is what we need
also.

This is an open item on our implementation right now.

Brad Boes
Metalworks

--- In vantage@yahoogroups.com, "Adam Long" <xcsdm@...> wrote:
>
> From what I can tell, this only works correctly if the components
of
> the kit are stock parts.
>
> Adam Long
>
> --- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@> wrote:
> >
> > You should run your sales order picklist. It will list all of the
> components for that sales order that are part of the kit
> >
> > Adam Long <xcsdm@> wrote: Here is the semi-urgent
situation:
> >
> > We produce, in this circumstance, aluminum frames for towable
RVs.
> > This market means that 90% of our items are made to order. From
the
> > information I have, Sales Kits do not seem to want to work with
non-
> > stock items.
> >
> > We have sales kits setup for customer units. These kits include
all
> > of the walls and roof for unit XYZ. The BOM for unit XYZ
contains
> > parts ABC1, ABC2, ABC3... Each of which have their own
> > materials/operations.
> >
> > Currently, XYZ is set up as a Manufactured item. This creates
> > jobs/travelers for production. However, when it gets to shipping
> > they see to ship XYZ, without having any knowledge if which
parts
> > make up XYZ.
> >
> > Any recommendation to maintain the customer ordering a single
part,
> > with shipping seeing the individual parts is so greatly
appreciated.
> > This has already begun affecting our customer service.
> >
> > Adam Long
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Looking for last minute shopping deals? Find them fast with
Yahoo!
> Search.
> >
> > [Non-text portions of this message have been removed]
> >
>






---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

[Non-text portions of this message have been removed]
7
I'm curious about how you, and others, handle creation/release of
your jobs. Currently, we have order entry click the check boxes (4
of them, I believe) to create... release the jobs.

I set up an autoprint rule that prints the modified traveler to our
production scheduler. He the files and physcally releases the
travelers to the departments.

In my tests, order entry cannot create jobs for the stock components
of the kit. So I guess my question would come back to. How do you
create your jobs? and How does that person know what jobs to create?

Adam

--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> We set up our Kit Part as non-stock (but it doesnt really matter as
the top level kit part acts like a phantom) Our top level components
that are under the kit parent display on the sales order (if you
click on kit components check box on the summary page) We do process
jobs for the stock components and receive those to inventory. On
customer shipment engry the demand link will show ship from
inventory. When we ship the parent kit item the inventory is
automatically relieved for the component items. About the only thing
we dont like is having to issue these to stock. Would be nice to be
able to ship all the components from their respective jobs
>
> brad_boes <bboes@...> wrote: We are finding the same
issue. We thought we could get around it by
> using configured within configured parts (now in 8.03.404)without
> the sales kit, this logic seems to be able to get the right job(s)
> launched, but the sales order line will then only show the parent
> number and the packing/shipping of these is suspect. Connecting the
> sales kit method with non-stock parts and then jobs is what we need
> also.
>
> This is an open item on our implementation right now.
>
> Brad Boes
> Metalworks
>
> --- In vantage@yahoogroups.com, "Adam Long" <xcsdm@> wrote:
> >
> > From what I can tell, this only works correctly if the components
> of
> > the kit are stock parts.
> >
> > Adam Long
> >
> > --- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@> wrote:
> > >
> > > You should run your sales order picklist. It will list all of
the
> > components for that sales order that are part of the kit
> > >
> > > Adam Long <xcsdm@> wrote: Here is the semi-urgent
> situation:
> > >
> > > We produce, in this circumstance, aluminum frames for towable
> RVs.
> > > This market means that 90% of our items are made to order. From
> the
> > > information I have, Sales Kits do not seem to want to work with
> non-
> > > stock items.
> > >
> > > We have sales kits setup for customer units. These kits include
> all
> > > of the walls and roof for unit XYZ. The BOM for unit XYZ
> contains
> > > parts ABC1, ABC2, ABC3... Each of which have their own
> > > materials/operations.
> > >
> > > Currently, XYZ is set up as a Manufactured item. This creates
> > > jobs/travelers for production. However, when it gets to
shipping
> > > they see to ship XYZ, without having any knowledge if which
> parts
> > > make up XYZ.
> > >
> > > Any recommendation to maintain the customer ordering a single
> part,
> > > with shipping seeing the individual parts is so greatly
> appreciated.
> > > This has already begun affecting our customer service.
> > >
> > > Adam Long
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Looking for last minute shopping deals? Find them fast with
> Yahoo!
> > Search.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
Try it now.
>
> [Non-text portions of this message have been removed]
>
8
That is correct. Kits are pulled from stock as necessary. All of the
components are made to stock. You then pull the parts that make up the
kit and ship the kit out. You have a pick list that allows the shipping
or inventory people to pull the parts.



One thing you can do is modify the kit on the fly if you set it up to
allow it. This will allow you to modify the kit at order entry.



Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Adam Long
Sent: Wednesday, February 27, 2008 12:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03 Sales Kits with Made to Order parts



From what I can tell, this only works correctly if the components of
the kit are stock parts.

Adam Long

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Mark
Wagner <mjfw2003@...> wrote:
>
> You should run your sales order picklist. It will list all of the
components for that sales order that are part of the kit
>
> Adam Long <xcsdm@...> wrote: Here is the semi-urgent situation:
>
> We produce, in this circumstance, aluminum frames for towable RVs.
> This market means that 90% of our items are made to order. From the
> information I have, Sales Kits do not seem to want to work with non-
> stock items.
>
> We have sales kits setup for customer units. These kits include all
> of the walls and roof for unit XYZ. The BOM for unit XYZ contains
> parts ABC1, ABC2, ABC3... Each of which have their own
> materials/operations.
>
> Currently, XYZ is set up as a Manufactured item. This creates
> jobs/travelers for production. However, when it gets to shipping
> they see to ship XYZ, without having any knowledge if which parts
> make up XYZ.
>
> Any recommendation to maintain the customer ordering a single part,
> with shipping seeing the individual parts is so greatly appreciated.
> This has already begun affecting our customer service.
>
> Adam Long
>
>
>
>
>
>
> ---------------------------------
> Looking for last minute shopping deals? Find them fast with Yahoo!
Search.
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
9
99% of our sales parts are non-stock and we use the sales order wizard to create the jobs at customer order entry (although I can't ge the select all feature to work so if anyone knows how to get it to work let me know!) then mass print the travelers. We let MRP create the jobs then for the lower level components. If a sales part is set up as stock (as part of a kit) and the customer wants that part sold separately we flag to make it direct on the release and run the order wizard to link a job to that part

Adam Long <xcsdm@...> wrote: I'm curious about how you, and others, handle creation/release of
your jobs. Currently, we have order entry click the check boxes (4
of them, I believe) to create... release the jobs.

I set up an autoprint rule that prints the modified traveler to our
production scheduler. He the files and physcally releases the
travelers to the departments.

In my tests, order entry cannot create jobs for the stock components
of the kit. So I guess my question would come back to. How do you
create your jobs? and How does that person know what jobs to create?

Adam

--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> We set up our Kit Part as non-stock (but it doesnt really matter as
the top level kit part acts like a phantom) Our top level components
that are under the kit parent display on the sales order (if you
click on kit components check box on the summary page) We do process
jobs for the stock components and receive those to inventory. On
customer shipment engry the demand link will show ship from
inventory. When we ship the parent kit item the inventory is
automatically relieved for the component items. About the only thing
we dont like is having to issue these to stock. Would be nice to be
able to ship all the components from their respective jobs
>
> brad_boes <bboes@...> wrote: We are finding the same
issue. We thought we could get around it by
> using configured within configured parts (now in 8.03.404)without
> the sales kit, this logic seems to be able to get the right job(s)
> launched, but the sales order line will then only show the parent
> number and the packing/shipping of these is suspect. Connecting the
> sales kit method with non-stock parts and then jobs is what we need
> also.
>
> This is an open item on our implementation right now.
>
> Brad Boes
> Metalworks
>
> --- In vantage@yahoogroups.com, "Adam Long" <xcsdm@> wrote:
> >
> > From what I can tell, this only works correctly if the components
> of
> > the kit are stock parts.
> >
> > Adam Long
> >
> > --- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@> wrote:
> > >
> > > You should run your sales order picklist. It will list all of
the
> > components for that sales order that are part of the kit
> > >
> > > Adam Long <xcsdm@> wrote: Here is the semi-urgent
> situation:
> > >
> > > We produce, in this circumstance, aluminum frames for towable
> RVs.
> > > This market means that 90% of our items are made to order. From
> the
> > > information I have, Sales Kits do not seem to want to work with
> non-
> > > stock items.
> > >
> > > We have sales kits setup for customer units. These kits include
> all
> > > of the walls and roof for unit XYZ. The BOM for unit XYZ
> contains
> > > parts ABC1, ABC2, ABC3... Each of which have their own
> > > materials/operations.
> > >
> > > Currently, XYZ is set up as a Manufactured item. This creates
> > > jobs/travelers for production. However, when it gets to
shipping
> > > they see to ship XYZ, without having any knowledge if which
> parts
> > > make up XYZ.
> > >
> > > Any recommendation to maintain the customer ordering a single
> part,
> > > with shipping seeing the individual parts is so greatly
> appreciated.
> > > This has already begun affecting our customer service.
> > >
> > > Adam Long
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Looking for last minute shopping deals? Find them fast with
> Yahoo!
> > Search.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
Try it now.
>
> [Non-text portions of this message have been removed]
>






---------------------------------
Never miss a thing. Make Yahoo your homepage.

[Non-text portions of this message have been removed]
10
Vantage 6.10.504
Crystal 8.5.3.975

I had to add some user data from the part master to my Crystal invoice
form using ODBC. I can print the form without error from within
Crystal. It prompts me for the ODBC user id when I print or preview the
invoice. No errors.

When I try to print from Vantage, I never get a prompt for user id -
just error 599. How do I fix this??

Frances Skidmore
Entek Corporation
Phone: 405-364-5588
FAX: 405-364-4727
Email: Frances@... <mailto:Frances@...>

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
Id=62953/stime=1204216581/nc1=4507179/nc2=3848642/nc3=4836044>



[Non-text portions of this message have been removed]
11
MRP creates unfirmed jobs and purchasing suggestions.

Adam Long <xcsdm@...> wrote: I'm curious about how you, and others, handle creation/release of
your jobs. Currently, we have order entry click the check boxes (4
of them, I believe) to create... release the jobs.

I set up an autoprint rule that prints the modified traveler to our
production scheduler. He the files and physcally releases the
travelers to the departments.

In my tests, order entry cannot create jobs for the stock components
of the kit. So I guess my question would come back to. How do you
create your jobs? and How does that person know what jobs to create?

Adam

--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> We set up our Kit Part as non-stock (but it doesnt really matter as
the top level kit part acts like a phantom) Our top level components
that are under the kit parent display on the sales order (if you
click on kit components check box on the summary page) We do process
jobs for the stock components and receive those to inventory. On
customer shipment engry the demand link will show ship from
inventory. When we ship the parent kit item the inventory is
automatically relieved for the component items. About the only thing
we dont like is having to issue these to stock. Would be nice to be
able to ship all the components from their respective jobs
>
> brad_boes <bboes@...> wrote: We are finding the same
issue. We thought we could get around it by
> using configured within configured parts (now in 8.03.404)without
> the sales kit, this logic seems to be able to get the right job(s)
> launched, but the sales order line will then only show the parent
> number and the packing/shipping of these is suspect. Connecting the
> sales kit method with non-stock parts and then jobs is what we need
> also.
>
> This is an open item on our implementation right now.
>
> Brad Boes
> Metalworks
>
> --- In vantage@yahoogroups.com, "Adam Long" <xcsdm@> wrote:
> >
> > From what I can tell, this only works correctly if the components
> of
> > the kit are stock parts.
> >
> > Adam Long
> >
> > --- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@> wrote:
> > >
> > > You should run your sales order picklist. It will list all of
the
> > components for that sales order that are part of the kit
> > >
> > > Adam Long <xcsdm@> wrote: Here is the semi-urgent
> situation:
> > >
> > > We produce, in this circumstance, aluminum frames for towable
> RVs.
> > > This market means that 90% of our items are made to order. From
> the
> > > information I have, Sales Kits do not seem to want to work with
> non-
> > > stock items.
> > >
> > > We have sales kits setup for customer units. These kits include
> all
> > > of the walls and roof for unit XYZ. The BOM for unit XYZ
> contains
> > > parts ABC1, ABC2, ABC3... Each of which have their own
> > > materials/operations.
> > >
> > > Currently, XYZ is set up as a Manufactured item. This creates
> > > jobs/travelers for production. However, when it gets to
shipping
> > > they see to ship XYZ, without having any knowledge if which
> parts
> > > make up XYZ.
> > >
> > > Any recommendation to maintain the customer ordering a single
> part,
> > > with shipping seeing the individual parts is so greatly
> appreciated.
> > > This has already begun affecting our customer service.
> > >
> > > Adam Long
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Looking for last minute shopping deals? Find them fast with
> Yahoo!
> > Search.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
Try it now.
>
> [Non-text portions of this message have been removed]
>






---------------------------------
Never miss a thing. Make Yahoo your homepage.

[Non-text portions of this message have been removed]
12
To all those who helped me over the years including this solution,

You need to add these lines to your Vantage.vtg file.

VantageODBCServer=(Your ODBC connection name)
VantageODBCDbse=(Vantage Server Name)
VantageODBCUser=(ODBC UserName)
VantageODBCpasswd=(ODBC pwd)

Since it works when previewing in Crystal, those are the values needed.

David Gartner
EPG Companies Inc.




_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Frances Skidmore
Sent: Thursday, February 28, 2008 10:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Invoices




Vantage 6.10.504
Crystal 8.5.3.975

I had to add some user data from the part master to my Crystal invoice
form using ODBC. I can print the form without error from within
Crystal. It prompts me for the ODBC user id when I print or preview the
invoice. No errors.

When I try to print from Vantage, I never get a prompt for user id -
just error 599. How do I fix this??

Frances Skidmore
Entek Corporation
Phone: 405-364-5588
FAX: 405-364-4727
Email: Frances@entek. <mailto:Frances%40entek.net> net
<mailto:Frances@entek. <mailto:Frances%40entek.net> net>

<http://geo.yahoo
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg>
com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
Id=62953/stime=1204216581/nc1=4507179/nc2=3848642/nc3=4836044>


[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
13
We did have Sales at first creating just the Job Header by using Order Job
Wizard. They would not check the Engineered or Release check boxes, they
just check the Create Jobs and Get Details check boxes. I also created a
modified Sales Acknowledgement report that we call a Job Summary. In our
environment Sales may have some type of physical item (a print out, fabric
sample, etc...) that needs to be passed to production. So they would create
the job and then print this Job Summary sheet place this and any additional
information into a Job packet which production would get.

Now after we went to 8.803 the Order Job Wizard placed a leading zero in
front of the Job Number (no idea why Epicor made that change) so now instead
of Sales creating a Job, our Engineers or Schedulers do. We always wanted it
this way because it is production that can determine if One Job may fill
multiple orders or stock needs (one supply filling multiple demands).
Production are the experts so let the experts create the jobs.

In both scenarios above the Engineers still review the Job and make any
necessary changes before marking it Engineered. Then the Schedulers,
schedules it and releases it.

With Sales Kits in 8.03 we now have converted 20 to 25 parts from a
manufactured part to a kitted part. This was a real help because it kept
those parts that should never hit the production area out of their world.
When Picking Tickets are printed it will print the Sales Kits Part and the
needed components that Warehouse pulls together for shipping.

MRP does create both Unfirm Jobs and Job Suggestions which our Engineers
need to look at. Most unfirm jobs are stock parts that have an approved
method. So they firm them up and release then to production. Job Suggestions
in Planning Workbench are mostly Sales Orders that need to be created,
getting details (either configured or an approved method) and then going
through the Engineer review process and Scheduling process.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Adam Long
Sent: Thursday, February 28, 2008 9:12 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03 Sales Kits with Made to Order parts

I'm curious about how you, and others, handle creation/release of
your jobs. Currently, we have order entry click the check boxes (4
of them, I believe) to create... release the jobs.

I set up an autoprint rule that prints the modified traveler to our
production scheduler. He the files and physcally releases the
travelers to the departments.

In my tests, order entry cannot create jobs for the stock components
of the kit. So I guess my question would come back to. How do you
create your jobs? and How does that person know what jobs to create?

Adam

--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> We set up our Kit Part as non-stock (but it doesnt really matter as
the top level kit part acts like a phantom) Our top level components
that are under the kit parent display on the sales order (if you
click on kit components check box on the summary page) We do process
jobs for the stock components and receive those to inventory. On
customer shipment engry the demand link will show ship from
inventory. When we ship the parent kit item the inventory is
automatically relieved for the component items. About the only thing
we dont like is having to issue these to stock. Would be nice to be
able to ship all the components from their respective jobs
>
> brad_boes <bboes@...> wrote: We are finding the same
issue. We thought we could get around it by
> using configured within configured parts (now in 8.03.404)without
> the sales kit, this logic seems to be able to get the right job(s)
> launched, but the sales order line will then only show the parent
> number and the packing/shipping of these is suspect. Connecting the
> sales kit method with non-stock parts and then jobs is what we need
> also.
>
> This is an open item on our implementation right now.
>
> Brad Boes
> Metalworks
>
> --- In vantage@yahoogroups.com, "Adam Long" <xcsdm@> wrote:
> >
> > From what I can tell, this only works correctly if the components
> of
> > the kit are stock parts.
> >
> > Adam Long
> >
> > --- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@> wrote:
> > >
> > > You should run your sales order picklist. It will list all of
the
> > components for that sales order that are part of the kit
> > >
> > > Adam Long <xcsdm@> wrote: Here is the semi-urgent
> situation:
> > >
> > > We produce, in this circumstance, aluminum frames for towable
> RVs.
> > > This market means that 90% of our items are made to order. From
> the
> > > information I have, Sales Kits do not seem to want to work with
> non-
> > > stock items.
> > >
> > > We have sales kits setup for customer units. These kits include
> all
> > > of the walls and roof for unit XYZ. The BOM for unit XYZ
> contains
> > > parts ABC1, ABC2, ABC3... Each of which have their own
> > > materials/operations.
> > >
> > > Currently, XYZ is set up as a Manufactured item. This creates
> > > jobs/travelers for production. However, when it gets to
shipping
> > > they see to ship XYZ, without having any knowledge if which
> parts
> > > make up XYZ.
> > >
> > > Any recommendation to maintain the customer ordering a single
> part,
> > > with shipping seeing the individual parts is so greatly
> appreciated.
> > > This has already begun affecting our customer service.
> > >
> > > Adam Long
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Looking for last minute shopping deals? Find them fast with
> Yahoo!
> > Search.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
Try it now.
>
> [Non-text portions of this message have been removed]
>




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
Yahoo! Groups Links
14
OK, I don't have a Vantage.vtg file. Should I create one? where should
it be located?
I do have a mfgsys.ini in my mfgsys61 directory.
Thanks
Frances Skidmore
Entek Corporation
Phone: 405-364-5588
FAX: 405-364-4727
Email: Frances@... <mailto:Frances@...>

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of David Gartner
Sent: Thursday, February 28, 2008 11:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Invoices



To all those who helped me over the years including this solution,

You need to add these lines to your Vantage.vtg file.

VantageODBCServer=(Your ODBC connection name)
VantageODBCDbse=(Vantage Server Name)
VantageODBCUser=(ODBC UserName)
VantageODBCpasswd=(ODBC pwd)

Since it works when previewing in Crystal, those are the values needed.

David Gartner
EPG Companies Inc.



_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Frances Skidmore
Sent: Thursday, February 28, 2008 10:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Invoices

Vantage 6.10.504
Crystal 8.5.3.975

I had to add some user data from the part master to my Crystal invoice
form using ODBC. I can print the form without error from within
Crystal. It prompts me for the ODBC user id when I print or preview the
invoice. No errors.

When I try to print from Vantage, I never get a prompt for user id -
just error 599. How do I fix this??

Frances Skidmore
Entek Corporation
Phone: 405-364-5588
FAX: 405-364-4727
Email: Frances@entek. <mailto:Frances%40entek.net> net
<mailto:Frances@entek. <mailto:Frances%40entek.net> net>

<http://geo.yahoo
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
> >
com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
Id=62953/stime=1204216581/nc1=4507179/nc2=3848642/nc3=4836044>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
15
First place to look is on your desktop. The Vantage shortcut that could
have been placed there during installation is Vantage.vtg. Right click on
it and select Edit. This is the icon used by every user unless a more
custom install was done. After reviewing information on the list, I created
specific Vtg's for a few of my specialized users.
Also, it would be a good use of your time to search the Yahoo list for
solutions. I swear it would be a great appendix to Epicor manuals.

David



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Frances Skidmore
Sent: Tuesday, March 04, 2008 8:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Invoices



OK, I don't have a Vantage.vtg file. Should I create one? where should
it be located?
I do have a mfgsys.ini in my mfgsys61 directory.
Thanks
Frances Skidmore
Entek Corporation
Phone: 405-364-5588
FAX: 405-364-4727
Email: Frances@entek. <mailto:Frances%40entek.net> net
<mailto:Frances@entek. <mailto:Frances%40entek.net> net>

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of David Gartner
Sent: Thursday, February 28, 2008 11:53 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Crystal Invoices

To all those who helped me over the years including this solution,

You need to add these lines to your Vantage.vtg file.

VantageODBCServer=(Your ODBC connection name)
VantageODBCDbse=(Vantage Server Name)
VantageODBCUser=(ODBC UserName)
VantageODBCpasswd=(ODBC pwd)

Since it works when previewing in Crystal, those are the values needed.

David Gartner
EPG Companies Inc.

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Frances Skidmore
Sent: Thursday, February 28, 2008 10:51 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Invoices

Vantage 6.10.504
Crystal 8.5.3.975

I had to add some user data from the part master to my Crystal invoice
form using ODBC. I can print the form without error from within
Crystal. It prompts me for the ODBC user id when I print or preview the
invoice. No errors.

When I try to print from Vantage, I never get a prompt for user id -
just error 599. How do I fix this??

Frances Skidmore
Entek Corporation
Phone: 405-364-5588
FAX: 405-364-4727
Email: Frances@entek. <mailto:Frances%40entek.net> net
<mailto:Frances@entek. <mailto:Frances%40entek.net> net>



.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msgId=6
3037/stime=1204642314/nc1=4507179/nc2=3848641/nc3=4763758>




[Non-text portions of this message have been removed]