so our queries used whether

transaction_lines.date_closed is null

to determine if the line was open or closed, but occasionally that date is populated and the line is not closed.