Import inventory

A text file in CSV format (tab-separated) needs to be created with the following structure:

Item code, quantity, warehouse, bincode, batch or serial number, shelf life (for batch/serial numbers only), Price, Currency, Version (For items version controlled)

Date format in yyyy / mm / dd , e.g. 2008/12/31 or in the format of the Windows regional settings. Numbers in the format of the Windows regional settings.

All values need to be entered. If a value does not exist, leave the field empty. Enter no title.

Field	Meaning
Item number	Item number to register. Item must exist in the system.
Quantity	Counting amount in Inventory UoM without thousands marker. As decimal separator the character according to windows-system setting is required. Example: German regional settings: 25,5 Example: American regional settings: 25.5 For serial number related items: only the amount of 1 is allowed.
Warehouse	Target warehouse; needs to be deposited in the item.
Bin location	For warehouse with bin locations, enter bin code.
Batch	For batch-related items: batch number. For serial number related items: serial number Use DistNumber (visible batch number), not internal system number.
Shelf Life	Optional entry of expiration date. Use format of windows regional settings or in format yyyy/mm/dd Example: 2018/04/03
Price	Optional. Format see quantity. NOTE: Only prices > 0 are taken into account.
Currency	Currency for price.
Version	Item Version of the Item. (System does not validate if the assigned version exists for selected item)

Import entries are then checked immediately by the pre-check and incorrect entries are marked as not bookable.

Import inventory

Inventory can be imported with the help of a text file.

After clicking on the Import button under Inventory list > Extended tab, a warning message pops up where you can confirm the Start of the import.

Upon clicking "yes", a browser window opens to select the path for the new import file.