Announcement

Collapse
No announcement yet.

Data Imports

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

    Data Imports

    I presently use v2013 on an old XP machine. I am building a new site using v2016 on a new windows 10 machine.(Upgrading not an option in this instance) I want to import all my orders and customers from the old version into the new one. I have imported all the data, which appears to be all OK but I also want the order and invoice numbering in the new site to continue from the old version. I've checked under 'Troubleshooting' and 'Business Settings' etc and changed the leading format of the order number to be as is but I can't find a way to change the numbering or at least the option is greyed out so unable to change.
    Any help appreciated.
    Thanks

    #2
    As far as I know this is to avoid duplication of order numbers in the system.
    See here: http://community.sellerdeck.com/show...t=52875&page=2

    Comment


      #3
      Hi Duncan,
      Thanks for that. Personally I'm not too concerned but HMRC like things to run in some sort of order so as my latest order number is 00010000308 it would be nice to have 00010000309 as the next one in the newly created site and likewise invoice numbering to be in order.
      Having done some more database checks I think the answer will be to change the nLastInvoiceSequenceNo in Setupinfo.
      Thanks for your reply, hopefully it may now be sorted. Famous last words..

      Thanks
      Mike

      Comment


        #4
        You can also use that table to change the offline order number sequence if you don't want that to be reset to zero.
        Reusable Snore Earplugs : Sample Earplugs - Wax Earplugs - Women's Earplugs - Children's Earplugs - Music Earplugs - Sleep Masks

        Comment

        Working...
        X