In a Transaction saved search, how do I create a filter on the line-level Inventory Location field?

AI generated answer (using internal Slack threads):

In a Transaction saved search, to create a filter on the line-level Inventory Location field, you need to ensure that you have the filter for

Main Line: False

. This will allow you to access line item level fields. For the location field, you can use the

location

field. However, please note that this will give you the location at the line item level, not the main line location. Here is a simple step-by-step guide on how to do it: 1. Create a Transaction Search for the specific Sales Order you want to filter. 2. Select a single column in the Report: Location. 3. Run the Saved Search, it should return the Location at the item line level. If you want to display

{item.locationquantityavailable}

in a transaction search where there is a location filter and dynamically returns only the quantity in the selected location filter, you can use a formula. Here is an example:

CASE WHEN {location} = {item.inventorylocation} THEN {item.locationquantityonhand} else 0 END

This formula will return the quantity of any item in any location. You can modify and repeat for each quantity needed. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******