Order vs Deliveries vs Pending with Back date query
I have a table Orders which contains the Orders and it's lines with QTY, I have separate table Invoices which contains the order reference delivery date and delivered qty. For 1 order line there are multiple deliveries of partial order qty.Problem I am facing is when i load with reference to both the tables than as soon as i select the delivery date order qty is limited to the orders that are referenced via those delivery dates.
I want to show the total Order QTY with Order date selection separately and in front the delivered qty to be shown based on the delivery date selection
Help will be highly appreciated or point towards relevant posts thanks.