we also observed that when you close a line, it populates

date_closed

with the transaction date. so we think we can resolve this by only considering a line closed when

transaction_linesdate_closed = transactions.trandate