Warehouse & Locators (Venster ID-139)

Uit iDempiere nl
Ga naar:navigatie, zoeken



Venster: Warehouse & Locators

Beschrijving: Maintain Warehouses and Locators

Help: The Warehouse and Locators Window defines each Warehouse, any Locators for that Warehouse and the Accounting parameters to be used for inventory in that Warehouse.



TAB: Warehouse

Beschrijving: Warehouse


Help The Warehouse Tab defines each Warehouse that is used to store products. If a Source warehouse is selected, all product replenishment is from that warehouse. If you use custom replenishment algorithms, you need to define the class used per warehouse.


Bestand:Warehouse & Locators - Warehouse - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
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) NOT NULL
Table Direct
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) NOT NULL
Table Direct
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) NOT NULL
String
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
In Transit In Transit Movement is in transit Material Movement is in transit - shipped, but not received.

The transaction is completed, if confirmed.

IsInTransit
character(1)
Yes-No
Address Adres Location or Address The Location / Address field defines the location of an entity. C_Location_ID
numeric(10) NOT NULL
Location (Address)
Element Separator Element Separator Element Separator The Element Separator defines the delimiter printed between elements of the structure Separator
character(1) NOT NULL
String
Source Warehouse Source Warehouse Optional Warehouse to replenish from If defined, the warehouse selected is used to replenish the product(s) M_WarehouseSource_ID
numeric(10)
Table
Replenishment Class Replenishment Class Custom class to calculate Quantity to Order If you select a custom replenishment type, you need to create a class implementing org.compiere.util.ReplenishInterface and set that on warehouse level. ReplenishmentClass
character varying(60)
String
Disallow Negative Inventory Disallow Negative Inventory Negative Inventory is not allowed in this warehouse If checked, any transaction that results in the onhand inventory being driven negative will be prevented. IsDisallowNegativeInv
character(1) NOT NULL
Yes-No




TAB: Locator

Beschrijving: Locator


Help The Locator Tab defines any Locators for that Warehouse.


Bestand:Warehouse & Locators - Locator - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Locator Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID
numeric(10) NOT NULL
ID
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) NOT NULL
Table Direct
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) NOT NULL
Table Direct
Warehouse Warehouse Storage Warehouse and Service Point The Warehouse identifies a unique Warehouse where products are stored or Services are provided. M_Warehouse_ID
numeric(10) NOT NULL
Table Direct
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) NOT NULL
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Relative Priority Relative Priority Where inventory should be picked from first The Relative Priority indicates the location to pick from first if an product is stored in more than one location. (100 = highest priority, 0 = lowest). For outgoing shipments, the location is picked with the highest priority where the entire quantity can be shipped from. If there is no location, the location with the highest priority is used.

The Priority is ignored for products with Guarantee Date (always the oldest first) or if a specific instance is selected. Incoming receipts are stored at the location with the highest priority, if not explicitly selected.

PriorityNo
numeric(10) NOT NULL
Integer
Default Standaard Default value The Default Checkbox indicates if this record will be used as a default value. IsDefault
character(1) NOT NULL
Yes-No
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
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
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




TAB: Storage

Beschrijving: Detail Storage Information


Help null


Bestand:Warehouse & Locators - Storage - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
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) NOT NULL
Table Direct
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) NOT NULL
Table Direct
Locator Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID
numeric(10) NOT NULL
Locator (WH)
Product Producten Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID
numeric(10) NOT NULL
Search
Attribute Set Instance Attribuut Set Instantie (Attribute Set Instance) Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID
numeric(10) NOT NULL
Product Attribute
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
On Hand Quantity On Hand Quantity On Hand Quantity The On Hand Quantity indicates the quantity of a product that is on hand in a warehouse. QtyOnHand
numeric NOT NULL
Quantity
Date last inventory count Date last inventory count Date of Last Inventory Count The Date Last Inventory Count indicates the last time an Inventory count was done. DateLastInventory
timestamp without time zone
Date
Reserved Quantity Reserved Quantity Reserved Quantity The Reserved Quantity indicates the quantity of a product that is currently reserved. QtyReserved
numeric NOT NULL
Quantity
Ordered Quantity Ordered Quantity Ordered Quantity The Ordered Quantity indicates the quantity of a product that was ordered. QtyOrdered
numeric NOT NULL
Quantity




TAB: Replenish

Beschrijving: Define Product Replenishment


Help The Replenishment Tab defines the type of replenishment quantities. This is used for automated ordering. If you select a custom replenishment type, you need to create a class implementing org.compiere.util.ReplenishInterface and set that on warehouse level.


Bestand:Warehouse & Locators - Replenish - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
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) NOT NULL
Table Direct
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) NOT NULL
Table Direct
Warehouse Warehouse Storage Warehouse and Service Point The Warehouse identifies a unique Warehouse where products are stored or Services are provided. M_Warehouse_ID
numeric(10) NOT NULL
Table Direct
Product Producten Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID
numeric(10) NOT NULL
Search
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Replenish Type Replenish Type Method for re-ordering a product The Replenish Type indicates if this product will be manually re-ordered, ordered when the quantity is below the minimum quantity or ordered when it is below the maximum quantity. If you select a custom replenishment type, you need to create a class implementing org.compiere.util.ReplenishInterface and set that on warehouse level. ReplenishType
character(1) NOT NULL
List
Minimum Level Minimum Level Minimum Inventory level for this product Indicates the minimum quantity of this product to be stocked in inventory. Level_Min
numeric NOT NULL
Amount
Maximum Level Maximum Level Maximum Inventory level for this product Indicates the maximum quantity of this product to be stocked in inventory. Level_Max
numeric NOT NULL
Amount
Source Warehouse Source Warehouse Optional Warehouse to replenish from If defined, the warehouse selected is used to replenish the product(s) M_WarehouseSource_ID
numeric(10)
Table




TAB: Accounting

Beschrijving: Accounting


Help The Accounting Tab defines the Accounting parameters to be used for inventory in that Warehouse.


Bestand:Warehouse & Locators - Accounting - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
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) NOT NULL
Table Direct
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) NOT NULL
Table Direct
Warehouse Warehouse Storage Warehouse and Service Point The Warehouse identifies a unique Warehouse where products are stored or Services are provided. M_Warehouse_ID
numeric(10) NOT NULL
Table Direct
Accounting Schema Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar C_AcctSchema_ID
numeric(10) NOT NULL
Table Direct
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
(Not Used) (Not Used) Warehouse Inventory Asset Account - Currently not used The Warehouse Inventory Asset Account identifies the account used for recording the value of your inventory. This is the counter account for inventory revaluation differences. The Product Asset account maintains the product asset value. W_Inventory_Acct
numeric(10)
Account
Inventory Adjustment Inventory Adjustment Account for Inventory value adjustments for Actual Costing In actual costing systems, this account is used to post Inventory value adjustments. You could set it to the standard Inventory Asset account. W_InvActualAdjust_Acct
numeric(10)
Account
Warehouse Differences Warehouse Differences Warehouse Differences Account The Warehouse Differences Account indicates the account used recording differences identified during inventory counts. W_Differences_Acct
numeric(10) NOT NULL
Account
Inventory Revaluation Inventory Revaluation Account for Inventory Revaluation The Inventory Revaluation Account identifies the account used to records changes in inventory value due to currency revaluation. W_Revaluation_Acct
numeric(10)
Account




TAB: Product Transactions

Beschrijving: Transactions for stored Products


Help null


Bestand:Warehouse & Locators - Product Transactions - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Inventory Transaction Inventory Transaction null null M_Transaction_ID
numeric(10) NOT NULL
ID
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) NOT NULL
Table Direct
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) NOT NULL
Table Direct
Locator Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID
numeric(10) NOT NULL
Locator (WH)
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Product Producten Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID
numeric(10) NOT NULL
Search
Attribute Set Instance Attribuut Set Instantie (Attribute Set Instance) Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID
numeric(10) NOT NULL
Product Attribute
Movement Quantity Movement Quantity Quantity of a product moved. The Movement Quantity indicates the quantity of a product that has been moved. MovementQty
numeric NOT NULL
Quantity
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 NOT NULL
Date
Movement Type Movement Type Method of moving the inventory The Movement Type indicates the type of movement (in, out, to production, etc) MovementType
character(2) NOT NULL
List
Shipment/Receipt Line Shipment/Receipt Line Line on Shipment or Receipt document The Shipment/Receipt Line indicates a unique line in a Shipment/Receipt document M_InOutLine_ID
numeric(10)
Search
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
Move Line Move Line Inventory Move document Line The Movement Line indicates the inventory movement document line (if applicable) for this transaction M_MovementLine_ID
numeric(10)
Search
Production Line Production Line Document Line representing a production The Production Line indicates the production document line (if applicable) for this transaction M_ProductionLine_ID
numeric(10)
Search
Project Issue Project Issue Project Issues (Material, Labor) Issues to the project initiated by the "Issue to Project" process. You can issue Receipts, Time and Expenses, or Stock. C_ProjectIssue_ID
numeric(10)
Search


Contributions / Posts

Cookies helpen ons onze services aan te bieden. Door onze services te gebruiken stemt u in met het gebruik van onze cookies.