It would need to be retrieved for new invoices and updated whenever a new invoice is created. It’s practically doubling the workload.
- I put the next invoice in this settings box as 100.
- Now I go to create a new invoice and it pulls 100 from the settings field and increments 1.
- Now when I save the invoice it needs to update the next invoice number in the settings area to 101.
Although we need to query the db to set the next invoice number we don’t need to update another field in the settings table.