Backorders with stock at another warehouse

I can’t find anything built-in (maybe I missed something in the Supply Allocation feature?). However I have a saved search for this use case.
There may be more elegant solutions out there, but I can’t find them 😉

The basic criteria filters you need are:

• • sales orders with back ordered quantities (

    {quantity}-NVL({quantitycommitted},0)-NVL({quantityshiprecv},0)

    is greater than 0)

• • inventory locations that have available stock (

    CASE WHEN {location} != {item.inventorylocation} THEN {item.locationquantityavailable} ELSE 0 END

    is greater than 0)

Additionally I would filter for: Commit (status) is any of Available or Complete Qty; Status is any of (open statuses).
You also may need to consider additional filters if you have a one-world account (not sure if this is what you’re implying by “two warhouse and multiple store locations”)

As for search results, I would recommend a summary-level search to group all of your fulfillable locations together. Additionally I have these two results columns that may help:

• • “Total available at other location(s)”, Formula (Numeric), summary type: Sum
    

    CASE WHEN {location} != {item.inventorylocation} THEN {item.locationquantityavailable} ELSE 0 END

• • “Available per location”, Formula (Text), summary type: Minimum
    

    LISTAGG({item.inventorylocation}||': '||CASE WHEN {location} != {item.inventorylocation} THEN {item.locationquantityavailable} ELSE 0 END, '<br>') WITHIN GROUP (ORDER BY {item.inventorylocation})

    • • this produces text like:
        Loc1: 50
        Loc2: 65