ManPageW PhysicalInventory

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Physical Inventory

Description : Enter Physical Inventory

Help : The Physical Inventory Window allows you to generate inventory count lists. These counts can then be processed which will update the actual inventory with the new counts. Normally you would create inventory count lines automaticelly. If you create them manually, make sure that the book value is correct.



Tab: Inventory Count

Description : Define Inventory Count

Help : The Inventory Count Tab defines the parameters for a manual count and adjustment of inventory. When creating the inventory count list automatically, only the actual stored products are included. The exception is when you select the equals 0 (=0) option, then zero on hand records of all stocked products is created for that location.

Table Name  : M_Inventory

Fields

Name Description Help Technical Data
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

NUMBER(10)

TableDir

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

NUMBER(10)

TableDir

Document No Document sequence number of the document The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. 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).

DocumentNo

NVARCHAR2(30)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Warehouse Storage Warehouse and Service Point The Warehouse identifies a unique Warehouse where products are stored or Services are provided. M_Warehouse_ID

NUMBER(10)

TableDir

Perpetual Inventory Rules for generating physical inventory The Perpetual Inventory identifies the Perpetual Inventory rule which generated this Physical Inventory. M_PerpetualInv_ID

NUMBER(10)

TableDir

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

DATE

Date

Document Type Document type or rules The Document Type determines document sequence and processing rules C_DocType_ID

NUMBER(10)

TableDir

Create Inventory Count List Create Inventory Count List The inventory count lines are generated. You can add new lines or delete lines manually. GenerateList

CHAR(1)

Button

Update Quantity The Book Quantity is updated with current book quantity The Update Quantity Process will update the book quantity with the current book quantity. UpdateQty

CHAR(1)

Button

Project Financial Project A Project allows you to track and control internal or external activities. C_Project_ID

NUMBER(10)

TableDir

Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing C_Activity_ID

NUMBER(10)

TableDir

Campaign Marketing Campaign The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. C_Campaign_ID

NUMBER(10)

TableDir

Trx Organization Performing or initiating organization The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. AD_OrgTrx_ID

NUMBER(10)

Table

User List 1 User defined list element #1 The user defined element displays the optional elements that have been defined for this account combination. User1_ID

NUMBER(10)

Table

User List 2 User defined list element #2 The user defined element displays the optional elements that have been defined for this account combination. User2_ID

NUMBER(10)

Table

Approved Indicates if this document requires approval The Approved checkbox indicates if this document requires approval before it can be processed. IsApproved

CHAR(1)

YesNo

Approval Amount Document Approval Amount Approval Amount for Workflow ApprovalAmt

NUMBER

Amount

Document Status The current status of the document The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field DocStatus

CHAR(2)

List

Process Inventory Count Process Inventory count and update Inventory DocAction

CHAR(2)

Button

Posted Posting status The Posted field indicates the status of the Generation of General Ledger Accounting Lines Posted

CHAR(1)

Button


Tab: Inventory Count Line

Description : Inventory Count Line

Help : The Inventory Count Line defines the counts of the individual products in inventory. Normally you would create inventory count lines automaticelly. If you create them manually, make sure that the book value is correct. You can set the Organization, if it is a charge, otherwise it is set to the header organization.

Table Name  : M_InventoryLine

Fields

Name Description Help Technical Data
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

NUMBER(10)

TableDir

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

NUMBER(10)

TableDir

Phys.Inventory Parameters for a Physical Inventory The Physical Inventory indicates a unique parameters for a physical inventory. M_Inventory_ID

NUMBER(10)

TableDir

Line No Unique line for this document Indicates the unique line for a document. It will also control the display order of the lines within a document. Line

NUMBER(10)

Integer

Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID

NUMBER(10)

Locator

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

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

NUMBER(10)

ProductAttribute

Quantity count Counted Quantity The Quantity Count indicates the actual inventory count taken for a product in inventory QtyCount

NUMBER

Quantity

Quantity book Book Quantity The Quantity Book indicates the line count stored in the system for a product in inventory QtyBook

NUMBER

Quantity

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Inventory Type Type of inventory difference The type of inventory difference determines which account is used. The default is the Inventory Difference account defined for the warehouse. Alternatively, you could select any charge. This allows you to account for Internal Use or extraordinary inventory losses. InventoryType

CHAR(1)

List

Charge Additional document charges The Charge indicates a type of Charge (Handling, Shipping, Restocking) C_Charge_ID

NUMBER(10)

TableDir


Tab: Attributes

Description : Product Instance Attribute Material Allocation

Help :

Table Name  : M_InventoryLineMA

Fields

Name Description Help Technical Data
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

NUMBER(10)

TableDir

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

NUMBER(10)

TableDir

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

NUMBER(10)

Search

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

NUMBER(10)

ProductAttribute

Movement Quantity Quantity of a product moved. The Movement Quantity indicates the quantity of a product that has been moved. MovementQty

NUMBER

Quantity

Contributions

Personal tools