Window: Inventory Decrease/Increase
[Created: 26/11/2004 - Updated: 08/12/2023 ]
Description: Enter Inventory Decrease/Increase (for example Internal Use of Inventory)
Help: The Internal Use of Inventory Window allows enter the quantity of used products.
Tab: Internal Use
[Created: 26/11/2004 - Updated: 03/04/2013 ]
Description: Define Internal Use Inventory
Help:
Tab Level: 0
Table 10: Internal Use - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_inventory.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_inventory.AD_Org_ID numeric(10) Table Direct |
| 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_", where TableName is the actual name of the table (e.g. C_Order). | m_inventory.DocumentNo character varying(30) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | m_inventory.Description character varying(255) String |
| Warehouse | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | m_inventory.M_Warehouse_ID numeric(10) Table Direct |
| 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. | m_inventory.MovementDate timestamp without time zone Date |
| Document Type | Document type or rules | The Document Type determines document sequence and processing rules | m_inventory.C_DocType_ID numeric(10) Table Direct |
| Project | Financial Project | A Project allows you to track and control internal or external activities. | m_inventory.C_Project_ID numeric(10) Table Direct |
| Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | m_inventory.C_Activity_ID numeric(10) Table Direct |
| 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. | m_inventory.C_Campaign_ID numeric(10) Table Direct |
| 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. | m_inventory.AD_OrgTrx_ID numeric(10) Table |
| User Element List 1 | User defined list element #1 | The user defined element displays the optional elements that have been defined for this account combination. | m_inventory.User1_ID numeric(10) Search |
| User Element List 2 | User defined list element #2 | The user defined element displays the optional elements that have been defined for this account combination. | m_inventory.User2_ID numeric(10) Search |
| Approved | Indicates if this document requires approval | The Approved checkbox indicates if this document requires approval before it can be processed. | m_inventory.IsApproved character(1) Yes-No |
| Approval Amount | Document Approval Amount | Approval Amount for Workflow | m_inventory.ApprovalAmt numeric 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 | m_inventory.DocStatus character(2) List |
| Process Inventory Count | Process Inventory count and update Inventory | m_inventory.DocAction character(2) Button | |
| Posted | Posting status | The Posted field indicates the status of the Generation of General Ledger Accounting Lines | m_inventory.Posted character(1) Button |
Tab: Internal Use Line
[Created: 26/11/2004 - Updated: 16/03/2021 ]
Description: Internal Use Inventory Line
Help: The Inventory Count Line defines the counts of the individual products in inventory.
Tab Level: 1
Table 20: Internal Use Line - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_inventoryline.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_inventoryline.AD_Org_ID numeric(10) Table Direct |
| Phys.Inventory | Parameters for a Physical Inventory | The Physical Inventory indicates a unique parameters for a physical inventory. | m_inventoryline.M_Inventory_ID numeric(10) Search |
| 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. | m_inventoryline.Line numeric(10) Integer |
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | m_inventoryline.M_Locator_ID numeric(10) Locator (WH) |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_inventoryline.M_Product_ID numeric(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_inventoryline.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Description | Optional short description of the record | A description is limited to 255 characters. | m_inventoryline.Description character varying(255) String |
| Internal Use Qty | Internal Use Quantity removed from Inventory | Quantity of product inventory used internally (positive if taken out - negative if returned) | m_inventoryline.QtyInternalUse numeric Quantity |
| Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | m_inventoryline.C_Charge_ID numeric(10) Table Direct |
Tab: Attributes
[Created: 13/04/2008 - Updated: 16/03/2021 ]
Description:
Help:
Tab Level: 2
Table 30: Attributes - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_inventorylinema.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_inventorylinema.AD_Org_ID numeric(10) Table Direct |
| Phys.Inventory Line | Unique line in an Inventory document | The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction | m_inventorylinema.M_InventoryLine_ID numeric(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_inventorylinema.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Movement Quantity | Quantity of a product moved. | The Movement Quantity indicates the quantity of a product that has been moved. | m_inventorylinema.MovementQty numeric Quantity |
| Date Material Policy | Time used for LIFO and FIFO Material Policy | This field is used to record time used for LIFO and FIFO material policy | m_inventorylinema.DateMaterialPolicy timestamp without time zone Date |
| Auto Generated | Record is Auto Generated by System. | m_inventorylinema.IsAutoGenerated character(1) Yes-No |