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