Serial Numbering, Revisited

Created by: adixon

The table "cdntaxreceipts_log" has a primary id key that in theory could be used as the official receipt number instead of the contribution id that's in use now.

I can see it's a bit of chicken/egg in that the record would need to be written without the receipt number and then generated from the id to avoid weird race issues (i.e. two receipts being generated simultaneously), although maybe locking is a good idea anyway.

I have a client who really, really wants those numbers to be sequential without so many gaps (most of their contributions are not tax receiptable), so I'm just thinking this through as an option.

Any thoughts?