Inventory Inventory transactions Inventory (stocktaking) Annual inventory count Inventory list Import stock - robinfeng/beashelp GitHub Wiki
导入库存
Navigation: Inventory > Inventory transactions > Inventory (Stocktaking) > Annual inventory count > Inventory list: Import stock No contents entries on this page Contents Using a text file stock can be imported. After confirming the warning message, a screen opens to select the path to import file. 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)
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 is not existing, leave the field empty. Enter no title.
hmtoggle_plus1 Example with (item number, quantity and storage location only): 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 be existing in the system. Quantity
Counting amount in warehouse units 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 amount of 1 allowed. Warehouse
Target warehouse, need to be deposited in the item. Bin location
If 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.
NOTE: only prices >0 are taken into account
Currency
Currency for price
After import entries are checked immediately by the pre-check and incorrect entries are marked as not bookable.
back to Initial stock
返回 主页