Hi all!
I try to query for approval with AR invoice change Due date in AR invoice through Payment Term.
SELECT Distinct 'True' FROM OCTG T0 INNER JOIN OINV T1 ON T0.GroupNum = T1.GroupNum WHERE dateadd(day, T0.[ExtraDays],T1.[TaxDate])<> T1.[DocDueDate] and T1.[CardCode] =$[$4.0.0] and T1.[Docnum]=$[T1.[Docnum]
I think we can not combine 2 variable for this form (
T1.[CardCode] =$[$4.0.0] and T1.[Docnum]=$[T1.Docnum]
)
Could you help me!
Thanks!