OK, Your right I didn't have

left join SumSalesQtyCommit as sot

On sot.[No.] = ile.[Item No.] and sot.[Location Code] = ile.[Location Code]

I had

left join SumSalesQtyCommit as sot

On sot.[No.] = ile.[Item No.]

where sot.[Location Code] = ile.[Location Code]

group by ile.[Item No.], ile.[Location Code], , ile.QtyOnHand, sot.QtyCommit

I think this wraps it up but I'll test more items in the morning.

thanks for being persistent micky!