order numbers

[TraceyHand]

<off topic>how that was the Frosties reference and not seeing Jan just after waking up </on topic>

<off topic and not much caring as she doesn't know what the topic is anyway>
Quite honestly, jont, I have no fricken idea what the game is...I just wanted to join in <end waffle>

[Jan]

I've been here Darren, not had much to say though.

[Darren B]

I've been here Darren, not had much to say though.

Ponders that, not sure, checks Jans Gender, ponders some more, and decides Jans not much to say is probabaly different to darrens much to say

[TraceyHand]

decides Jans not much to say is probabaly different to darrens much to say

I seriously, seriously doubt that!
You gab like a woman, D

[essentialoils]

Hi there

You can shorten the order number of an order if you like. To do this, open "OrderScript.pl" and on line 6209 you will have the following:

	$::s_sOrderNumber = $sInitials . $sPostCode . substr($$::g_pSetupBlob{CGI_ID}, -1) . substr("0000000" . $nCounter, -7);

So as an Example if you want the first 3 letters to be "ACT" and shorten it, so the whole number of would order would be 8 characters instead of 11 characters then you would make the following change:

$::s_sOrderNumber = "ACT" . substr($$::g_pSetupBlob{CGI_ID}, -1) .
		substr("0000" . $nCounter, -4);

You can take bits out, but you cannot extended it.

Hope this helps. Remember to backup the original orderscript.pl just in case something happens, i have tested this on my version and it works fine

Kind Regards

I have tried this. It works, except it places a 1 before the 0000

Is this an errror message? How do I get rid of the 1

[TraceyHand]

the 1 is coming from the script ID.
If you want to remove it, remove

substr($$::g_pSetupBlob{CGI_ID}, -1) .

from the code

you might want to extend the 0000 to 00000 though or you'll only get to order number 9999 and then it'll reset again.

[essentialoils]

A note on the order #: Special note on external reference:

Thank you tracy! very kind of you to answer.

$::s_sOrderNumber = "" .
substr("00000" . $nCounter, -5);

This is what the Doctor ordered.

--

A note on the order #: After 3 years of using actinic and receiving 1000's of Orders:

Use and Sorting the original Long number is basically useless. Why?

1. Customs change there name, and address.
2. Actinic Link to Sage puts the useless beginning in Sales order number and had to copy and paste the end.
3. Tired of listening to customers tiring to say the long number and having to say the last numbers.

--

Special note on external reference:

1.) This is the most important constant for a company search and sort.

In customer accounts The external reference Is the basic constant (along side the name which should have been merged and called Account Reference.) Used also in Sage.

It should be before or after the order number on the Orders Tab.

Then you could sort, search and export correctly and usefully.