iMagicSoft Support

[imagicsupport]

We're experiencing an issue with repeating invoice numbers. So far we've tried the steps below to correct. I'm in the process of sending you the database 'Help > Send Database to iMagic Support'

Manually set the invoice number via Invoices > Set Next Invoice No'. It
will use the manually entered number but then proceed to repeat it on
subsequent orders.
Ran compact and repair

Thanks,

Chris

[imagicsupport]

Hi Chris,

Thanks for the question and database.

I've gone through various tests on your database.

At present you have the next invoice number set to '32602' but you're most recent invoice number is '32606'. You also already have an invoice with the number '32602' so the next invoice you create will have that same duplicate number.

To fix:
1) Go to the Invoice list screen and sort by Invoice Number so that the highest one is listed.
2) Select from the menu 'Invoices > Set Next Invoice Number' and enter in that number plus 1. So if the highest is '32606', set it to '32607'.

To test it's then working:
1) Click on New Invoice, so that a new invoice is generated.
2) The Invoice Number should be what you set (in my example '32607').
3) From the menu select 'Invoices > Set Next Invoice Number', and make sure it's now set to '32608' (it should do this automatically).

How it works:
The way the automated invoice number works is by using the 'Next Invoice Number' when you click on 'New Invoice'. It will then attempt to add 1 to the 'Next Invoice Number' and save it back to the database (ready for the next invoice).

As you have the settings in the database, this will happen:
1) Click 'New Invoice'. The system will allocate the 'Next Invoice Number' (32602) to that invoice
2) It will attempt to update the 'Next Invoice Number' by adding 1 to it (32603) and search the database to see if that invoice already exists. In your case it does, so it will fall to the backup process. Which is getting the latest created invoice from the database, getting the Invoice Number from that (32601) and adding 1 to it (32602). If that doesn't work at that point it will give up trying, assuming that you want to set the Invoice Number manually.

So essentially the way you have it set it will get stuck and you'll end up with duplicate Invoice Numbers because it doesn't know what you want to do.

I've tried this here on your database and it resolves the issue.

Regards, John
_________________
iMagic Soft Support