Can I create a saved search to identify available inventory at 2 separate inventory locations in one search?

Hi,

Are you only wanting to look at two locations or is this heading in the direction of wanting to do something more general?

Thanks,

Chris

I just need to look at these 2 locations…  I’ve tried a few different formulas, nothing working…

not sure how complex your rules are,   hopefully this helps

use a numeric formula on criteria where value =1 ……… when the “when” statements are =1 then  your rules are met.

case when {inventorylocation} like ‘%Quiet%’ and {locationquantityavailable} =0 then 1 when {inventorylocation} like ‘%Beac%’ and {locationquantityavailable} >1 then 1 else 0 end

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

THIS WORKED!!! YOU ARE AMAZING! Thank you so very much Chris….