Skip to Content
0
Former Member
Sep 27, 2008 at 08:04 AM

open order -report

41 Views

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