# A report showing the expiry dates of guest beers (and other expiry-tracked stock item products)

**URL:** <https://community.breww.com/t/a-report-showing-the-expiry-dates-of-guest-beers-and-other-expiry-tracked-stock-item-products/2782>\
**Category:** Ideas & feature requests\
**Tags:** idea-completed\
**Created:** [13 July 2023 15:03 UTC](https://community.breww.com/t/a-report-showing-the-expiry-dates-of-guest-beers-and-other-expiry-tracked-stock-item-products/2782 "2023-07-13T15:03:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![paul-mellor](https://community.breww.com/user_avatar/community.breww.com/paul-mellor/32/1928_2.png) [@paul-mellor](https://community.breww.com/u/paul-mellor)\
**Post date:** [13 July 2023 15:03 UTC](https://community.breww.com/t/a-report-showing-the-expiry-dates-of-guest-beers-and-other-expiry-tracked-stock-item-products/2782/1 "2023-07-13T15:03:41Z")

</div>

> [@Any report which shows expiry dates](https://community.breww.com/t/any-report-which-shows-expiry-dates/2772/1):
>
> Hi  
> Having studiously entered all BB dates on our guest beers, I now have no way of seeing the dates at a glance. The “expiring soon” report returns no data ( presumably as this is only for our own beer)
> 
> reports are not very customisable, the inability to extract data from more than one table seems nonexistent.
> 
> Anyone any ideas on how i can keep track of my guest beer expiry dates?
> 
> thanks

Feature request based on the above thread

---

<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:** [13 July 2023 15:17 UTC](https://community.breww.com/t/a-report-showing-the-expiry-dates-of-guest-beers-and-other-expiry-tracked-stock-item-products/2782/2 "2023-07-13T15:17:58Z")

</div>

Thanks, Paul. We’ll see what we can do for you 👍

---

<div class="post-metadata">

**Author:** ![paul-mellor](https://community.breww.com/user_avatar/community.breww.com/paul-mellor/32/1928_2.png) [@paul-mellor](https://community.breww.com/u/paul-mellor)\
**Post date:** [14 July 2023 07:27 UTC](https://community.breww.com/t/a-report-showing-the-expiry-dates-of-guest-beers-and-other-expiry-tracked-stock-item-products/2782/3 "2023-07-14T07:27:20Z")

</div>

Thanks Luke, I am getting frustrated by the strictures of the pre-defined reports where an inability to cross link tables in the DB is a serious drawback and not what i was led to believe during the sales talk. It seems we can only add or subtract data from the same table. is there a way to create truly bespoke queries?

---

<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:** [14 July 2023 13:25 UTC](https://community.breww.com/t/a-report-showing-the-expiry-dates-of-guest-beers-and-other-expiry-tracked-stock-item-products/2782/4 "2023-07-14T13:25:47Z")

</div>

The [Raw data explorer and Custom report builder](https://community.breww.com/t/reporting-via-the-aggregate-report-builder-and-raw-data-explorer/559) both allow you to link data from lots of related datasets. It’s only the pre-built reports which are “fixed” to just the pre-built columns.

We’re working on further report improvements to expand this functionality even further, too. If there are any specific requests, please do let us know, as this sort of information is always useful to help us in building what is best.

---

<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:** [5 December 2024 10:53 UTC](https://community.breww.com/t/a-report-showing-the-expiry-dates-of-guest-beers-and-other-expiry-tracked-stock-item-products/2782/6 "2024-12-05T10:53:59Z")

</div>

I’m delighted to be able to let you know that we’ve just released a brand new **Stock items expiring soon** report 🎉

As guest beers are also stock-item-based, these will be included in this report. This report can be found at Reporting → Pre-build production & inventory reports → Stock items expiring soon.

We hope this is useful.

---

<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:** [12 December 2024 10:54 UTC](https://community.breww.com/t/a-report-showing-the-expiry-dates-of-guest-beers-and-other-expiry-tracked-stock-item-products/2782/7 "2024-12-12T10:54:03Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.