Only workaround I found was to amend all the invoices I've done since it changed from 9999 to 10000 from INV- to INVOICE- by editing each invoice then to make sure they stay like this I went to SALES, INVOICE SETTINGS, DEFAULT SETTINGS, under AUTOMATIC SEQUENCING changed the Invoice Prefix to INVOICE then all future invoices will start with INVOICE and they then appear in the correct order as the 'O' in invoice precedes the 1 of 10000
Only workaround I found was to amend all the invoices I've done since it changed from 9999 to 10000 from INV- to INVOICE- by editing each invoice then to make sure they stay like this I went to SALES, INVOICE SETTINGS, DEFAULT SETTINGS, under AUTOMATIC SEQUENCING changed the Invoice Prefix to INVOICE then all future invoices will start with INVOICE and they then appear in the correct order as the 'O' in invoice precedes the 1 of 10000