Problem in sorting by autogenerated invoice number

Hi, we are adopting the following numbering scheme:
2012-0001
2012-0002
etc

Unfortunately, when we create the invoice, this is saved as 2012-1, 2012-2 etc
in other words the leading zeros are ignored.
This obviously generates a sorting issue, e.g: 2012-2 is considered higher than 2012-11 and so on

Oddly enough, when we are creating a new invoice, the invoice# in the field of the invoice creation
form seem to be correct (the leading zeros are still there). it is only after the invoice is created and displayed in the list that the zeros are missing.

Can you please fix this bug?
Thank you in advance

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Sticky Posts
Zoho Invoice Will Soon Discontinue Support for Older Browser Versions
Hello users, Starting from May 15, 2024, Zoho Invoice will no longer support the following browser versions: Browsers Version Restrictions Firefox Browser Versions older than 100 Google Chrome Versions older than 100 Microsoft Edge Versions older than
Bulk Printing now available in Zoho Invoice
Hello, We are happy to announce the much requested and much awaited feature in Zoho Invoice - Bulk Printing of Estimates and Invoices. All you need to do is, select the invoices you wish to print and then click the 'Print' button. All the invoices will be downloaded as a single PDF file which can be printed as you wish. You can print upto 25 invoices at a single go. Go ahead and give it a shot and let us know how it worked for you. Regards, Reshma
Introducing the iPhone App for Zoho Invoice
Now you can invoice on the go from your iPhone through the Zoho Invoice iPhone app. Our iPhone app is available at the apps store for download. The app is special in more ways than one: An impeccable UI takes your invoicing experience to a whole new level That's a first native app we've come up with It's available for FREE!!!!! Yeah, absolutely Free. No brainer there, we just wanted to make our users to enjoy the app no strings attachedHere some snapshots of the app: For the real experience, head