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

Where keyword may be entered in any sequence and may be any of the following codes:

LOCN=nn or LOCATION=nn where nn is the Location code that is going to be used in place of whatever is included in the data records that follow.

YEAR=yyyy where yyyy is the Year that is going to be used in place of whatever is included in the data records that follow. The Year must be a 4-digit number.

MONTH=mm where mm is a Month number having the value 1-12. The data that follows contains 12 months of data for the calendar year. If the data pertains to July-December (instead of the default January-December) then you must specify MONTH=07

SHOP=ss where ss is the Shop code that is going to be used in place of the current shop, i.e. the shop where we are running this data import.

REPLACE The default is to add the history to any existing data found. Include this parameter in order to overwrite any existing data with the supplied data.

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.

IGNOREDUP If this parameter is present, then all input data will be ignored if a match is found i.e. if the History record is already on file, then the input record will be ignored.

Note that the keywords are not case sensitive.

The following is an example of a valid string:

INVHIST,Location=25,year=1999,AUTOCALC=978,AUTOCALC=271,StartNumOK,Month=07

The fields in the input record are defined below: