Forum Discussion

Brody_M's avatar
Brody_M
Experienced User
7 months ago

Inventory - Annual usage

Hi all, 


Trying to figure out the best way to produce a spreadsheet showing the below information. Is anyone able to assist? 

 

  • Product description
  • Annual sales
  • Current stock level


Thanks in advance! 

1 Reply

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    7 months ago

    Hi Brody_M​

     

    There is no single report in the system that will give you the product description, annual sales, and current stock levels. If you run the Sales Item Detail report, you’ll get the product descriptions and annual sales, but it won’t show you what you’ve got in stock.

     

    What I’d usually suggest is exporting the Sales Item Detail report to Excel, and then you can just pop the current stock numbers in yourself. It’s a bit of manual work, but it gets you there.

     

    If you want a better rundown of what each inventory report does, here's a handy link you can check out

     

    Regards,
    Genreve