Subscribe via rss
Guest
or Ask a Question
Discussions
Add a reply View Replies (5)

Reset invoice ID's

Invoice Manager
Wednesday, June 10 2015, 10:09 PM
Mario
Mario
Offline
0
Hi Germinal,

I was wondering whether it is possible to reset the Invoice ID's/Quote ID's/Contact ID's/Product ID's etc...

Here's why: when I'm setting up IM for a customer, I make a few demo invoices/quotes to test the functionality, create a customer and add some products in the catalog. I check whether my templates look okay and demo IM to the customer.
Once they are ready to start using it, I clean up my stuff so it looks all shiny and new... except: the ID's do not start from 1 as they were taken by my temporary invoices and quotes that are not there anymore.
Is there a way to reset these ID's at the time of handover ?

Thanks !

Cheers,
Mario
invoice manager
Responses (5)

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Thursday, June 11 2015, 09:55 AM - #Permalink
    0
    the only way is to go directly to the DB and reset it from there...
    The reply is currently minimized Show

  • Accepted Answer

    Mario
    Mario
    Offline
    Thursday, June 11 2015, 10:14 AM - #Permalink
    0
    Hi Germinal,
    I don't mind doing it that way - can you tell me where I should be looking ?

    Thanks,
    Mario
    • Germinal Camps
      Germinal Camps
      more than a month ago
      hello Mario,
      in the tables which names starts with #__invoices, you have to go to its options (in phpMyAdmin for example) and set its Auto-increment parameter to 1.
    The reply is currently minimized Show

  • Accepted Answer

    Mario
    Mario
    Offline
    Friday, August 28 2015, 10:53 AM - #Permalink
    0
    Hi Germinal,

    In the mean time, I have been using the method above.
    I only have one issue now, probably caused by my change: when I create a new invoice, the formatted invoice number is the same as the last invoice I created.

    eg. My last invoice is FACT-2015-53. When I create a new one, the new formatted invoice number becomes FACT-2015-53 as well. Do you know which parameter I need to change so that the next formatted invoice number is FACT-2015-54 ?

    Besides this minor issue, it worked like a charm !

    Thanks,
    Mario
    The reply is currently minimized Show

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Thursday, September 03 2015, 09:12 AM - #Permalink
    0
    what is the "real invoice number" in the previous invoice? that's the one that will be used to calculate the next invoice number.
    The reply is currently minimized Show

  • Accepted Answer

    Mario
    Mario
    Offline
    Thursday, September 03 2015, 09:22 AM - #Permalink
    0
    Hi Germinal,
    I managed to get it fixed by indeed correcting the 'real invoice number' in one of the invoices. The next invoice which was created was again following the normal routine.

    Thanks !
    Mario
    The reply is currently minimized Show
Your Reply