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

started a topic almost 4 years ago

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. 


    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

2 people like this idea
Log in or Sign up to post a comment