Start a new topic

Report for - average sales, current stock and stock on order

I would love a to have a report that shows the average sales (last 3 months or something), Total stock (Current stock on hand, and stock ordered) in a single report to easily see how many month's worth of stock we have (Total stock/Average sales) to see what needs to be re-ordered at a quick glance.


2 people like this idea

Instead of Average Sales, I think Movement Out would be better. 

Because


Sales - only considers the qty sold


Movement Out - considers: (1) qty sold, (2) qty transferred (warehouse transfer) (3) qty used in production



Maybe have the option to view either Sales or Movement out as my major metric for re-ordering is what has been sold and not just what gets moved around between locations. i.e. if I move stock between Sydney and Melbourne it is most likely because the stock is not selling in Sydney, so no point re-ordering that product in Sydney.

 

Login or Signup to post a comment