Skip to Content
0
Former Member
Jan 16, 2012 at 08:41 PM

Approval Templates

32 Views

Im trying to Create an Approval template so that all AR invoice created with a negative item row would need Approval

Using the query below, all invoices now require approval

SELECT distinct 'TRUE' FROM INV1 T0 WHERE T0.[Quantity] < '0'

Example

Row 1 10 of Item A

Row 2 -1 of Item B

This would require an approval