We have a saved search that shows us a list of all items with the criteria type "Assembly/Bill of Materials".
One of our fields on the Results tab is "Inventory Detail : Location". We also have a filter for "Inventory Detail : Location" so we can filter to see which items are at each location. My issue is that the result on this location field is inconsistent. Sometimes the result on the saved search is a location that the item was at previously where there are 0 on hand, and not the current location at which there is 1 on hand. Sometimes the location is correct.
All of our Assembly/Bill of Materials items are unique items, therefore we only ever have 1 on hand max. However the saved search must include all items whether there are 0 or 1 on hand as we need to see what items we will soon be picking up for Sales visibility. Any items that we have not picked up would not be expected to have a location listed as they have not yet been received through a PO.
I added a text formula in the Results tab that will show us the correct location on the saved search, but our Inventory Detail : Location filter is still incorrect of course. Is it possible to filter the location from the formula I created rather than by "Inventory Detail : Location"?
Here is the formula: CASE WHEN {locationquantityonhand} > 0 THEN {inventorylocation} END
I have included photos as well.
Thanks in advance.
Criteria
Results
Filters
Example of Different Locations Listed for One Item
Item shows on Dropdown for "Main" Location
Same Item Shows on Dropdown for "My Guys" Location