Hi,
Need some help with an AP Invoice approval query.
Customer wants all invoices for the same amount and business partner within the same year to be routed for approval.
Using the below but transactions still going through.
select distinct 'true' from opch where $[4.0.0] = [opch.cardcode] and $[29.0.0] = [opch.doctotal] and (DATEDIFF(Month,OPCH.DocDate,Getdate())<=12)
Thanks