Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 3 of 3

Thread: changing order / invoice number for the new year

  1. 12-24-2012, 12:48 PM #1
    Achnaton is offline Junior Member
    Join Date
    Jan 2009
    Location
    Netherlands
    Posts
    7

    Default changing order / invoice number for the new year

    Hi,
    I'm running ML8
    I want to change my order number / invoice number for the new year.
    Where can i find that. I've looked nearly "everywhere"
    And can't seem to find the right location/string etc......

    Please help. The new year is right arround the corner and i want to put a 2013 in front!

    Hope anyone can help.

    Kind regards,

    Alberto
  2. 05-12-2013, 11:16 PM #2
    omairkha is offline Member
    Join Date
    Aug 2011
    Posts
    89

    Question

    Hi, were you able to do this? I'm also trying to modify the order numbers
  3. 05-13-2013, 04:54 AM #3
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    Order numbers are automatically generated via the OrderNumbers table in the database. You would need to re-seed this to skip to using the next number you wanted. As an example, you might want to reseed like this

    Code:
    DBCC CHECKIDENT ('OrderNumbers', RESEED, 2013000001)
    This would allow you to have 999,999 orders for the year 2013. But you would have to reseed every year on the 1st Jan @ 00:00:00. Also, you would run out of order numbers in the year 2147 after the 483,647th order of that year!

    Hopefully I won't be around then to take any flack when it all goes wrong

    Google 'sql server reseed', 'sql server identity' and 'sql server int column max value' for more info.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!