ManPageW PhysicalInventory
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 |
