# Stock Packaged vs Stock Sold

**URL:** <https://community.breww.com/t/stock-packaged-vs-stock-sold/2111>\
**Category:** Ideas & feature requests\
**Created:** [10 February 2023 16:04 UTC](https://community.breww.com/t/stock-packaged-vs-stock-sold/2111 "2023-02-10T16:04:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![katy-bartlett](https://community.breww.com/user_avatar/community.breww.com/katy-bartlett/32/1165_2.png) [@katy-bartlett](https://community.breww.com/u/katy-bartlett)\
**Post date:** [10 February 2023 16:04 UTC](https://community.breww.com/t/stock-packaged-vs-stock-sold/2111/1 "2023-02-10T16:04:19Z")

</div>

It would be helpful if there was a report/a clear way of seeing the total of each product that has been racked and how much has been sold. For duty purposes and just as a way that any stock discrepancies balance out when the product has sold out.

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [16 February 2023 09:32 UTC](https://community.breww.com/t/stock-packaged-vs-stock-sold/2111/2 "2023-02-16T09:32:08Z")

</div>

Thanks Katy. There are a number of pre-built sales and packaging related reports, as well as the [Custom Report Builder and Raw Data Explorer](https://community.breww.com/t/reporting-via-the-aggregate-report-builder-and-raw-data-explorer/559) reports for **Beer produced (rackings)** and **Products sold (order lines)** which should be able to get you this data.

The Custom Report Builder gives you aggregates (such as totals by month) and Raw Data Explorer gives you all the raw data so you can manipulate it in Excel.

If these don’t cover what you need, can you let us know what specifically is missing and we can look at exposing this for you? Thank you.

---

<div class="post-metadata">

**Author:** ![peter-burger](https://community.breww.com/user_avatar/community.breww.com/peter-burger/32/1805_2.png) [@peter-burger](https://community.breww.com/u/peter-burger)\
**Post date:** [17 May 2023 08:43 UTC](https://community.breww.com/t/stock-packaged-vs-stock-sold/2111/3 "2023-05-17T08:43:28Z")

</div>

I’ve been looking through the raw data explorer for beer produced (rackings) and am trying to find the field that shows the number of containers that have been filled for each product. I can see a total volume, but what I’m looking for is a count. For example, I can see that on 29 March we racked 7.62hl of one beer into 0.005hl smallpack, but I want to see that we racked 1524 units of 0.005hl smallpack instead.

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [17 May 2023 09:45 UTC](https://community.breww.com/t/stock-packaged-vs-stock-sold/2111/4 "2023-05-17T09:45:00Z")

</div>

@peter-burger have you seen the **Initial product by batch** report (in the **Pre-built Production & inventory reports** section)? This should show you what was packaged both in terms of volumes and number of products.
