Answers.Body: <p>You want to change the auto-increment number:</p>
  
  <pre><code>ALTER TABLE civicrm_contribution AUTO_INCREMENT = 4356;
  </code></pre>
  
  <p>Note that this is very dangerous if you set the number backward rather than forward.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-29T19:54:21.203Z
Answers.Text: Great! Thanks Jon, I wasn't sure if that was the way to go.
Answers.UserDisplayName: Andrei
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-29T18:10:25.537Z
Answers.LastActivityDate: 2015-09-29T18:10:25.537Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I'm wondering if is possible to alter the current Contribution_ID start count.</p>
  
  <p>The invoice prefix is set to "INV" so when viewing a contribution I can see the invoice ID like INV76, I guess the ID comes from the contribution_id which matches with invoice_id in any single contribution. I would like to alter the current count so the next contribution_id starts with for example 4076.</p>
  
  <p>Resuming, my target is to change the count of the invoice_id so it matches with our current invoices count (right now is about 4356) as we would like to use this fantastic CiviCRM feature.</p>
  
  <p>Any help is appreciated.</p>
  
  <p>CiviCRM 4.6.X Wordpress 4.3</p>
  
Tags: <civicontribute><wordpress><accounting><invoice>
Title: How to alter the InvoiceID/ContributionID count
ThreadText: # How to alter the InvoiceID/ContributionID count
  
  (Asked by: username_0 on 2015-09-29)
  
  I'm wondering if is possible to alter the current Contribution\_ID start count.
  
  The invoice prefix is set to "INV" so when viewing a contribution I can see the invoice ID like INV76, I guess the ID comes from the contribution\_id which matches with invoice\_id in any single contribution. I would like to alter the current count so the next contribution\_id starts with for example 4076.
  
  Resuming, my target is to change the count of the invoice\_id so it matches with our current invoices count (right now is about 4356) as we would like to use this fantastic CiviCRM feature.
  
  Any help is appreciated.
  
  CiviCRM 4.6.X Wordpress 4.3
  
  **Tags:** civicontribute, wordpress, accounting, invoice
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-09-29. Score: 2 | Accepted answer
  
  You want to change the auto-increment number:
  
  ```
  ALTER TABLE civicrm_contribution AUTO_INCREMENT = 4356;
  
  ```
  
  Note that this is very dangerous if you set the number backward rather than forward.
  
  > **Comments:**
  > **username_0**: Great! Thanks Jon, I wasn't sure if that was the way to go.  
  
  ---
  
  