I can’t help feeling I am missing something really obvious in the reporting suite, but looking for a way of running a report that tells us the total value and count per SKU of what we have in stock for packaged beer, what we have sold but not yet shipped and as a result what we have available to sell.
I can see the stock valuation report that gives us the cost of stock items and any in production or completed batches. And we have the stock take that tells us what we physically have on site, alongside the product by beer tab that gives available in stock and what is on order, and the line item standard price.
Any way these can be combined so we can see where the total value is sitting at any one point? Helps to understand the value of sales waiting to be shipped v paid too?
Thanks,