Template:Import Inventory (Window ID-267 V1.0.0) - Revision history

CarlosRuiz: Template generated from iDempiere10.20230331

2023-04-04T21:17:00Z

Template generated from iDempiere10.20230331

CarlosRuiz: template generated from idempiere82.20210414

2021-04-16T19:11:09Z

template generated from idempiere82.20210414

CarlosRuiz: template generated from idempiere71

2020-01-25T14:09:55Z

template generated from idempiere71

CarlosRuiz: template generated from idempiere71

2020-01-25T13:42:06Z

template generated from idempiere71

CarlosRuiz: template generated from idempiere62

2019-07-12T15:20:14Z

template generated from idempiere62

CarlosRuiz: template generated from idempiere51

2017-11-17T16:19:50Z

template generated from idempiere51

CarlosRuiz: template generated from idempiere51

2017-11-17T15:35:09Z

template generated from idempiere51

Show changes

Wikirobot: Created page with "en:Import Inventory (Window ID-267) ar:Import Inventory (نافذة ID-267) bg:Импорт инвентар (прозорец ID-267) [[da:Import Inventory (Vindu..."

2013-05-01T16:46:11Z

Created page with "en:Import Inventory (Window ID-267) ar:Import Inventory (نافذة ID-267) bg:Импорт инвентар (прозорец ID-267) [[da:Import Inventory (Vindu..."

New page

[[en:Import Inventory (Window ID-267)]]
[[ar:Import Inventory (نافذة ID-267)]]
[[bg:Импорт инвентар (прозорец ID-267)]]
[[da:Import Inventory (Vindue ID-267)]]
[[de:Import des Warenbestands (Fenster ID-267)]]
[[el:Εισαγωγή Αποθέματος (παράθυρο ID-267)]]
[[es:Importar Inventario (Ventana ID-267)]]
[[fr:Importation du stock (Fenêtre ID-267)]]
[[hu:Készlet importálása (Aablak ID-267)]]
[[id:Import Inventory (jendela ID-267)]]
[[it:Importazione Inventario (finestra ID-267)]]
[[ja:在庫のインポート (ウィンドウ ID-267)]]
[[ms:Import Inventori (tetingkap ID-267)]]
[[nl:Import Inventory (Venster ID-267)]]
[[pl:Import inwentarza (Okno ID-267)]]
[[pt:Importar Inventário (Janela ID-267)]]
[[ro:Import Stoc (fereastră ID-267)]]
[[ru:Импорт инв-ии (окно ID-267)]]
[[sr:Увоз залиха (прозор ID-267)]]
[[sv:Importera lager (Fönster ID-267)]]
[[th:นำเข้าสินค้าคงคลัง (หน้าต่าง ID-267)]]
[[tr:Import Inventory (pencere ID-267)]]
[[zh:导入库存 (窗口 ID-267)]]

== Window: Import Inventory ==

'''Description:''' Import Inventory Transactions

'''Help:''' Validate and Import Inventory Transactions

=== TAB: Inventory ===

'''Description:''' Import Inventory

'''Help''' Validate and Import Inventory Transactions. The Locator is primarily determined by the Locator Key, then the Warehouse and X,Y,Z fields.
A Physical Inventory is created per Warehouse and Movement Date.

[[image:Import Inventory - Inventory - Window (iDempiere 1.0.0).png]]

{| border="1" cellpadding="5" cellspacing="0"
|-
|-valign="top"
!style="background:#efefef;" |'''''Name'''''
!style="background:#efefef;" |'''''Name'''''
!style="background:#efefef;" |'''''Description'''''
!style="background:#efefef;" |'''''Help'''''
!style="background:#efefef;" |'''''Specifications'''''
|-valign="top"
|-

|-valign="top"
|Import Inventory
|Import Inventory
|Import Inventory Transactions
|null
|I_Inventory_ID numeric(10) NOT NULL ID
|-valign="top"
|-

|-valign="top"
|Imported
|Imported
|Has this import been processed
|The Imported check box indicates if this import has been processed.
|I_IsImported character(1) NOT NULL Yes-No
|-valign="top"
|-

|-valign="top"
|Phys.Inventory
|Phys.Inventory
|Parameters for a Physical Inventory
|The Physical Inventory indicates a unique parameters for a physical inventory.
|M_Inventory_ID numeric(10) Search
|-valign="top"
|-

|-valign="top"
|Phys.Inventory Line
|Phys.Inventory Line
|Unique line in an Inventory document
|The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction
|M_InventoryLine_ID numeric(10) Search
|-valign="top"
|-

|-valign="top"
|Import Error Message
|Import Error Message
|Messages generated from import process
|The Import Error Message displays any error messages generated during the import process.
|I_ErrorMsg character varying(2000) String
|-valign="top"
|-

|-valign="top"
|Client
|Client
|Client/Tenant for this installation.
|A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
|AD_Client_ID numeric(10) Table Direct
|-valign="top"
|-

|-valign="top"
|Organization
|Organization
|Organizational entity within client
|An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
|AD_Org_ID numeric(10) Table Direct
|-valign="top"
|-

|-valign="top"
|Document Type Name
|Document Type Name
|Name of the Document Type
|null
|DocTypeName character varying(60) String
|-valign="top"
|-

|-valign="top"
|Document Type
|Document Type
|Document type or rules
|The Document Type determines document sequence and processing rules
|C_DocType_ID numeric(10) Table Direct
|-valign="top"
|-

|-valign="top"
|Movement Date
|Movement Date
|Date a product was moved in or out of inventory
|The Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement.
|MovementDate timestamp without time zone Date
|-valign="top"
|-

|-valign="top"
|Warehouse Key
|Warehouse Key
|Key of the Warehouse
|Key to identify the Warehouse
|WarehouseValue character varying(40) String
|-valign="top"
|-

|-valign="top"
|Aisle (X)
|Aisle (X)
|X dimension, e.g., Aisle
|The X dimension indicates the Aisle a product is located in.
|X character varying(60) String
|-valign="top"
|-

|-valign="top"
|Bin (Y)
|Bin (Y)
|Y dimension, e.g., Bin
|The Y dimension indicates the Bin a product is located in
|Y character varying(60) String
|-valign="top"
|-

|-valign="top"
|Level (Z)
|Level (Z)
|Z dimension, e.g., Level
|The Z dimension indicates the Level a product is located in.
|Z character varying(60) String
|-valign="top"
|-

|-valign="top"
|Locator Key
|Locator Key
|Key of the Warehouse Locator
|null
|LocatorValue character varying(40) String
|-valign="top"
|-

|-valign="top"
|Locator
|Locator
|Warehouse Locator
|The Locator indicates where in a Warehouse a product is located.
|M_Locator_ID numeric(10) Table Direct
|-valign="top"
|-

|-valign="top"
|Search Key
|Search Key
|Search key for the record in the format required - must be unique
|A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
|Value character varying(40) String
|-valign="top"
|-

|-valign="top"
|UPC/EAN
|UPC/EAN
|Bar Code (Universal Product Code or its superset European Article Number)
|Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode)
|UPC character varying(30) String
|-valign="top"
|-

|-valign="top"
|Product
|Product
|Product, Service, Item
|Identifies an item which is either purchased or sold in this organization.
|M_Product_ID numeric(10) Search
|-valign="top"
|-

|-valign="top"
|Lot No
|Lot No
|Lot number (alphanumeric)
|The Lot Number indicates the specific lot that a product was part of.
|Lot character varying(20) String
|-valign="top"
|-

|-valign="top"
|Serial No
|Serial No
|Product Serial Number
|The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1.
|SerNo character varying(20) String
|-valign="top"
|-

|-valign="top"
|Quantity book
|Quantity book
|Book Quantity
|The Quantity Book indicates the line count stored in the system for a product in inventory
|QtyBook numeric Quantity
|-valign="top"
|-

|-valign="top"
|Quantity count
|Quantity count
|Counted Quantity
|The Quantity Count indicates the actual inventory count taken for a product in inventory
|QtyCount numeric Quantity
|-valign="top"
|-

|-valign="top"
|Internal Use Qty
|Internal Use Qty
|Internal Use Quantity removed from Inventory
|Quantity of product inventory used internally (positive if taken out - negative if returned)
|QtyInternalUse numeric Quantity
|-valign="top"
|-

|-valign="top"
|Charge Name
|Charge Name
|Name of the Charge
|null
|ChargeName character varying(60) String
|-valign="top"
|-

|-valign="top"
|Charge
|Charge
|Additional document charges
|The Charge indicates a type of Charge (Handling, Shipping, Restocking)
|C_Charge_ID numeric(10) Table Direct
|-valign="top"
|-

|-valign="top"
|Description
|Description
|Optional short description of the record
|A description is limited to 255 characters.
|Description character varying(255) String
|-valign="top"
|-

|-valign="top"
|Current Cost Price
|Current Cost Price
|The currently used cost price
|null
|CurrentCostPrice numeric Amount
|-valign="top"
|-

|-valign="top"
|Import Inventory
|Import Inventory
|Import Physical Inventory
|The Parameters are default values for null import record values, they do not overwrite any data.
|Processing character(1) Button
|-valign="top"
|-
|}

@@ Line 11: / Line 11: @@
 A Physical Inventory is created per Warehouse and Movement Date.
-[[image:Import_Inventory_-_Inventory_-_Window_(iDempiere_1.0.0).png]]
+[[Image:Import_Inventory_-_Inventory_-_Window_(iDempiere_1.0.0).png|border]]
 {| border="1" cellpadding="5" cellspacing="0" align="center"

@@ Line 11: / Line 11: @@
 A Physical Inventory is created per Warehouse and Movement Date.
-[[image:Import_Inventory_-_Inventory_-_Window_(iDempiere_1.0.0).png]][[image:Import_Inventory_-_Inventory_-_Window_(iDempiere_1.0.0).png]]
+[[image:Import_Inventory_-_Inventory_-_Window_(iDempiere_1.0.0).png]]
 {| border="1" cellpadding="5" cellspacing="0" align="center"

@@ Line 11: / Line 11: @@
 A Physical Inventory is created per Warehouse and Movement Date.
-[[image:Import_Inventory_-_Inventory_-_Window_(iDempiere_1.0.0).png]]
+[[image:Import_Inventory_-_Inventory_-_Window_(iDempiere_1.0.0).png]][[image:Import_Inventory_-_Inventory_-_Window_(iDempiere_1.0.0).png]]
 {| border="1" cellpadding="5" cellspacing="0" align="center"

@@ Line 14: / Line 14: @@
 {| border="1" cellpadding="5" cellspacing="0" align="center"
-|+'''Process Parameteres'''
+|+'''Fields'''
 !style="background:#efefef;" width="100"|Name
 !style="background:#efefef;" width="150"|Description

@@ Line 10: / Line 10: @@
 '''Help:''' Validate and Import Inventory Transactions. The Locator is primarily determined by the Locator Key, then the Warehouse and X,Y,Z fields.<p>
 A Physical Inventory is created per Warehouse and Movement Date.
 [[image:Import_Inventory_-_Inventory_-_Window_(iDempiere_1.0.0).png]]

@@ Line 45: / Line 45: @@
 |<small>I_Inventory.I_ErrorMsg<br>character varying(2000)<br>String</small>
 |-valign="top"
-|Client
+|Tenant
-|Client/Tenant for this installation.
+|Tenant for this installation.
-|A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
+|A Tenant is a company or a legal entity. You cannot share data between Tenants.
 |<small>I_Inventory.AD_Client_ID<br>numeric(10)<br>Table Direct</small>
 |-valign="top"
 |Organization
-|Organizational entity within client
+|Organizational entity within tenant
-|An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
+|An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.
 |<small>I_Inventory.AD_Org_ID<br>numeric(10)<br>Table Direct</small>
 |-valign="top"