# Filter Sales based on Fulfilment Not required

**URL:** <https://community.breww.com/t/filter-sales-based-on-fulfilment-not-required/2226>\
**Category:** Help & advice\
**Created:** [9 March 2023 11:23 UTC](https://community.breww.com/t/filter-sales-based-on-fulfilment-not-required/2226 "2023-03-09T11:23:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ben-harrison](https://community.breww.com/user_avatar/community.breww.com/ben-harrison/32/634_2.png) [@ben-harrison](https://community.breww.com/u/ben-harrison)\
**Post date:** [9 March 2023 11:23 UTC](https://community.breww.com/t/filter-sales-based-on-fulfilment-not-required/2226/1 "2023-03-09T11:23:40Z")

</div>

Im trying to clear my view of the sales screen. I can use the Undelivered orders filter, which is pretty much what I want, but that still shows “Fulfilment Not required” orders in the list. And we actually have quite a lot of these.

I have tried going through all the filter options, but I can’t find a way to specifically filter out the Not Required orders.

Any ideas?

---

<div class="post-metadata">

**Author:** ![connor-fry](https://community.breww.com/user_avatar/community.breww.com/connor-fry/32/1365_2.png) [@connor-fry](https://community.breww.com/u/connor-fry)\
**Post date:** [9 March 2023 12:51 UTC](https://community.breww.com/t/filter-sales-based-on-fulfilment-not-required/2226/2 "2023-03-09T12:51:03Z")

</div>

Hi Ben,

Thanks for posting here on the community! Taking a look, this was not actually a filter option available on the sales page. We have, however, just made a new update live for you, which will allow you to do this. I would suggest going to your Sales page and choosing the undelivered orders filter option, which will populate the BrewwQL field. If you add to the end of the BrewwQL statement: **and fulfillment\_required = True** , you can then hit save to overwrite the undelivered orders filter to filter out orders which do not require fulfilment for you automatically.

---

<div class="post-metadata">

**Author:** ![ben-harrison](https://community.breww.com/user_avatar/community.breww.com/ben-harrison/32/634_2.png) [@ben-harrison](https://community.breww.com/u/ben-harrison)\
**Post date:** [9 March 2023 13:16 UTC](https://community.breww.com/t/filter-sales-based-on-fulfilment-not-required/2226/3 "2023-03-09T13:16:32Z")

</div>

Perfect - Many thanks!