HI All,
The below query is giving duplicate data as the recon date has multiple values.
Can someone please let me know how to correct this issue?
select distinct T0.CardCode,T0.CardName,t4.SeriesName,t4.BeginStr,RIGHT(T0.Docnum,6),T0.Docdate, T3.ReconDate as 'Clearing Date',T0.DocTotal from
OINV T0
inner JOin ITR1 T2 on T0.DocEntry = T2.SrcObjAbs
inner join OITR T3 on T2.ReconNum = T3.ReconNum
left join NNM1 T4 on T0.series = T4.Series
Thanks,
Joseph