Discussions

Ask a Question
Back to all

WorkOrder to Invoice relationship

This is mostly a sanity check for me.

We have an integration that's been running for over a year and it's working great.
I realized today that my logic may be using something that works specifically for us because of how we use Corrigo, but may not be an actual "Truth."

The simply questions are:
1) can a single Work Order be referenced on multiple, different Invoices in Corrigo?
2) can a single Invoice in Corrigo have line items that reference more than one work order?

The WorkOrder endpoint references LastAction, which appears to be a single record for each WorkOrder. At least it appears to be so in our database. If that is true, then any given WorkOrder can only exist on a single Invoice, right?

However, each InvoiceLine element has a reference back to a WorkOrder (although it apparently does not have a reference to the invoice it belongs to), which suggest line items on different invoices may point to the same work order. Again, I've found no evidence in our database, but lack of evidence is evidence of nothing. It seems like it's possible a single work order can exist on multiple invoices.

Again, this is just for me to make sure the logic we're using is sound.