I am trying to create a saved search on transactions that lists on the same line the transaction quantity ordered and the available quantity at a certain location A.
I set in the following way:
FILTER TAB - location = A
RESULT TAB - item: Location Available
- quantity
This search will create one line for each location (the filter doesn't work)
Then I tried:
FILTER TAB - Item: location = A
RESULT TAB - item: Location Available
- quantity
This search returns: "No Search Results Match Your Criteria"
However, when I check the transaction records, Available quantity (Location = A) and Ordered quantity are visible in the same line.
Has anyone found a way to extract this information in a saved search?