INVENTORY IMPORTING

The line that must be entered in the MLE box is: INVENTORY,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 when the Item is registered to the current shop. This must be present, even if the Location Code is included in the data itself. The Location Code may be set to ** if it is required that all the Items that follow are not registered to this shop.

MINLEVL=mm or MINIMUM=mm where mm is the minimum stock level to be assigned when an Item is registered – if the minimum is supplied with an individual Item, then the supplied figure is used instead.

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 2 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.

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

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 following is an example of a valid string:

INVENTORY,Location=25,minimum=20,AUTOCALC=978,AUTOCALC=271,StartNumOK

The fields in the input record are defined below:

Field Maximum Length
  
Item Code13
Catalog Number 10
Author45
Title120
POS Register Description (optional) 40
Product Group 2
Product Category 2
Product Type 2
Subject Codes (separated by a space) 30
Binding Type 3
Edition6
Unit Price (RRP) 6.2
Is RRP the NET price? (Set to Y) 1
Average Cost Price 6.2
Publisher Code 10
Supplier Code 10
Selling Discount % 3.2
Purchasing Discount % 3.2
Maximum Selling Discount % 3.2
Report Code 7
Report Code – Expected Date DD/MM/YY or DD/MM/YYYY
Report Code – Advised Date DD/MM/YY or DD/MM/YYYY
Bin Location 15
Note #115
Note #215
Note #315
Weight (in grams) 7
Pages7
Item Subject to a Textbook Rebate? (Y/N) 1
Item Tax Exempt? (Y/N) 1
Sales Tax Code (0=Undefined, the Default. Options are 1-9) 1
Current Stock on Hand 5
Location Code (if blank, then the default in aa above will be used) 2
Date of Last Receipt DD/MM/YY or DD/MM/YYYY
Minimum Level (if zero, then the default in bb above will be used) 5
Maximum Stock Level 5
Re-Order Quantity 5
Icon (See Below) 1
Post-It Notes 120
Suppliers Code for this Item 12