Data Entry Report - Order Number Format

[GraemeG]

Hi
I have modified the OrderScript.pl so that Actinic issues order numbers that match our existing order management system.

The number format (as shown in Actinic, the onscreen confirmation and the customer email) is now 036/xxxxx
(where x is our incrementing number, currently around 23100)

The Perl edit for the new numbering format is:

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

which works fine.

The only problem is that the order number appears as 036/xx-xxx on the Data Entry Report which is very annoying..

I NEED to remove the pointless dash from the Data Entry Report and use the correct order number (as shown everywhere else) as it's confusing the staff..

[Jan]

You would need to edit the report to do this, you can edit the Actinic reports using Crystal Reports 8.5.

Regards,

[GraemeG]

Hi
I cannot edit the dashes in the report with Crystal as the Order number is a variable, @OrderNumber

I have, since adjusting the order number, discovered the "/" breaks the OCC file as you cannot create an occ file on the server with a "/" in it..

Anyways, I have adjusted the Perl script to create xxxxx as an order number now and have edited the various areas in the templates (Order04 and the Customer Email) to prefix 036/ to maintain the correct order number to the customer while Actinic now uses 5 digit order numbers (the sequential numbers after the 036/ bit)

This is fine, and resolves the Data Entry Report dash problem..

[Jan]

Hi Graeme,

I am glad that you have resolved your problem. Just for information purposes, the {@OrderNumber} is a formula rather than a variable, you can change this by selecting it, right clicking an d choosing edit formula (or edit embedded formula if it is in a text string), you can also edit formulas by select insert field, expanding the formula selection, selecting the formula by name, right clicking and choosing edit. The formula in V4 are written is a 'crystal' scripting language but if you change any you can change the format to VB format if you are familiar with that.

Regards,

[GraemeG]

Hi
This is even better news. I must admit I've never looked at Crystal Reports closely and now look upon these reports with a new appreciation for their function..

As we now have a 5 digit order number, I was able to alter the Data Report to add our "036/" prefix using the following code:

NewString := '036/' + String;

This is performed under the if > 6 else statement (as our numbers are < 6) and works perfectly

The "036/" prefix is the store reference number for Online and remains the same for all orders so we only need to refer to the 5 digit order number.

This solves all the requirements and maintains OCC compliance

Thanks