Need Inventory Report

system · October 21, 2002, 10:32am

Yup, I suppose so. Sorry about the closed mind set. Part w/o transaction
is a very rare critter in our MTO environment.
-Todd C.

-----Original Message-----
From: Fredy Venczel [mailto:fvenczel@...]
Sent: Monday, October 21, 2002 8:45 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Need Inventory Report

Todd I don't think you'll get records for the parts with no transactions at
all. If I have a part which is over a year old but there has been no
activity at all it won't show on the report but I believe Sandra wants to
see such a part.

Fredy Venczel

-----Original Message-----
From: Todd Caughey [SMTP:caugheyt@...]
Sent: October 21, 2002 09:34
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Need Inventory Report

In RB I would do it by reporting at a group level (such as Part)
with the
transactions are sorted by date/ascending then at the group footer
the value
for transaction date will be the last one read. You could then
inhibit
printing the group band with a test on the date. Totaling for
selected
items is a bit trickier because you have to selectively decide which
values
to aggregate or not. I think Crystal would be a similar process.
-Todd C.

-----Original Message-----
From: Sandra Morse [mailto:smorse@...]
Sent: Sunday, October 20, 2002 12:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Need Inventory Report

I have been asked to create a report showing parts that have had no
activity
for over a certain date range... like one year, etc. I can't
remember how
to get the last date used on the transaction file... I remember how
to do it
in an export but not report builder or crystal. I am on 4.0 with
Crystal 7.
Anybody have a report like this? I would really appreciate this!

Thanks!
Sandy Morse
BVR Aero Precision Corporation

Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071

>

<
http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071

>
>

83:HM/A=1278098/R=0/*
http://www.verisign.com/cgi-bin/go.cgi?a=b3089010792061
<http://www.verisign.com/cgi-bin/go.cgi?a=b3089010792061>
< http://www.verisign.com/cgi-bin/go.cgi?a=b3089010792061
<http://www.verisign.com/cgi-bin/go.cgi?a=b3089010792061> >
6000>

<
http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmai
<http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmai

>

<
http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmai
<http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmai

>
>

system · October 20, 2002, 1:52pm

I have been asked to create a report showing parts that have had no activity
for over a certain date range... like one year, etc. I can't remember how
to get the last date used on the transaction file... I remember how to do it
in an export but not report builder or crystal. I am on 4.0 with Crystal 7.
Anybody have a report like this? I would really appreciate this!

Thanks!
Sandy Morse
BVR Aero Precision Corporation

system · October 21, 2002, 9:33am

In RB I would do it by reporting at a group level (such as Part) with the
transactions are sorted by date/ascending then at the group footer the value
for transaction date will be the last one read. You could then inhibit
printing the group band with a test on the date. Totaling for selected
items is a bit trickier because you have to selectively decide which values
to aggregate or not. I think Crystal would be a similar process.
-Todd C.

-----Original Message-----
From: Sandra Morse [mailto:smorse@...]
Sent: Sunday, October 20, 2002 12:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Need Inventory Report

I have been asked to create a report showing parts that have had no activity
for over a certain date range... like one year, etc. I can't remember how
to get the last date used on the transaction file... I remember how to do it
in an export but not report builder or crystal. I am on 4.0 with Crystal 7.
Anybody have a report like this? I would really appreciate this!

Thanks!
Sandy Morse
BVR Aero Precision Corporation

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071
83:HM/A=1278098/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b3089010792061
6000>

<http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmai
l/S=:HM/A=1278098/rand=488407072>

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/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

system · October 21, 2002, 9:45am

Todd I don't think you'll get records for the parts with no transactions at
all. If I have a part which is over a year old but there has been no
activity at all it won't show on the report but I believe Sandra wants to
see such a part.

Fredy Venczel

-----Original Message-----
From: Todd Caughey [SMTP:caugheyt@...]
Sent: October 21, 2002 09:34
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Need Inventory Report

In RB I would do it by reporting at a group level (such as Part)
with the
transactions are sorted by date/ascending then at the group footer
the value
for transaction date will be the last one read. You could then
inhibit
printing the group band with a test on the date. Totaling for
selected
items is a bit trickier because you have to selectively decide which
values
to aggregate or not. I think Crystal would be a similar process.
-Todd C.

-----Original Message-----
From: Sandra Morse [mailto:smorse@...]
Sent: Sunday, October 20, 2002 12:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Need Inventory Report

I have been asked to create a report showing parts that have had no
activity
for over a certain date range... like one year, etc. I can't
remember how
to get the last date used on the transaction file... I remember how
to do it
in an export but not report builder or crystal. I am on 4.0 with
Crystal 7.
Anybody have a report like this? I would really appreciate this!

Thanks!
Sandy Morse
BVR Aero Precision Corporation

Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071

>

83:HM/A=1278098/R=0/*
http://www.verisign.com/cgi-bin/go.cgi?a=b3089010792061
<http://www.verisign.com/cgi-bin/go.cgi?a=b3089010792061>
6000>

<
http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmai
<http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmai

>

l/S=:HM/A=1278098/rand=488407072>

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/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/> > .

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

Yahoo! Groups Sponsor
ADVERTISEMENT

http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=170500718
3:HM/A=1282638/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b31550107926004
000
<http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071
83:HM/A=1282638/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b3155010792600
4000>

http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmail
/S=:HM/A=1282638/rand=725949698
<http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmai
l/S=:HM/A=1282638/rand=725949698>

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/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

system · October 21, 2002, 9:54am

At 12:23 PM 10/20/2002 -0500, you wrote:

>I have been asked to create a report showing parts that have had no
>activity for over a certain date range... like one year, etc. I can't
>remember how to get the last date used on the transaction file... I
>remember how to do it

There are a couple on our Yahoo files page (link should be at bottom of
message) last time I looked. Think there was a Crystal report and a couple
R.B. ones that might be similar to what you want.

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338

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

Topic		Replies	Views
Obsolete or slow moving inventory report Yahoo Archive	3	1865	March 24, 2001
Report Builder - report of last purchase date for vendors Yahoo Archive	4	509	July 14, 2004
Aged Inventory Report Yahoo Archive	6	579	July 20, 2000
Obsolete Stock Blank Title 101579 Yahoo Archive	6	407	June 21, 2011
Report Yahoo Archive	30	1587	March 3, 2008

Need Inventory Report

Related Topics