Welcome, Guest. Please Login.
05/18/24 at 13:36:08
News:
Home Help Search Login


Pages: 1
Send Topic Print
Inventory Pruning (Read 668 times)
AndyOB
Full Member
***


Humm...

Posts: 154
Gender: male
Inventory Pruning
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.
Back to top
 
 

--
Andy O'Brien of Nortra Cables, Inc.
Milpitas, CA
WWW AndyOB   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Inventory Pruning
Reply #1 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
AndyOB
Full Member
***


Humm...

Posts: 154
Gender: male
Re: Inventory Pruning
Reply #2 - 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.
Back to top
 
 

--
Andy O'Brien of Nortra Cables, Inc.
Milpitas, CA
WWW AndyOB   IP Logged
Pages: 1
Send Topic Print