[Sam Clark]

Hello,

Is there a report that would show items with no movement over the last x number of months?

Thanks,

Sam

——————————
Sam Clark
Business Systems Analyst
Team Technologies
Morristown TN
——————————

[Archive User]

Hello Sam,
I am not aware of any out of the box reports to do that analysis.  However, you could make a manual Excel report

Go to /Inventory management/Inquiries/Transactions/Transactions
Filter for timeframe
Download to Excel

Go to /Product information management/Common/Released products
Filter out services / non-stock items
Download to Excel

Do a VLOOKUP to get the list of items which have no transactions.

I hope that helps,
Dag III

——————————
Dag Calafell
mcaConnect
——————————
——————————————-

[Sam Clark]

Great minds think alike Dag!  That’s exactly what I did to get a quick report.  Now I’m hoping to get something where users can run it themselves from a menu.  I’m assuming I will have to get a custom report made.

Thanks,

Sam

——————————
Sam Clark
Business Systems Analyst
Team Technologies
Morristown TN
——————————
——————————————-

[Sherry Moran]

I created a couple views off of inventtrans summarizing transactions by item by company by site for selected transaction types (excluding things like cycle counts and movement transfers).  The couple of views is because I summarize 1 mo, 12 mo, 18 mo , 24 mo and 30 mo.  With this the cost accountants can use our reporting tool, link to the inventsum view I’ve created with the same summary or the released products table based on whichever window they want to use and pull what they want. 

——————————
Sherry Moran
SR Business Systems Analyst
Key Technology, Inc
Walla Walla WA
——————————
——————————————-