Robert,

This is very close but when I run it in my production system I only get back 2 records. The results I get back are the results where there is both QtyOnHand and SumQtyCommitTotal. I should see the ItemNo even if there is no QtyOnHand or if there is QtyOnHand and 0 SumQtyCommitTotal.

When I run the Inner Query for the ItemLedgerEntry and specify the item in a where clause I get back 8 records.

When I run the inner query for the SalesLine table I get back 2 records.

Is there a way I can insert a 0 SumQtyCommitTotal record in the SalesLine if a location exists in the ItemLedgerEntry table?