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