Store max transaction number
I have a general ledger transaction dataset that is almost 90Mil rows. It takes three hours to do a full replace daily. The dataset has a unique sequential transaction number that grows as transactions are posted. Most of the time, letting the general ledger just run overnight is sufficient. But several times a month there…
