Skip to Content
0
Former Member
May 01, 2014 at 08:59 AM

Recon Date getting Duplicated in Query

46 Views

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