Discussions

Hi Everyone,

I'm trying to pull together a list via API of jobs which are completed but not yet invoiced.

The trouble is choosing which field to filter my API call by

STATUS = "Completed" - returns too many positives
INVOICE_SENT = "false" - returns too many positives

I had the idea to filter by jobs READY_TO_INVOICE however by default the jobs keep a value of "1" even after they have been invoiced.

My next thought was perhaps once the jobs are invoiced to change READY_TO_INVOICE from "1" back to "0" so these jobs don't reappear when I filter by READY_TO_INVOICE

Can anyone share any insight on whether this will have adverse effects on other things?