Query for Shipped / Closed Order Lines on a Customer level
example:
Order has Order 1 - 100 lines for $5 each. We pick first 10 lines to ship and then place order back on Hold to prevent further shipments.
Order 2 - 5 lines for $12 each. We pick first 2 lines and then back order back on Hold.
We need to indentify how much from that order we have shipped - a report (or query) that would show us 10 lines on first order for $5 each + 2 lines for second order for $12 each.