iMagicSoft Support Forum Index iMagicSoft Support
iMagic Software Support
 
  SearchSearch   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Getting duplicate invoice numbers

 
Post new topic   Reply to topic    iMagicSoft Support Forum Index -> iMagic Inventory Software
View previous topic :: View next topic  
Author Message
imagicsupport
Site Admin


Joined: 16 Dec 2006
Posts: 2326

PostPosted: Thu Mar 07, 2019 9:18 am    Post subject: Getting duplicate invoice numbers Reply with quote

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
View user's profile Send private message Visit poster's website
imagicsupport
Site Admin


Joined: 16 Dec 2006
Posts: 2326

PostPosted: Thu Mar 07, 2019 9:20 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    iMagicSoft Support Forum Index -> iMagic Inventory Software All times are GMT + 8 Hours
Page 1 of 1

 
Jump to:  
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