Stale inventory report advice

I have two Stale Inventory Reports. One shows what inventory we have on
hand that has had no part usage in the last 12 months and also is not called
upon by any Methods for Parts we are to manufacture that is on the backlog.
The second report shows inventory that we have on-hand that may have had
past transactions but have no future need on the backlog.

Both of these reports are in MS Access 2000 linked Via ODBC. If you like, I
can post them on our web page for you to download.

Thanks
Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Greg Gillette [mailto:ggillette@...]
Sent: Tuesday, April 23, 2002 2:51 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] stale inventory report advice


I am trying to put together a report that shows me the last significant date
a part in inventory has been moved. By significant date I mean any
PartTran.TranClass that = I,R, or S. On this report I need a total onhand
to calculate an extended cost. When I try to link the PartTran and PartBin
to do so, one way brings me the wrong date, the other brings me a wrong
total. Does anyone have anything like this they would be willing to share
or let me know where I am going wrong???

Thank You.
Greg





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/
I am trying to put together a report that shows me the last significant date
a part in inventory has been moved. By significant date I mean any
PartTran.TranClass that = I,R, or S. On this report I need a total onhand
to calculate an extended cost. When I try to link the PartTran and PartBin
to do so, one way brings me the wrong date, the other brings me a wrong
total. Does anyone have anything like this they would be willing to share
or let me know where I am going wrong???

Thank You.
Greg