A question in return: If we did away with the acq.invoice.complete column, say that a user closes the invoice and close_date and closed_by values are generated. What if the user then re-opens the invoice and it remains open for whatever reason (potentially user error). Would a report looking for open invoices (presumably checking for a NULL value in the close_date?) find that invoice since it had a close_date at one point? If it wouldn't find that invoice, I could see keeping acq.invoice.complete since that's a yes/no if the invoice is open. (I think.)
A question in return: If we did away with the acq.invoice. complete column, say that a user closes the invoice and close_date and closed_by values are generated. What if the user then re-opens the invoice and it remains open for whatever reason (potentially user error). Would a report looking for open invoices (presumably checking for a NULL value in the close_date?) find that invoice since it had a close_date at one point? If it wouldn't find that invoice, I could see keeping acq.invoice. complete since that's a yes/no if the invoice is open. (I think.)