# More powerful reports **URL:** \ **Category:** Ideas & feature requests\ **Tags:** idea-completed\ **Created:** [19 March 2021 14:29 UTC](https://community.breww.com/t/more-powerful-reports/109 "2021-03-19T14:29:34Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![lewis-hill](https://community.breww.com/user_avatar/community.breww.com/lewis-hill/32/139_2.png) [@lewis-hill](https://community.breww.com/u/lewis-hill)\ **Post date:** [19 March 2021 14:29 UTC](https://community.breww.com/t/more-powerful-reports/109/1 "2021-03-19T14:29:34Z")
Hello, What are the chances of getting some more powerful reports that can be easily generated. An example one for us that would be used every day - a report showing available beers that is filterable to only show (for example) smallpack (bottles, cans) at Site1 or only draft beers (kegs, casks) at Site1. So that when a bottle shop asks what stock is available we can quickly create a PDF showing them what’s available. If they’re prices were shown too, even better. Could go into a lot more detail if the feature could be worked on? Cheers, Lewis. ---
**Author:** ![lewis-hill](https://community.breww.com/user_avatar/community.breww.com/lewis-hill/32/139_2.png) [@lewis-hill](https://community.breww.com/u/lewis-hill)\ **Post date:** [19 March 2021 14:36 UTC](https://community.breww.com/t/more-powerful-reports/109/2 "2021-03-19T14:36:00Z")
I think the bones of the report is here - [https://breww.com/reporting/packaged-beer-stock/](https://breww.com/reporting/packaged-beer-stock/) Just needs some options to filter/sort it. I always like beer lists in ascended ABV order, too! ---
**Author:** ![lewis-hill](https://community.breww.com/user_avatar/community.breww.com/lewis-hill/32/139_2.png) [@lewis-hill](https://community.breww.com/u/lewis-hill)\ **Post date:** [19 May 2021 20:06 UTC](https://community.breww.com/t/more-powerful-reports/109/3 "2021-05-19T20:06:06Z")
Further to the above, now we’re back to supplying pubs again, this report would be handier than ever. Being able to see on what screen what our current “9g firkin” stock is; or see on one screen what our 440ml can stock is, would be really helpful. Is it possible to create a feature like this? ---
**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:** [20 May 2021 09:10 UTC](https://community.breww.com/t/more-powerful-reports/109/4 "2021-05-20T09:10:22Z")
Hi Lewis, Thanks for following up, and sorry for the lack of reply before! This must have slipped through the net 🤭 We’ve actually just recently launched a new stock availability report which is quite similar to what you’re suggesting. It can be found at `Products > Tools > Available products report` (or [click here](https://breww.com/reporting/products-available/)). Could you have a look at this and let us know what you think? We’re totally happy to look at amendments to make it better if this is a good starting point for you? Most modern web browsers support printing to PDF, so if you need it as a PDF, you can try the print option and then saving it as a PDF. Cheers, Luke ---
**Author:** ![lewis-hill](https://community.breww.com/user_avatar/community.breww.com/lewis-hill/32/139_2.png) [@lewis-hill](https://community.breww.com/u/lewis-hill)\ **Post date:** [20 May 2021 09:29 UTC](https://community.breww.com/t/more-powerful-reports/109/5 "2021-05-20T09:29:02Z")
Hi Luke, Thanks for this. Would you be able to make this report filterable by container type? So we could just get a list of firkins or 30 L KeyKegs or 500ml bottles, etc? Thanks again! Lewis ---
**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:** [20 May 2021 09:43 UTC](https://community.breww.com/t/more-powerful-reports/109/6 "2021-05-20T09:43:11Z")
Hi Lewis, Yes, I think a container type filter here should be possible. We’ll look to get this added in for you soon. I’ll let you know when it’s ready to use. Thanks, Luke ---
**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:** [28 May 2021 14:20 UTC](https://community.breww.com/t/more-powerful-reports/109/7 "2021-05-28T14:20:58Z")
Hi Lewis, You should see a new container type filter drop-down box in the top-right of this report now. I hope this helps and have a great weekend! Luke ---
**Author:** ![lewis-hill](https://community.breww.com/user_avatar/community.breww.com/lewis-hill/32/139_2.png) [@lewis-hill](https://community.breww.com/u/lewis-hill)\ **Post date:** [29 May 2021 08:17 UTC](https://community.breww.com/t/more-powerful-reports/109/8 "2021-05-29T08:17:44Z")
This is fantastic, thank you! ---
**Author:** ![cornel-ianculovici](https://community.breww.com/user_avatar/community.breww.com/cornel-ianculovici/32/306_2.png) [@cornel-ianculovici](https://community.breww.com/u/cornel-ianculovici)\ **Post date:** [27 October 2021 04:41 UTC](https://community.breww.com/t/more-powerful-reports/109/9 "2021-10-27T04:41:34Z")
Is there a way to run a report like this but select a past date? I’d like to be able to quickly see what product stock we had on a given date (say on Monday of the previous week) without doing a full stocktake or anything like that. ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [27 October 2021 08:23 UTC](https://community.breww.com/t/more-powerful-reports/109/10 "2021-10-27T08:23:31Z")
Hi Cornel, Not as such, but there are a few things you could do which might be helpful. You can see the stock of every product, per batch, on the first of every month, by going to Reporting \> Pre-built Production & inventory reports \> Stock valuation, then clicking the eye icon on the month you’d like to view. However, we don’t really store this data in a way where you could choose a specific date. If it’s just a couple of products you’re interested in, you could use the product log to work out the stock on any given day. Go to a product, then click on the ‘Log’ tab at the bottom, then check the ‘Qty afterwards’ column on the relevant date. Obviously this would be a bit time-consuming if you’re hoping to see the stock of many products, but may be helpful. Thanks, Matt ---
**Author:** ![cornel-ianculovici](https://community.breww.com/user_avatar/community.breww.com/cornel-ianculovici/32/306_2.png) [@cornel-ianculovici](https://community.breww.com/u/cornel-ianculovici)\ **Post date:** [27 October 2021 09:24 UTC](https://community.breww.com/t/more-powerful-reports/109/11 "2021-10-27T09:24:10Z")
Would it be possible to build a report that pulls the most recent “qty after” value from each product on a chosen date to generate a “product stock by date” report? This would be handy for me, but might not be all that useful to other users though. One other application for this would be doing EOFY stocktakes and not having to do it exactly on the 30/6 (i.e. you could do the physical counting of stock over a couple of days, and then check it against Breww later even while stock is being sold out of Breww in the meantime). ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [27 October 2021 14:50 UTC](https://community.breww.com/t/more-powerful-reports/109/12 "2021-10-27T14:50:34Z")
I’ll have a chat with the rest of the team about this, to see what we could do. If others would find a “product stock by date” report helpful, do let us know by liking this comment or responding below. Cheers, Matt ---
**Author:** ![lewis-hill](https://community.breww.com/user_avatar/community.breww.com/lewis-hill/32/139_2.png) [@lewis-hill](https://community.breww.com/u/lewis-hill)\ **Post date:** [7 January 2022 15:52 UTC](https://community.breww.com/t/more-powerful-reports/109/13 "2022-01-07T15:52:24Z")
Hello, Was happy to see the addition of customer price books to the “available products” report this week, very useful for us. Is there scope to add more features to this screen as well? Some ideas: - allow multiple container types, e.g. firkins and kegs - grouping by container type - ordering the list by ABV, price, etc. - export to PDF [with option to include short brand description] - formatted Excel reports etc. Can add more detail if anything like this could be done. Thanks, Lewis. ---
**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:** [11 January 2022 16:57 UTC](https://community.breww.com/t/more-powerful-reports/109/14 "2022-01-11T16:57:30Z")
Thanks, Lewis, this is useful information. There’s another post about similar ideas, so I’m just linking the two threads together, so we have all the information available when we get to this task. > [@Price list improvements](https://community.breww.com/t/add-filter-sorting-options-to-products-available-report-customer-price-lists/652): > > Thanks for adding this feature. it is already really useful. Got some feature requests: Filtering/sorting on type (in a seperate column in a sheet) for export customers the option to mention plato the integration of multiple discount rates in a pricebook really would benefit this feature as well. if the customer receives “excise duty free pricing”, show these prices Lesser importance but of use if you would ever want to be able to generate a list that you could communicate directly to a custo… There looks to be quite a bit of support for this, which is great. ---
**Author:** ![tim-hughes](https://community.breww.com/user_avatar/community.breww.com/tim-hughes/32/58_2.png) [@tim-hughes](https://community.breww.com/u/tim-hughes)\ **Post date:** [13 January 2022 14:01 UTC](https://community.breww.com/t/more-powerful-reports/109/15 "2022-01-13T14:01:00Z")
Hi I would find it very useful, if you can’t do it already, for the sales revenue/litres by beer report (and probably others) to be able to select all cask beer (instead of just firkin, pin or kilderkin) so I don’t have to run 3 different reports and combine all the data. Thanks Tim ---
**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:** [26 May 2022 17:04 UTC](https://community.breww.com/t/more-powerful-reports/109/16 "2022-05-26T17:04:57Z")