Announcement

Collapse
No announcement yet.

Auto Invoice Number

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Auto Invoice Number

    Hello, Appreciate if any one can help me in setting up a procedure where the user can set "Start Invoice Number" and to be stored on the system, so when he generates a new invoice a new number will take over. Such as a configuration file...

    thank you,

  • #2
    There are several possibilities, depending on the database used. You can use an autosequence. There's a manual autosequence option within SC. And finally you can make a small php procedure to do so.

    In general: select max(invoicenr) from invoice. Then add 1 to it and apply that as default value.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      If you are using an auto_increment value in mysql to get your invoice number, and you want to start from number 1000 instead of number 1, you have to run this SQL sentence to alter your table:

      Code:
      ALTER TABLE myTable AUTO_INCREMENT=1000;
      Now your auto_increment field will start from number 1000.
      Best Regards
      Hiram BQ

      Comment


      • #4
        Hey guys! I also have same problem but I recovered in last days....

        Please suggest me and visit :

        http://www.fetchflow.com/support/que...-invoices.html
        Last edited by Calvin_carl; 09-15-2013, 02:38 PM.

        Comment

        Working...
        X