System Event: Payment Posted

When a payment is posted against an Invoice (or Bill) the system can now trigger a System Event.

Below is an example of how you might configure this system event:

The special "Iteration SQL" for this is:

SELECT TOP 1 p.Reference1 as PaymentReference, pm.Description as PaymentMethod, p.Amount as PaymentAmount, p.Posted as PaymentPosted
FROM dbo.Payment p
JOIN dbo.PaymentMethod pm on pm.PaymentMethodId = p.PaymentMethodId
WHERE p.BillId = @BillId
ORDER BY p.Posted DESC

If you have further questions about this please contact support.