1 Reply Latest reply on Oct 15, 2014 9:04 AM by philmodjunk

    Set Invoice status to paid



      Set Invoice status to paid


      I have an invoice database and I am looking for a way to monitor the balance of an invoice and once the Balance due = 0 then set the Invoice status from “Billed” to “Paid”. The balance field is a calculation field that is the Invoice total – payments made.

      I can think of a few different ways to change this field but once it is set to a paid status it would not be likely to change again. Therefore I am trying to figure out the most efficient way to set this field, is it a script trigger (onObjectModify)? Does that script trigger if the value changes via a calculation or only when a user makes a change?

      Any suggestions on this are appreciated!

        • 1. Re: Set Invoice status to paid

          It could just be a calculation field that returns the text "Paid" when Balance Due = 0.

          I don't know how you are recording payments, but I'd use OnObjectSave on the field used to log payments to trigger a script to do this if I were to use a script instead of a calculation field.