Is there a way I can generate a report showing all the stock items which didn’t move last year? or what is the easiest way to achieve this result?
Availability of a report showing all the stock items which didn’t move during a specific period?
This topic has been closed for comments
Userlevel 2
+4
The easiest way would be to create a Quick Report that selects stock records that have a last_activity_date which is earlier than 365 days ago. Something like this:
select <the columns that you want to display>
from inventory_part_in_stock
where last_ACTIVITY_DATE < SYSDATE - 365
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.