Quote from GasGiant on 03/06/09 at 10:47:58:Maybe I could help you build the query. What is it that you are looking for, exactly?
Just finished goods? What period of time?
Pulling a slice of the inventory transaction file (INVTXN) into Excel and making a pivot table for months might be the answer.
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.