# Reporting on batches approaching BBE **URL:** \ **Category:** Ideas & feature requests\ **Tags:** reporting, idea-completed\ **Created:** [23 February 2022 12:44 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857 "2022-02-23T12:44:46Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![hazel-meehan](https://community.breww.com/user_avatar/community.breww.com/hazel-meehan/32/303_2.png) [@hazel-meehan](https://community.breww.com/u/hazel-meehan)\ **Post date:** [23 February 2022 12:44 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/1 "2022-02-23T12:44:46Z")
Is there a way to produce a report on beer batches by BBE date? This would help us manage stock rotation and reduce wastage by flagging batches nearest BBE. (I realise stock allocation for sales is done on a FIFO basis but I’m thinking more about single batches that haven’t sold through). ---
**Author:** ![jon-kyme](https://community.breww.com/user_avatar/community.breww.com/jon-kyme/32/823_2.png) [@jon-kyme](https://community.breww.com/u/jon-kyme)\ **Post date:** [15 September 2022 11:02 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/2 "2022-09-15T11:02:21Z")
Needed. Otherwise I’m going to have to send the lad clambering on the racking to check BBEs ---
**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 September 2022 10:53 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/3 "2022-09-26T10:53:07Z")
Thanks, I’m merging in below this another related thread so that the votes get combined 👍 ---
**Author:** ![alex-hamilton-jones](https://community.breww.com/user_avatar/community.breww.com/alex-hamilton-jones/32/719_2.png) [@alex-hamilton-jones](https://community.breww.com/u/alex-hamilton-jones)\ **Post date:** [14 September 2022 14:35 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/4 "2022-09-14T14:35:42Z")
Hi, I can’t see anything obvious that allows me to do this but I’d like to be able to run a report that will tell me what quantity of what batch of finished goods we have in stock is going out of date next month, the month after, etc etc. Ideally this can be set up as a weekly/monthly auto-emailed report that says ‘you have 100 cases of this expiring this month, 100 kegs of this the month after’ that sort of thing. Cheers ---
**Author:** ![jon-kyme](https://community.breww.com/user_avatar/community.breww.com/jon-kyme/32/823_2.png) [@jon-kyme](https://community.breww.com/u/jon-kyme)\ **Post date:** [15 September 2022 11:31 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/5 "2022-09-15T11:31:17Z")
I couldn’t find a way to do this either. There’s a related FR, you could vote on it: > [@Reporting on batches approaching BBE](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/3): > > Thanks, I’m merging in below this another related thread so that the votes get combined +1 ---
**Author:** ![alex-hamilton-jones](https://community.breww.com/user_avatar/community.breww.com/alex-hamilton-jones/32/719_2.png) [@alex-hamilton-jones](https://community.breww.com/u/alex-hamilton-jones)\ **Post date:** [15 September 2022 11:43 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/6 "2022-09-15T11:43:18Z")
Great thank you, voted ---
**Author:** ![jon-kyme](https://community.breww.com/user_avatar/community.breww.com/jon-kyme/32/823_2.png) [@jon-kyme](https://community.breww.com/u/jon-kyme)\ **Post date:** [9 November 2022 10:32 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/8 "2022-11-09T10:32:51Z")
For a start, could the BBE be available in BrewwQL for “**Beer produced (rackings)** data explorer”? This might be all it takes ---
**Author:** ![max](https://community.breww.com/user_avatar/community.breww.com/max/32/232_2.png) [@max](https://community.breww.com/u/max)\ **Post date:** [29 November 2022 16:38 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/9 "2022-11-29T16:38:36Z")
This has now been added 🎉 > **[Added the 'Products expiring soon' report - Breww Breww updates](https://updates.breww.com/added-the-products-expiring-soon-report-YoZgI)** > > You can now view a breakdown of on-hand packaged beer stock that is expiring soon from Products -\> Actions & tools -\> Products exp... We hope this helps, but if you have any feedback, please let us know! @jon-kyme, does this mean you’d still be looking for that field on the “**Beer produced (rackings)** data explorer, or does this cover what you’d need too? ---
**Author:** ![jon-kyme](https://community.breww.com/user_avatar/community.breww.com/jon-kyme/32/823_2.png) [@jon-kyme](https://community.breww.com/u/jon-kyme)\ **Post date:** [30 November 2022 09:18 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/10 "2022-11-30T09:18:32Z")
Brilliant! No, tbh I think this is the only use I’d have for it. ---
**Author:** ![max](https://community.breww.com/user_avatar/community.breww.com/max/32/232_2.png) [@max](https://community.breww.com/u/max)\ **Post date:** [7 December 2022 09:19 UTC](https://community.breww.com/t/reporting-on-batches-approaching-bbe/857/11 "2022-12-07T09:19:02Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.