Stock 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.
Window mw_inventory_items_difference_browse.psr
A text file in CSV format (tab-separated) needs to be created with the following structure:
Item number, quantity, store, inventory location, batch or serial number, expiration date (for batch/serial numbers only), Price, Currency, Version (For items version controlled)
Separator: Tab (Char 9)
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.
100004[TAB]1,4[TAB]001[TAB][TAB][TAB] 100005[TAB]1,5[TAB]002[TAB][TAB][TAB] |
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: 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 |
Expiration date |
Optional entry of expiration date. Use format of windows regional settings or in format yyyy/mm/dd |
Price |
Optional. Format see quantity. |
Currency |
Currency for price. |
Version |
Item Version of the Item. (System does not validate that assigned version exists for selected item) |
Import entries are then checked immediately by the pre-check and incorrect entries are marked as not bookable.
back to Initial stock