@dave In your search, use the columns called

Location On Hand

,

Location On Order

. The

On Hand

and

On Order

columns are the totals across all locations