Fw: Report

Thanks Patrick
----- Original Message -----
From: <pjw@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, August 28, 2003 5:20 PM
Subject: RE: [Vantage] Fw: Report


> Robert,
>
> You can create this in report builder by joining the part table to part
> transactions.
> Group and sort on part number.
> Filter for STK-CUS or MFG-CUS transactions. (Shipments)
> Set an aggregate variable on the transaction date, set it to maximum to
get
> the last ship date.
> Filter again on the aggregate variable you created for older than a year
or
> whatever your looking for.
>
> Patrick Winter
>
>
> -----Original Message-----
> From: Robert Christian [mailto:bobc@...]
> Sent: Wednesday, August 27, 2003 3:24 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Fw: Report
>
>
>
> ----- Original Message -----
> From: Robert Christian
> To: vantage@yahoogroups.com
> Sent: Tuesday, August 26, 2003 4:01 PM
> Subject: Fw: Report
>
>
>
> ----- Original Message -----
> From: Robert Christian
> To: vantage@yahoogroups.com
> Sent: Monday, August 25, 2003 8:34 AM
> Subject: Report
>
>
> Does anyone have a report that will show parts that have been ordered in
> the past (by customers) and have not been ordered recently. We are trying
to
> keep an eye on all parts so we can ask customers why we have not received
an
> order
> recently. Thanks for all your help Bob Christian Gasser & Sons Inc.
>
>
> [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
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> 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/
>
>
>
----- Original Message -----
From: Robert Christian
To: vantage@yahoogroups.com
Sent: Monday, August 25, 2003 8:34 AM
Subject: Report


Does anyone have a report that will show parts that have been ordered in the past (by customers) and have not been ordered recently. We are trying to keep an eye on all parts so we can ask customers why we have not received an order
recently. Thanks for all your help Bob Christian Gasser & Sons Inc.


[Non-text portions of this message have been removed]
----- Original Message -----
From: Robert Christian
To: vantage@yahoogroups.com
Sent: Tuesday, August 26, 2003 4:01 PM
Subject: Fw: Report



----- Original Message -----
From: Robert Christian
To: vantage@yahoogroups.com
Sent: Monday, August 25, 2003 8:34 AM
Subject: Report


Does anyone have a report that will show parts that have been ordered in the past (by customers) and have not been ordered recently. We are trying to keep an eye on all parts so we can ask customers why we have not received an order
recently. Thanks for all your help Bob Christian Gasser & Sons Inc.


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

You can create this in report builder by joining the part table to part
transactions.
Group and sort on part number.
Filter for STK-CUS or MFG-CUS transactions. (Shipments)
Set an aggregate variable on the transaction date, set it to maximum to get
the last ship date.
Filter again on the aggregate variable you created for older than a year or
whatever your looking for.

Patrick Winter


-----Original Message-----
From: Robert Christian [mailto:bobc@...]
Sent: Wednesday, August 27, 2003 3:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Fw: Report



----- Original Message -----
From: Robert Christian
To: vantage@yahoogroups.com
Sent: Tuesday, August 26, 2003 4:01 PM
Subject: Fw: Report



----- Original Message -----
From: Robert Christian
To: vantage@yahoogroups.com
Sent: Monday, August 25, 2003 8:34 AM
Subject: Report


Does anyone have a report that will show parts that have been ordered in
the past (by customers) and have not been ordered recently. We are trying to
keep an eye on all parts so we can ask customers why we have not received an
order
recently. Thanks for all your help Bob Christian Gasser & Sons Inc.


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


------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark Printer
at Myinks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->

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/