Sequential Invoice Numbering Issue in WHMCS 7.4.2

[Makhonge]

We use Proforma Invoicing and Sequential Invoicing. We use the following format; SHL-{YEAR}-{NUMBER} e.g. SRL-2018-2341.  On January 1st 2018, our first Paid invoice was SRL-2018-1. On 31st January our last Paid Invoice was SRL-2018-2341. On 1st February 2018, we expected our first paid invoice to be SRL-2018-2342. However, it numbered it as SRL-2018-1 again. In other words, Sequential Invoicing starts counting afresh monthly even when {MONTH} isn't specified in the format.

We resolved the above problem by manually editing the Paid invoice numbers [which were now up to SRL-2018-17] to start counting from 2343 on wards instead duplicating paid invoice numbers for previous month.

Come this month of March,  the first Paid invoice was again generated as SRL-2018-1. We found 49 invoices duplicated and had to again manually correct by changing the 'Next Paid Invoice Number' to continue counting from 2560 on wards. 

As mentioned earlier, we only use {YEAR}-{NUMBER}. However, numbering is restarting on 1st of every month. One would expect it to restart once a year if {MONTH} isn't included.

Unless adjusted manually at the beginning of every month, one risks having 12 Paid Invoices with same number in a year, which may complicate tax reporting. 

[Makhonge]

4 minutes ago, Makhonge said:

Proforma Invoicing and Sequential Invoicing

I meant Proforma Invoicing and Sequential Paid Invoice Numbering