I’m on a project where we are pulling Invoice data from NS to an external system when invoice records are created/updated (via a Restlet). I have a saved search that is filtering on the

lastmodifieddate

field, which is provided with the last date/time we pulled previous updates. One issue we’re facing is when a payment is applied to the invoice and that payment does not result in the invoice being PaidInFull, the invoice record isn’t modified… even though the amount due shows a reduced value from the applied payment. Any idea on how I can capture these types of invoice changes?

Maybe you can put an after submit user event on payments that touches the invoice in a way that updates the lastmodifieddate

This is not probably a satisfying elegant solution, but what do you think about using 2 search criteria for comparison of last pulled. Use lastmodifieddate AND Open Balance on Invoice.

@jkabot Thanks for the reply! thats one solution I had in mind. I need to capture not only when a payment is applied but also if that payment is unapplied to an invoice as both affect the amount remaining.