Report to show item with no movement

To organize the items in the stock locations that exist in the warehouse, how can I know which item is most moved, not by quantity, but by the number of sales.

Is there a report to know which item is moved the most in order to define a physically closest stock location for the stock picker to collect the item?

Nothing comes to my mind immediately.

All the stock movement gets logged in “Stock Ledger Entry” doctype. You can probably build some dashboard based on this table using custom report or insights - Frappe Insights

This is very interesting idea though! cc: @rohit_w

Hi @xdlumertz:

A quick solution would be:

This will show how many times an item was sold.
Hope this helps.

1 Like