Window: Inventory Move
[Created: 19/12/1999 - Updated: 03/06/2021 ]
Description: Inventory Move
Help: The Inventory Move Window allows you to move inventory from one location or warehouse to another. After the appropriate lines are entered selecting the 'Process Movements' button will adjust the inventory.
Tab: Move
[Created: 19/12/1999 - Updated: 17/12/2007 ]
Description: Enter Inventory Movement
Help: The Move Tab defines and identifies the movement of an item or items in inventory.
Tab Level: 0
Table 10: Move - 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_movement.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_movement.AD_Org_ID numeric(10) Table Direct |
| Order Reference | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | The business partner order reference is the order reference for this specific transaction; Often Purchase Order numbers are given to print on Invoices for easier reference. A standard number can be defined in the Business Partner (Customer) window. | m_movement.POReference character varying(20) String |
| 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_movement.DocumentNo character varying(30) String |
| Sales Representative | Sales Representative or Company Agent | The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user. | m_movement.SalesRep_ID numeric(10) Table |
| Description | Optional short description of the record | A description is limited to 255 characters. | m_movement.Description character varying(255) String |
| 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_movement.MovementDate timestamp without time zone Date |
| Document Type | Document type or rules | The Document Type determines document sequence and processing rules | m_movement.C_DocType_ID numeric(10) Table Direct |
| Warehouse | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | m_movement.M_Warehouse_ID numeric(10) Table Direct |
| Warehouse To | To Storage Warehouse and Service Point | The Warehouse To indicates the Warehouse where the inventory is being moved to | m_movement.M_WarehouseTo_ID numeric(10) Table |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | m_movement.C_BPartner_ID numeric(10) Search |
| Partner Location | Identifies the (ship to) address for this Business Partner | The Partner address indicates the location of a Business Partner | m_movement.C_BPartner_Location_ID numeric(10) Table Direct |
| Shipper | Method or manner of product delivery | The Shipper indicates the method of delivering product | m_movement.M_Shipper_ID numeric(10) Table |
| User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | m_movement.AD_User_ID numeric(10) Table Direct |
| Delivery Via | How the order will be delivered | The Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped. | m_movement.DeliveryViaRule character(1) List |
| Delivery Rule | Defines the timing of Delivery | The Delivery Rule indicates when an order should be delivered. For example should the order be delivered when the entire order is complete, when a line is complete or as the products become available. | m_movement.DeliveryRule character(1) List |
| Priority | Priority of a document | The Priority indicates the importance (high, medium, low) of this document | m_movement.PriorityRule character(1) List |
| Freight Cost Rule | Method for charging Freight | The Freight Cost Rule indicates the method used when charging for freight. | m_movement.FreightCostRule character(1) List |
| Project | Financial Project | A Project allows you to track and control internal or external activities. | m_movement.C_Project_ID numeric(10) Table Direct |
| Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | m_movement.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_movement.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_movement.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_movement.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_movement.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_movement.IsApproved character(1) Yes-No |
| Approval Amount | Document Approval Amount | Approval Amount for Workflow | m_movement.ApprovalAmt numeric Amount |
| In Transit | Movement is in transit | Material Movement is in transit - shipped, but not received.The transaction is completed, if confirmed. | m_movement.IsInTransit character(1) Yes-No |
| Date Received | Date a product was received | The Date Received indicates the date that product was received. | m_movement.DateReceived timestamp without time zone Date |
| 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_movement.DocStatus character(2) List |
| Process Movements | Process Inventory Movements | Process Inventory Movements will update inventory quantities based on the defined movements between warehouses or locations. | m_movement.DocAction character(2) Button |
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | m_movement.Processed character(1) Yes-No |
| Posted | Posting status | The Posted field indicates the status of the Generation of General Ledger Accounting Lines | m_movement.Posted character(1) Button |
Tab: Move Line
[Created: 19/12/1999 - Updated: 16/03/2021 ]
Description: Enter Inventory Movement Line
Help: The Move Line Tab defines the product and quantity to be moved and the location it is moving from and to.
Tab Level: 1
Table 20: Move 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_movementline.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_movementline.AD_Org_ID numeric(10) Table Direct |
| Inventory Move | Movement of Inventory | The Inventory Movement uniquely identifies a group of movement lines. | m_movementline.M_Movement_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_movementline.Line numeric(10) Integer |
| Description | Optional short description of the record | A description is limited to 255 characters. | m_movementline.Description character varying(255) String |
| Active | 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. | m_movementline.IsActive character(1) Yes-No |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_movementline.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_movementline.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Attribute Set Instance To | Target Product Attribute Set Instance | m_movementline.M_AttributeSetInstanceTo_ID numeric(10) Product Attribute | |
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | m_movementline.M_Locator_ID numeric(10) Locator (WH) |
| Locator To | Location inventory is moved to | The Locator To indicates the location where the inventory is being moved to. | m_movementline.M_LocatorTo_ID numeric(10) Locator (WH) |
| Quantity | The Quantity Entered is based on the selected UoM | The Quantity Entered is converted to base product UoM quantity | m_movementline.QtyEntered numeric Quantity |
| UOM | Unit of Measure | The UOM defines a unique non monetary Unit of Measure | m_movementline.C_UOM_ID numeric(10) Table Direct |
| Movement Quantity | Quantity of a product moved. | The Movement Quantity indicates the quantity of a product that has been moved. | m_movementline.MovementQty numeric Quantity |
| Target Quantity | Target Movement Quantity | The Quantity which should have been received | m_movementline.TargetQty numeric Quantity |
| Scrapped Quantity | The Quantity scrapped due to QA issues | m_movementline.ScrappedQty numeric Quantity | |
| Confirmed Quantity | Confirmation of a received quantity | Confirmation of a received quantity | m_movementline.ConfirmedQty numeric Quantity |
Tab: Attributes
[Created: 27/08/2005 - Updated: 16/03/2021 ]
Description: Product Instance Attribute Material Allocation
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_movementlinema.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_movementlinema.AD_Org_ID numeric(10) Table Direct |
| Move Line | Inventory Move document Line | The Movement Line indicates the inventory movement document line (if applicable) for this transaction | m_movementlinema.M_MovementLine_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_movementlinema.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_movementlinema.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_movementlinema.DateMaterialPolicy timestamp without time zone Date |
| Auto Generated | Record is Auto Generated by System. | m_movementlinema.IsAutoGenerated character(1) Yes-No |