Scheduled Job: Payment Posted

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

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.