Does anyone have or knows how to create a slow shipping/slow moving list, report in Crystal Reports for DBA Classic or Evo?

Quote from GasGiant on 03/02/09 at 15:11:50:

We would like a report that would show how long it has been since an item was shipped.
 
Say we want to know about items that haven’t shipped in 6 months. If the report showed items that have not shipped in 6 months or more then we would know to check the status of these items with our customer. ( Perhaps they are low volume or they were killed & we weren’t informed). We would then be able to check through the inventory for each item & be able to dispose of it as necessary.

Quote from GasGiant on 03/05/09 at 06:10:56:

 
 
Thank you...
 
 
It's far from what I am looking for...
 
if I could pull it apart and use the data in Crystal reports... that would be the key.
 
I know it can be done, I'll just have to figure it out.

A couple of years ago I did something similar for our parts inventory. I ran a usage report back 18 months, exported it as a text file and imported it with Excel. Any part that had 0 transactions for that period was pulled from inventory, its value written off, and the parts bagged and moved to a storage location.
 
The reason I didn't just use the report as printed from Evo is that I wanted to order it by usage instead of by part number. If that is not important to you, then you could just use the usage report as is.
 
The report is IN-P. If you just want finished goods, for example, you'd enter the time period, leave item codes blank, and set the item types to F.

Quote from GasGiant on 03/06/09 at 10:47:58:

 
 
That would be great!  
 
Not just finished goods, but inventory for finished goods that has been sitting longer that 6 mos, 1 year, 1 1/2 year.
 
That way if something gets canceled or killed, the items to build it are not sitting here forever, if we can catch then soon enough, we can send them back.
 
and yes, either Crystal Reports or Excel
 
if that wouldn't be too difficult, I would greatly appreciate it. Something like this would take me months, whereas you could probably do it in your sleep.

Hmmm  ... When I try and run IN-P it indicates that I am not one of the 'Special' people allowed to use this report.  
(It runs as a TRIAL VERSION)

??? Don't even remember purchasing it    
 
Well, it works like a charm. $50 is cheap considering the time it would take to recreate the same functionality with an external program.