Time Phase Report 8.03 409A

I would like to take a gander as well!

Thanks,

Adolfo

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Yes, I second that. It would also be a big help for us to, although I completely understand that it must have taken you a long time to complete.
>
> Michael
>
> --- In vantage@yahoogroups.com, robertb_versa@ wrote:
> >
> > Charles,
> >
> > I appreciate the amount of work that must have taken.
> >
> > I for one would like a peek at it.
> >
> > Rob Brown
> >
> > --- Original Message ---
> > From:"Charles Carden" <shadowcar1449@>
> > Sent:Wed 6/30/10 9:38 am
> > To:<vantage@yahoogroups.com>
> > Subj:Re: [Vantage] Re: Time Phase Report 8.03 409A
> >
> > I also found the built in report to be totally useless, especially since you cannot run it by buyer. I have a BAQ time phase report that I wrote. It does not include PO suggestions but makes its own suggestions based on demand and usage. The report can be filtered by Plant, Buyer ID, ClassID or PlannerID. It can be filtered by Part Number as well and I suppose you could add options to select records by beginning and ending part number as well. It sorts by Plant, Buyer/Planner, Default Vendor ID, Part Number and Due Date.
> >
> > The tables included in the BAQ are:
> > PartPlant
> > Part
> > PartDtl
> > Plant
> > PurAgent
> > Vendor
> > Person
> > PartWhse
> > JobProd
> > PORel
> > PartCost
> >
> > I spent a considerable amout of time writing this report so in a way I am reluctant to distribute it freely but if there is enough interest I might be willing to do so. I could upload a sample of the report to the website if anyone is interested in taking a look at what it looks like.
> >
> >
> > Charles Carden
> > IT Manager
> > Manitex, Inc.
> > Georgetown, Texas
> > ----- Original Message -----
> > From: bw2868bond
> > To: vantage@yahoogroups.com
> > Sent: Tuesday, June 29, 2010 2:31 PM
> > Subject: [Vantage] Re: Time Phase Report 8.03 409A
> >
> >
> >
> > Our purchasing people wanted to be able to run a time phase report for a range of part numbers - The full report was way too many pages and one at a time was out of the question as well.
> >
> > I created a ASP.Net web application on our internal web server (that runs service connect) to accept a start and end part number. It then gets a list of purchased parts from the part table. Each part in the returned list is then sent to the time phase web service to return the timephase data. The data is accumulated and then displayed in a .net web part datagrid. I added a button which then exports the grid in a format that Excel can use.
> >
> > So, input a start and end part and you get back the time phase report in Excel format.
> >
> > If you are interested I can share the solution - obviously you will have to change parameters to fit your environment, but it should give you a starting point if it would be of use....
> > The code is not commented nor is there error handling :o)
> >
> > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > >
> > > I'm looking for one too
> > >
> > > I did create something like a time phase report for a department here.
> > > It is too specialized for them and would not be of any use to you.
> > > I used MS-Access and ODBC.
> > > It took a lot more hours than I wanted to put in and it still has issues.
> > > I found I had to export all the data into Access tables and use those for the report.
> > > A direct link to progress tables was not working for me.
> > > After this exercise, I could see why Epicor hasn't converted TimePhase yet.
> > >
> > > --- In vantage@yahoogroups.com, "Don Kollmann" <dkollmann@> wrote:
> > > >
> > > > .
> > > > Hi Everyone,
> > > >
> > > > I am looking for a replacement of the timephase report since going to
> > > > to 409A Epicor inc
> >
>
Anyone know how to make this work? I just want to get a list of
currently active customers with name, address, city, state, zip.



The help is of no help.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]
First key is to have attributes associated to your customers....



I'll send you what we do so you can have an idea...







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Thursday, February 18, 2010 10:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Marketing List Generator





Anyone know how to make this work? I just want to get a list of
currently active customers with name, address, city, state, zip.

The help is of no help.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com
<http://www.advancedphotonix.com> >

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





[Non-text portions of this message have been removed]
Yeah I don't have attributes assigned. So I guess I'll write a Crystal Report. :-)

Thanks for sending the doc you did though...

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Thursday, February 18, 2010 12:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Marketing List Generator

First key is to have attributes associated to your customers....



I'll send you what we do so you can have an idea...







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Thursday, February 18, 2010 10:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Marketing List Generator





Anyone know how to make this work? I just want to get a list of
currently active customers with name, address, city, state, zip.

The help is of no help.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com
<http://www.advancedphotonix.com> >

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





[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/linksYahoo! Groups Links
Brian, you might still be able to use it as long as you don't mind it
returning ALL of your customers.



The attributes help when you need to filter out customers.







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Thursday, February 18, 2010 1:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Marketing List Generator





Yeah I don't have attributes assigned. So I guess I'll write a Crystal
Report. :-)

Thanks for sending the doc you did though...

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Thursday, February 18, 2010 12:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Marketing List Generator

First key is to have attributes associated to your customers....

I'll send you what we do so you can have an idea...

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa@... <mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian W. Spolarich
Sent: Thursday, February 18, 2010 10:31 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Marketing List Generator

Anyone know how to make this work? I just want to get a list of
currently active customers with name, address, city, state, zip.

The help is of no help.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com
<http://www.advancedphotonix.com>
<http://www.advancedphotonix.com <http://www.advancedphotonix.com> > >

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

[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links





[Non-text portions of this message have been removed]
It looks like it only returns customers who have attributes defined, which is only a handful (inner join instead of outer).

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Thursday, February 18, 2010 2:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Marketing List Generator

Brian, you might still be able to use it as long as you don't mind it
returning ALL of your customers.



The attributes help when you need to filter out customers.







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Thursday, February 18, 2010 1:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Marketing List Generator





Yeah I don't have attributes assigned. So I guess I'll write a Crystal
Report. :-)

Thanks for sending the doc you did though...

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Thursday, February 18, 2010 12:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Marketing List Generator

First key is to have attributes associated to your customers....

I'll send you what we do so you can have an idea...

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa@... <mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian W. Spolarich
Sent: Thursday, February 18, 2010 10:31 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Marketing List Generator

Anyone know how to make this work? I just want to get a list of
currently active customers with name, address, city, state, zip.

The help is of no help.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com
<http://www.advancedphotonix.com>
<http://www.advancedphotonix.com <http://www.advancedphotonix.com> > >

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

[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links





[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/linksYahoo! Groups Links
All I can say is that my marketing girl actually uses this so I cannot
comment too much on it.



Oh well...crystal will return what you want for sure, as long as someone
has actually filled in the info you are looking for in your report.







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Thursday, February 18, 2010 1:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Marketing List Generator





It looks like it only returns customers who have attributes defined,
which is only a handful (inner join instead of outer).

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Thursday, February 18, 2010 2:28 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Marketing List Generator

Brian, you might still be able to use it as long as you don't mind it
returning ALL of your customers.

The attributes help when you need to filter out customers.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa@... <mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian W. Spolarich
Sent: Thursday, February 18, 2010 1:15 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Marketing List Generator

Yeah I don't have attributes assigned. So I guess I'll write a Crystal
Report. :-)

Thanks for sending the doc you did though...

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Thursday, February 18, 2010 12:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Marketing List Generator

First key is to have attributes associated to your customers....

I'll send you what we do so you can have an idea...

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian W. Spolarich
Sent: Thursday, February 18, 2010 10:31 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Marketing List Generator

Anyone know how to make this work? I just want to get a list of
currently active customers with name, address, city, state, zip.

The help is of no help.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com
<http://www.advancedphotonix.com>
<http://www.advancedphotonix.com <http://www.advancedphotonix.com> >
<http://www.advancedphotonix.com <http://www.advancedphotonix.com>
<http://www.advancedphotonix.com <http://www.advancedphotonix.com> > > >


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

[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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
<http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo>
<http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> > ! Groups Links

[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links





[Non-text portions of this message have been removed]
Do you have Information Worker (IW)? It has some tools for creating lists for marketing where you can choose the bits of info you want to list. I used IW within excel to pull a filtered customer list with the details you asked for below.

Before we were rolling with IW, I created a BAQ to pull the same data but had to do a bit of cleanup. I can probably track it down if you would like it.

Cheers,
Val Lord
Taphandles, Inc.

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> Anyone know how to make this work? I just want to get a list of
> currently active customers with name, address, city, state, zip.
>
>
>
> The help is of no help.
>
>
>
> -bws
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@...
> <mailto:bspolarich@...> ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I have IW but haven't been able to really leverage it.

I have a BAQ that I wrote...simple enough to pull the details that I want.

Thanks though!

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Val
Sent: Thursday, February 18, 2010 4:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Marketing List Generator

Do you have Information Worker (IW)? It has some tools for creating lists for marketing where you can choose the bits of info you want to list. I used IW within excel to pull a filtered customer list with the details you asked for below.

Before we were rolling with IW, I created a BAQ to pull the same data but had to do a bit of cleanup. I can probably track it down if you would like it.

Cheers,
Val Lord
Taphandles, Inc.

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> Anyone know how to make this work? I just want to get a list of
> currently active customers with name, address, city, state, zip.
>
>
>
> The help is of no help.
>
>
>
> -bws
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@...
> <mailto:bspolarich@...> ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
>
>
>
>
> [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/linksYahoo! Groups Links
Could you send it to me also, or post it. We have been live for over a year and now there is finally talk about marketing. I am very hopeful that we may use these modules. Not sure how to yet.

Thanks,

Plamen Cheshmedjiev
Systems Administrator
Art Display Co.

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> First key is to have attributes associated to your customers....
>
>
>
> I'll send you what we do so you can have an idea...
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@... <mailto:manasa@...>
>
> 800.852.2325
>
> 630.806.2000 ofc
>
> 630.806.2001 fax
>
> www.weldcoa.com
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Brian W. Spolarich
> Sent: Thursday, February 18, 2010 10:31 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Marketing List Generator
>
>
>
>
>
> Anyone know how to make this work? I just want to get a list of
> currently active customers with name, address, city, state, zip.
>
> The help is of no help.
>
> -bws
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com>
> <mailto:bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com
> <http://www.advancedphotonix.com> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
.
Hi Everyone,

I am looking for a replacement of the timephase report since going to
to 409A Epicor includes all parts whether or not there is activity on
the part or not if you do not select an exemption it increased our
report
to an absurd amout of pages. With the report still being progress I
cannot edit it. Has anyone created a crystal report using ODBC or BAQ
that replicates a time phase report.

I appreciate your help

Thank You

Don Kollmann
ACH Foam Technologies




[Non-text portions of this message have been removed]
Sure can, but give me a couple of days to send...







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of plamen21
Sent: Wednesday, June 09, 2010 1:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Marketing List Generator





Could you send it to me also, or post it. We have been live for over a
year and now there is finally talk about marketing. I am very hopeful
that we may use these modules. Not sure how to yet.

Thanks,

Plamen Cheshmedjiev
Systems Administrator
Art Display Co.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> First key is to have attributes associated to your customers....
>
>
>
> I'll send you what we do so you can have an idea...
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@... <mailto:manasa@...>
>
> 800.852.2325
>
> 630.806.2000 ofc
>
> 630.806.2001 fax
>
> www.weldcoa.com
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Brian W. Spolarich
> Sent: Thursday, February 18, 2010 10:31 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Marketing List Generator
>
>
>
>
>
> Anyone know how to make this work? I just want to get a list of
> currently active customers with name, address, city, state, zip.
>
> The help is of no help.
>
> -bws
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
/
> Picometrix
>
> bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com>
> <mailto:bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com
> <http://www.advancedphotonix.com> >
>
> [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]
Our purchasing people wanted to be able to run a time phase report for a range of part numbers - The full report was way too many pages and one at a time was out of the question as well.

I created a ASP.Net web application on our internal web server (that runs service connect) to accept a start and end part number. It then gets a list of purchased parts from the part table. Each part in the returned list is then sent to the time phase web service to return the timephase data. The data is accumulated and then displayed in a .net web part datagrid. I added a button which then exports the grid in a format that Excel can use.

So, input a start and end part and you get back the time phase report in Excel format.

If you are interested I can share the solution - obviously you will have to change parameters to fit your environment, but it should give you a starting point if it would be of use....
The code is not commented nor is there error handling :o)

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> I'm looking for one too
>
> I did create something like a time phase report for a department here.
> It is too specialized for them and would not be of any use to you.
> I used MS-Access and ODBC.
> It took a lot more hours than I wanted to put in and it still has issues.
> I found I had to export all the data into Access tables and use those for the report.
> A direct link to progress tables was not working for me.
> After this exercise, I could see why Epicor hasn't converted TimePhase yet.
>
> --- In vantage@yahoogroups.com, "Don Kollmann" <dkollmann@> wrote:
> >
> > .
> > Hi Everyone,
> >
> > I am looking for a replacement of the timephase report since going to
> > to 409A Epicor includes all parts whether or not there is activity on
> > the part or not if you do not select an exemption it increased our
> > report
> > to an absurd amout of pages. With the report still being progress I
> > cannot edit it. Has anyone created a crystal report using ODBC or BAQ
> > that replicates a time phase report.
> >
> > I appreciate your help
> >
> > Thank You
> >
> > Don Kollmann
> > ACH Foam Technologies
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
I also found the built in report to be totally useless, especially since you cannot run it by buyer. I have a BAQ time phase report that I wrote. It does not include PO suggestions but makes its own suggestions based on demand and usage. The report can be filtered by Plant, Buyer ID, ClassID or PlannerID. It can be filtered by Part Number as well and I suppose you could add options to select records by beginning and ending part number as well. It sorts by Plant, Buyer/Planner, Default Vendor ID, Part Number and Due Date.

The tables included in the BAQ are:
PartPlant
Part
PartDtl
Plant
PurAgent
Vendor
Person
PartWhse
JobProd
PORel
PartCost

I spent a considerable amout of time writing this report so in a way I am reluctant to distribute it freely but if there is enough interest I might be willing to do so. I could upload a sample of the report to the website if anyone is interested in taking a look at what it looks like.


Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
----- Original Message -----
From: bw2868bond
To: vantage@yahoogroups.com
Sent: Tuesday, June 29, 2010 2:31 PM
Subject: [Vantage] Re: Time Phase Report 8.03 409A



Our purchasing people wanted to be able to run a time phase report for a range of part numbers - The full report was way too many pages and one at a time was out of the question as well.

I created a ASP.Net web application on our internal web server (that runs service connect) to accept a start and end part number. It then gets a list of purchased parts from the part table. Each part in the returned list is then sent to the time phase web service to return the timephase data. The data is accumulated and then displayed in a .net web part datagrid. I added a button which then exports the grid in a format that Excel can use.

So, input a start and end part and you get back the time phase report in Excel format.

If you are interested I can share the solution - obviously you will have to change parameters to fit your environment, but it should give you a starting point if it would be of use....
The code is not commented nor is there error handling :o)

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> I'm looking for one too
>
> I did create something like a time phase report for a department here.
> It is too specialized for them and would not be of any use to you.
> I used MS-Access and ODBC.
> It took a lot more hours than I wanted to put in and it still has issues.
> I found I had to export all the data into Access tables and use those for the report.
> A direct link to progress tables was not working for me.
> After this exercise, I could see why Epicor hasn't converted TimePhase yet.
>
> --- In vantage@yahoogroups.com, "Don Kollmann" <dkollmann@> wrote:
> >
> > .
> > Hi Everyone,
> >
> > I am looking for a replacement of the timephase report since going to
> > to 409A Epicor includes all parts whether or not there is activity on
> > the part or not if you do not select an exemption it increased our
> > report
> > to an absurd amout of pages. With the report still being progress I
> > cannot edit it. Has anyone created a crystal report using ODBC or BAQ
> > that replicates a time phase report.
> >
> > I appreciate your help
> >
> > Thank You
> >
> > Don Kollmann
> > ACH Foam Technologies
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>





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

I appreciate the amount of work that must have taken.

I for one would like a peek at it.

Rob Brown

--- Original Message ---
From:"Charles Carden" <shadowcar1449@...>
Sent:Wed 6/30/10 9:38 am
To:<vantage@yahoogroups.com>
Subj:Re: [Vantage] Re: Time Phase Report 8.03 409A

I also found the built in report to be totally useless, especially since you cannot run it by buyer. I have a BAQ time phase report that I wrote. It does not include PO suggestions but makes its own suggestions based on demand and usage. The report can be filtered by Plant, Buyer ID, ClassID or PlannerID. It can be filtered by Part Number as well and I suppose you could add options to select records by beginning and ending part number as well. It sorts by Plant, Buyer/Planner, Default Vendor ID, Part Number and Due Date.

The tables included in the BAQ are:
PartPlant
Part
PartDtl
Plant
PurAgent
Vendor
Person
PartWhse
JobProd
PORel
PartCost

I spent a considerable amout of time writing this report so in a way I am reluctant to distribute it freely but if there is enough interest I might be willing to do so. I could upload a sample of the report to the website if anyone is interested in taking a look at what it looks like.


Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
----- Original Message -----
From: bw2868bond
To: vantage@yahoogroups.com
Sent: Tuesday, June 29, 2010 2:31 PM
Subject: [Vantage] Re: Time Phase Report 8.03 409A



Our purchasing people wanted to be able to run a time phase report for a range of part numbers - The full report was way too many pages and one at a time was out of the question as well.

I created a ASP.Net web application on our internal web server (that runs service connect) to accept a start and end part number. It then gets a list of purchased parts from the part table. Each part in the returned list is then sent to the time phase web service to return the timephase data. The data is accumulated and then displayed in a .net web part datagrid. I added a button which then exports the grid in a format that Excel can use.

So, input a start and end part and you get back the time phase report in Excel format.

If you are interested I can share the solution - obviously you will have to change parameters to fit your environment, but it should give you a starting point if it would be of use....
The code is not commented nor is there error handling :o)

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> I'm looking for one too
>
> I did create something like a time phase report for a department here.
> It is too specialized for them and would not be of any use to you.
> I used MS-Access and ODBC.
> It took a lot more hours than I wanted to put in and it still has issues.
> I found I had to export all the data into Access tables and use those for the report.
> A direct link to progress tables was not working for me.
> After this exercise, I could see why Epicor hasn't converted TimePhase yet.
>
> --- In vantage@yahoogroups.com, "Don Kollmann" <dkollmann@> wrote:
> >
> > .
> > Hi Everyone,
> >
> > I am looking for a replacement of the timephase report since going to
> > to 409A Epicor inc
Yes, I second that. It would also be a big help for us to, although I completely understand that it must have taken you a long time to complete.

Michael

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> Charles,
>
> I appreciate the amount of work that must have taken.
>
> I for one would like a peek at it.
>
> Rob Brown
>
> --- Original Message ---
> From:"Charles Carden" <shadowcar1449@...>
> Sent:Wed 6/30/10 9:38 am
> To:<vantage@yahoogroups.com>
> Subj:Re: [Vantage] Re: Time Phase Report 8.03 409A
>
> I also found the built in report to be totally useless, especially since you cannot run it by buyer. I have a BAQ time phase report that I wrote. It does not include PO suggestions but makes its own suggestions based on demand and usage. The report can be filtered by Plant, Buyer ID, ClassID or PlannerID. It can be filtered by Part Number as well and I suppose you could add options to select records by beginning and ending part number as well. It sorts by Plant, Buyer/Planner, Default Vendor ID, Part Number and Due Date.
>
> The tables included in the BAQ are:
> PartPlant
> Part
> PartDtl
> Plant
> PurAgent
> Vendor
> Person
> PartWhse
> JobProd
> PORel
> PartCost
>
> I spent a considerable amout of time writing this report so in a way I am reluctant to distribute it freely but if there is enough interest I might be willing to do so. I could upload a sample of the report to the website if anyone is interested in taking a look at what it looks like.
>
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> Georgetown, Texas
> ----- Original Message -----
> From: bw2868bond
> To: vantage@yahoogroups.com
> Sent: Tuesday, June 29, 2010 2:31 PM
> Subject: [Vantage] Re: Time Phase Report 8.03 409A
>
>
>
> Our purchasing people wanted to be able to run a time phase report for a range of part numbers - The full report was way too many pages and one at a time was out of the question as well.
>
> I created a ASP.Net web application on our internal web server (that runs service connect) to accept a start and end part number. It then gets a list of purchased parts from the part table. Each part in the returned list is then sent to the time phase web service to return the timephase data. The data is accumulated and then displayed in a .net web part datagrid. I added a button which then exports the grid in a format that Excel can use.
>
> So, input a start and end part and you get back the time phase report in Excel format.
>
> If you are interested I can share the solution - obviously you will have to change parameters to fit your environment, but it should give you a starting point if it would be of use....
> The code is not commented nor is there error handling :o)
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > I'm looking for one too
> >
> > I did create something like a time phase report for a department here.
> > It is too specialized for them and would not be of any use to you.
> > I used MS-Access and ODBC.
> > It took a lot more hours than I wanted to put in and it still has issues.
> > I found I had to export all the data into Access tables and use those for the report.
> > A direct link to progress tables was not working for me.
> > After this exercise, I could see why Epicor hasn't converted TimePhase yet.
> >
> > --- In vantage@yahoogroups.com, "Don Kollmann" <dkollmann@> wrote:
> > >
> > > .
> > > Hi Everyone,
> > >
> > > I am looking for a replacement of the timephase report since going to
> > > to 409A Epicor inc
>