Sage Ling Screw Up (My Fault)

[eAbsinthe.com]

When I upgraded to v7, I left all the orders behind as I didn't need them (having been ported over to Sage).

However, now I've come to export the newer orders from v7 I've noticed a problem -- as all the order numbers are reset to zero it's looking to overwrite the old orders.

Any suggestions? I can't use Sage's numbering as we need the Actinic number in the accounts.

the only thing I thought of was generating a new default customer - Internet2... whould that do any good?

[dave_finlayson]

Martin,

You can reset the order numbers to anything you want by going to Help | Troubleshooting and Update Order Number. Enter what number you want them to start at then click on Update Order Number. I would suggest looking up your old orders and finding out the last order number then add X amount onto that figure.

Regards

Dave

[eAbsinthe.com]

Excellent, thanks, that looks like it will sort out the problem with any new orders.

Any ideas on the ones I already have, I've got a few hundred!

[cdicken]

I would export the files without calling Actinic Link. Then use 'Find and Replace' on the 'orders.csv' file to add in a unique number somewhere in the string.

e.g. replace

0000000
with
9000000

It will probably take a few passes to get it right.

[eAbsinthe.com]

Hmmm... I think I've done that, but I get the following message (see attachment)

I'm getting lots of Error number 9, subscript out of range. Have I missed something else, perhaps in another table?

[cdicken]

Oh dear. No ideas on that one I'm afraid.

I suggest re-exporting the orders from Actinic just as they are. As long as you have 'Get Next Available Invoice\Order Number from Sage' selected (in the 'General' tab of 'Actinic to Sage'), Sage will just use the Actinic order numbers for reference, not for any data processes, so the duplicates won't affect it.