Import stockInventory > Inventory transactions > Inventory (Stocktaking) > Annual inventory count > Inventory list > Import stock |
Top
Previous
Next
|
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 code, quantity, warehouse, bincode, batch or serial number, shelf life (for batch/serial numbers only), Price, Currency, Version (For items version controlled) Example: Enter the information in an Excel sheet and save it as a text file:
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.
Import entries are then checked immediately by the pre-check and incorrect entries are marked as not bookable.
back to Inventory Opening Balance |