Skip to Content
0
Former Member
Jun 07, 2011 at 09:45 AM

Query Help

37 Views

Experts,

select T0.DocEntry, T0.DocNum, T1.ItemCode

,T1.Dscription, T1.Quantity,

T2.ItemCode, T2.Quantity

from OINV T0 inner join INV1 T1 on T0.DocEntry = T1.Docentry where

T0.DocNum = '12105744' inner join ODLN T2 on T1.BaseEntry = T2.

what condition to give to complete this query with "Return " too

Means details of one item in terms of AR invoice, Delivery and return

Plz help