Hi,
i'm trying to create a query that gives open qty.
suppose
in sales order
line item 1 100 --delivered -50 -balance is 50
line item 2 200 -not delivered -balance is 200
i've tried creating query using table combinations vbak/vbap ,likp/vbkp/vbrp , s001 /vbep/vbbe tables takenin
sales qty - delivery qty = open qty
But second line item is not getting picked in the query.-how to pick line item which is not at all delivered
Pl suggest