IMPORTING SPECIAL ORDERS

Special Orders may be imported subject to certain rules (see below).

The line that must be entered in the MLE box is:
SPECORDERS,keyword-1,keyword-2,keyword-3,…

Where keyword may be entered in any sequence and is present to look after the Item code that is supplied. It may be any of the following codes:

AUTOCALC If the Item code is a 12 digit number, that commences with any code, then the check digit will be computed in the last (i.e. 13th) position. If this parameter is read in, then the following parameter is ignored.

AUTOCALC=xxx where xxx represents the first three characters of a 12 digit number. Only those 12 digit numbers commencing with xxx will have the check digit computed and inserted into the 13th position. Up to twenty of these parameters may be entered, in order to accept a number of codes.

ADDZERO If this parameter is present, then the above conversion of a 12 digit number, is changed when the first two digits are both zeroes. The 12 digits are shifted to the right and a zero is added to the front of the number. The number will then start with three zeroes.

STARTNUMOK If this parameter is present, then any Item Code that commences with a digit (0-9) will be accepted, provided that the number does not contain 8, 10 or 13 digits.

Note that the keywords are not case sensitive.

The Special Orders are subject to the following rules:

1. The Special Order code should be of the format XXX9999999 or 9999999. If no prefix is present, then “SPL” will be inserted as the prefix.

2. The Special Orders will be stored as “awaiting the next Purchase Order receipt” i.e. no Requisitions will be created for these orders.

3. The customer account number must be present and the customer must be a CASH customer. Debtors will be permitted, however, if no deposit is included.

4. The Item code must be valid and must be registered within the shop. Items failing this test will not be stored.

At the conclusion of the run, a text file “SpecOrdImp.LOG” will be created in the Booknet PC directory on the user’s PC.

The following is an example of a valid string:

SPECORDERS,AUTOCALC=978,AUTOCALC=271,StartNumOK

The fields in the input record are defined below:

FieldMaximum Length
  
Special Order Code10
Customer Account Code10
Customer Order Number (optional)10
User ID10
Date Order Created (optional)8 (YYYYMMDD)
Deposit Paid for this Item7.2
Notes (optional)200
Item Code13
Quantity that is still due4
Unit Price (inc tax)7.2
Item exempt? (Set to “Y” if true)

1