Back Order Report without open orders

Hi ppl,

I have a Back Order report made for our Account Managers but I'm having trouble keeping open orders (Inventory Picks) off the report,

Attached is the report I've done so far but I need to not include Inventory Picks.
i.e. an order gets put through for 10 of Item A and 10 of Item B, but we only have 10 of Item A, so there would be a Inventory Pick for the 10 Item A's and the Back order report should have only the 10 of Item B,

I've tried filtering to not include the Original Sales Order from the Inventory Pick Table but that takes out the 10 of Item B.

please help
:?
-Bromy

• Back Order (Sales)1.xls