Quickbooks 2009 Automatic Invoice number increment stopped working

johnskim9 · ‎January 02, 2020

Hello,

I'm having a little trouble at the moment. Over the new year we changed from a 9 digit invoice number to a 10 digit invoice number. When I go to enter the invoice number for invoices, I can put in the correct 10 digit invoice number. However, after I click save and new, the next invoice has an invoice number of "1". It did not increment it with 1 more digit.

Any help would be greatly appreciated. Thanks!

BigRedConsulting · ‎January 02, 2020

@JamesDuanT

RE: There are two possible reasons why the invoice number didn't move after saving invoices.

There is a third possibility: It's a bug.

And, in fact, that is the cause. There is no reason to try to fix the file or fix the QuickBooks installation.

This is easy enough to reproduce. It took me 30 seconds. You could have done that too before answering the question.

@johnskim9

This is a longstanding QuickBooks bug and is easy to duplicate. I duplicated it before writing this answer in QuickBooks 2011 (the oldest I have), QuickBooks 2017, and QuickBooks 2020.

All it takes to duplicate the bug is to create a new invoice with any 10 digit number:

Step 1: Create a new invoice with the number and save it.

The next invoice will be numbered 1.

It seems the math to add 1 to is just too hard for QuickBooks. :)

View solution in original post

JamesDuanT · ‎January 02, 2020

Hello johnskim9,

There are two possible reasons why the invoice number didn't move after saving invoices. It could be:

Your company file is damaged.
A QuickBooks components is damaged.

To determine whether is this a data or product issue, we can do a few troubleshooting steps. We can open a sample company file to see if the invoice number will move after saving another one.

Click File at the top menu and select Close Company.
In the No Company Open window, highlight a sample company file and click Open.
Create a dummy invoice and save.
Create another one determine whether the invoice number changes automatically.

If the invoice numbers work properly in the company file, we can conclude that this is a data issue. We can go back to your company file and do the Verify and Rebuild process. This'll fix data integrity issues on your file.

Otherwise, we can repair QuickBooks to fix the damaged components. You can follow the steps in this article: Repair Your QuickBooks Desktop For Windows.

Note: We can't guarantee that these troubleshooting steps will work due to your QuickBooks Desktop version. You might also consider upgrading to the supported versions so you'll receive the latest updates.

Give this a shot. We can give you more information about this based on the result.

BigRedConsulting · ‎January 02, 2020