DA No Misssing

26 Views

Hi All,

please suggested me how to get the Order number(DA No)

select t0.CardName,t0.NumAtCard,t0.[U_DEST] ,t4.SlpName as 'Sales Reference',T0.[U_NearBookPoint],t0.[Address], t0.[Address2],t5.[Cellolar] as 'Contact Ph.',t0.[U_PHONENO],t1.[Dscription], t1.[Quantity],t3.DocNum as 'DA no',t0.DocNum as 'Invoice No',t0.[DocDate] as 'Invoice Date', t0.[DocTotal] as 'Invoice Total', t0.[U_TPNAME], t0.[U_TNO],

t0.[U_DNAME], t0.[U_CNO], t0.[U_VTYPE], t0.[U_LTYPE], t0.[U_LRNO], t0.[U_LRDT] from OINV t0 inner join INV1 t1 on t0.DocEntry=t1.DocEntry left join dln1 t6 on t6.TrgetEntry=t1.BaseEntry left join RDR1 t2 on t2.TrgetEntry=t6.BaseEntry left join ORDR t3 on t3.DocEntry=t2.DocEntry left join oslp t4 on t4.SlpCode=t0.SlpCode LEFT join OCPR t5 on t5.CntctCode=t0.CntctCode where t1.TrgetEntry is null and t0.DocDate='2014/05/26'

thanks,

Pratap