Inventory - Annual usage

Question

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!

Genreve_S · Answer

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