There's a crystal report in eGroups that does it called Aged Inventory or something like that (maybe Obsolete Inventory). But it takes a LONG time to run.

I did it by grouping by part, then using a maximum running total on the date and place the maxdate in the Group footer. Then you hide the details. Maybe there's a way to do it in RB.

RB doesn't work for us because we have multiple bins with the same part number, and you can't get an accurate OnHandQty out of RB in that situation.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Paul Siebers
To: 'vantage@yahoogroups.com'
Sent: Friday, April 13, 2001 11:20 AM
Subject: [Vantage] filtering on tran date

Hello all,

I am trying to figure out on how to build a filter on the PartTran.TranDate
field which will return only the last date a part in stock was used. I know
this came up a few months ago, but I can't find the related e-mails in the
archive.

TIA,

Paul Siebers

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

Yahoo! Groups Sponsor

Click Here to Find Software Faster

To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

Hello all,

I am trying to figure out on how to build a filter on the PartTran.TranDate
field which will return only the last date a part in stock was used. I know
this came up a few months ago, but I can't find the related e-mails in the
archive.

TIA,

Paul Siebers

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