ON TIME DELIVERY REPORT
hI,
I'm creating otd report.
in sales order -sline tab cust requested delivery date is entered
difference between cust requested date - invoice date =otd
i'm using VBEP -EDATU & VBRK TABLES
But suppose in sales order 2 line items are there
item 1 not delivered
item 2 delivered/billed
when executing tthe query only item 2 is coming , item 1 is not coming
is there any other table/fileds i can use so that all items irrespective of delivered or not
can get picked up so that
say like
cust requested date billing date
item 1 1.1.08 -
item 2 1.1.08 1.1.08