 |
iMagicSoft Support iMagic Software Support
|
View previous topic :: View next topic |
Author |
Message |
imagicsupport Site Admin
Joined: 16 Dec 2006 Posts: 2371
|
Posted: Thu Mar 07, 2019 11:18 am Post subject: Getting duplicate invoice numbers |
|
|
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 |
|
Back to top |
|
 |
imagicsupport Site Admin
Joined: 16 Dec 2006 Posts: 2371
|
Posted: Thu Mar 07, 2019 11:20 am Post subject: |
|
|
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 |
|
Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
iMagic Inventory Software home page
Powered by phpBB © 2001, 2005 phpBB Group
|