Outstanding Qty by Week

Good day,   I am rephrasing my question form my previous post. I have three tables, Sales Table, Shipment Table, and Date Table.   What I needed to achieve is the outstanding qty by week.     ...