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?
Page 1 / 1
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 E-mail address. We'll send you an e-mail with instructions to reset your password.