ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Inventory Pruning
http://www.istechforum.com/YaBB.pl?num=1374100676

Message started by AndyOB on 07/17/13 at 15:37:56

Title: Inventory Pruning
Post by AndyOB on 07/17/13 at 15:37:56

Inventory pruning...

Can someone recommend the easiest way to figure out what items (R type) in Evo haven't been accessed in 5 or more years? In other word's I'd like a report of items that have not been used in a long time are may be sitting on our warehouse taking up space.

Also would like a report of Finished Goods that have not been build in 5 or more years.

IN-O seems like a good starting place, but if I search the whole item dB the program seems to run out of memory constantly.

Any help, appreciated.

Title: Re: Inventory Pruning
Post by Lynn_Pantic on 07/17/13 at 15:49:25

IN-L-O is what you are looking for. Filter on "Active + Changed" and enter a date range of 7/1/09 through today for a list of all items with no transaction activity since 7/1/09.

Title: Re: Inventory Pruning
Post by AndyOB on 07/17/13 at 16:06:00

OK, only problem is I get an exception as soon as I select a form to print too.

Running 4/4/13 SP1 right now.

Edit: Was able to get it to run with the DBA version of the module. it's processing now.