Skip to Content
0
Former Member
Apr 21, 2010 at 11:48 AM

AP Invoice Approval

39 Views

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