RE: Can I create a saved search to identify available inventory at 2 separate inventory locations in one search?
I need to create a saved search based on criteria at 2 different inventory locations.
Specifically identifying items available greater than or =1 at location 1 and inventory available = 0 at location 2. I am stuck and horrible with expressions
Hi again,
I’ve been having a think about this and I think this solution will get you exactly what you’re looking for.
Firstly, it’s important to understand that we’re always going to get two rows per item because we’re joining to two different locations and so we’re going to need to do some grouping.
After that, we’re looking for each row to meet a separate criterium and so we’ll give it a score of 1 if it does. Then, if we add up the scores, the items that have a score of 2 will have both lines matching our criteria.
To achieve this, you need to use summary criteria like this:
CASE WHEN {inventorylocation.internalid}=1 AND NVL({locationquantityavailable},0)>=1 THEN 1 WHEN {inventorylocation.internalid}=2 AND NVL({locationquantityavailable},0)=0 THEN 1 ELSE 0 END
Then in Results, choose a summary type of Group.
I hope that helps.
Thanks,
Chris
