Import of several Excel files (Items list with LOTS)

With the use of LOT positions, you can also import several items lists using an Excel file. In the Items list editor on the interface, it must first be preselected via the "Items list Structure" button that LOTS are used.

  • To do this, click on  in the button bar to select the option.

  • Set the option “The reference numbering is taking place:” on “automatically”

  • check the box “Use lots”

  • Finaly, click on  “Renumber items list”


image-20230523-095050.png
Settings for the Items list structure



 

The red folder in the Items list editor will then receive an "L" for LOT:

 

image-20230523-095114.png
LOT position in the Items list


By right-clicking on the blue folder and selecting "New folder", further LOT positions can then be created.


image-20230523-095145.png
Create more LOTS in the Items list

 

You can then import an items list for each red folder using the import function via Excel. To do this, select the desired red folder in advance and then execute the import via an Excel file.

 


Fig.: Import Items list by LOT position

 

 

 

Note:

If an unknown unit appears in your import file for the items list (GAEB or Excel), you will receive the following information:


image-20230523-095226.png


You can then select the appropriate unit from the drop-down window. By clicking on "Next" the import continues and the unknown unit is replaced by the selected unit during import. If other units are unknown, the notification window appears again.