Thanks. I will try this. I appreciate the response. I glimmer of
light in a dark tunnel.
Juliet
-----Original Message-----
From: Winter, Patrick [mailto:
pjw@...]
Sent: Thursday, August 15, 2002 3:12 PM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder : Obsolete Report
If you are using lot tracking try the LAST USED fields from the PART.LOT
table. But they would include STK-STK transactions which may not be
exactly
what your looking for. Most people are just looking for the last
shipment or
issue.
To get specific join to the parttran table, filter for the type of
transactions you want, create an aggregate variable set to MAX to get
the
latest trans action date. PREPASS the variable so you can use it in the
Report Builder filter such as > last trans date. Like I said it all
depends
if you want to include adjustments, DMR's, just moves in the stock room
STK-STK, etc...
Patrick
-----Original Message-----
From: Juliet Martin [mailto:
jmartin@...]
Sent: Thursday, August 15, 2002 3:03 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Report Builder : Obsolete Report
Has anyone made a report that shows items in inventory that haven't been
used for a certain period of time. I have tried editing some of the
reports off of the onelist and am not having much success. If you have
one to share I would appreciate it. If you have any tips I would love
them as well. Feel free to contact me off line. The problems I am
having are quite detailed.
Juliet
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/