Skip to Content
0
Former Member
Apr 19, 2010 at 07:52 AM

Approval for change Due date in AR invoice through Paymnet Term

71 Views

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!