9.05. Inventory Move

The "Inventory Move" document is used to register product transfers between warehouses.

The inventory move has an internal characteristic and is used within a single organization. It allows you to move the stock from one warehouse to another or from one locator to another, inside the same warehouse.

It decreases the stock in the source warehouse and increase the stock in the destination warehouse. If confirmation document types are not used, then the stock is instantly updated when processing the document.The document generates an accounting entry -3XX-3XX.

Inventory Move window

The Inventory Move window, located in the Material Management menu, is used to manage inventory moves. To enter an inventory move, press the New Record button. The following fields are available:

• Document No - the document number (if not entered manually the system will automatically generate a number);

• Document Type - a sub-type of the base document type: "Material Movement". Details in Document Types;

  • if the source warehouse and destination warehouse are the same the system will automatically suggest the first document type without confirmation available;

  • if the source warehouse and destination warehouse are different, the system will automatically suggest the first document type with double confirmation available;

  • "Material Movements with Confirmation" - when completing the inventory move, confirmations will be generated. In order for the inventory move to generate its system effects, the confirmations need to be completed. The confirmations can be operated in the Move Confirmation window, located in the Material Management menu;

    • Starting with v16.04, Material Movement Confirmations can not be deleted anymore. A confirmation can only be deleted by cancellation of it's corresponding Material Movement;

    • Starting with v16.05 users can no longer manually delete or enter Material Movement confirmations;

    • Starting with 17.10, it is no longer possible to enter (import or add via web services/APIs) Material Movements between warehouses if the source warehouse and the destination warehouse are both Legal Entities. Determination is based on the "Parent Organization" field from the Organization Info. It is recommended that "Legal Entity" type of organizations that have work points to be organized into distinct groups (consolidation levels). Example:

• • • • According to the above picture the Material Movements can be made as follows:

        • Between the warehouses of organizations Test A SRL, Test A1 srl, Test A2 srl;

        • Between the warehouses of organizations Test B SRL, Test B SRL - PL;

        • Can not be made between Test A SRL, Test B SRL, WineEvent SRL.

• Movement Date - date of the inventory transfer;

• Account Date - date used to register the resulting accounting transactions;

• Warehouse - the source warehouse from where the transfer is done;

• Warehouse To - the source locator (from the source warehouse) from where the transfer is done;

• Locator - the destination warehouse where the transfer is done;

• Locator To - the destination locator (from the destination warehouse) where the transfer is done;

The Reference Section contains accounting dimensions used for analysis, determined by the accounting schema. Details in Accounting:

• Trx Organization - the source cost/profit center;

• Trx Organization To - the destination cost/profit center;

Status Section displays information about the document status (according to the document workflow):

• In Transit - the inventory movement is in transit - shipped, but not received. The transaction is completed, if confirmed;

• Approved - indicates if the document needs approval before being processed;

• Approval Amount - approval amount set by the document workflow. Details in Workflows.

• Date received - confirmation date, when the products are received by the source destination;

• Document Status - indicates the current status for the document:

  • Initial Status: "Drafted" - the document is being defined. Editing is allowed;

• Document Action button - used to change the document's' status. Available document actions are:

  • "Complete"

    • • -> Document Status: "Completed" - the document has generated its effects within the system;

      • -> Document Status: "In Progress" - after being completed the document generated confirmations. The document will get the "Completed" status after all its confirmations completed. Editing is no longer allowed;

• • • the stock will be updated according to the document lines;

• • "Void" -> Document Status: "Voided" - the document effects within the system have been cancelled;

• • • when voiding a "Drafted" document, all the quantities will be set to 0 and the document will become uneditable;

    • when voiding an "In Progress" document, all the quantities will be set to 0, the document will become uneditable and all the related confirmations will be deleted;

    • when voiding a "Completed" document, a new identical document will be generated with opposite quantities on lines and the following specific properties:

      • Document Date = date on the voided document;

      • Document Status = "Reversed";

      • Description = voided document number;

• • "Reverse" -> Document Status: "Reversed" - the document effects within the system have been reversed;

• • • a new identical document will be generated with opposite quantities on lines and the following specific properties:

      • Document Date = current date;

      • Document Status = "Reversed";

      • Description = reversed document number;

• • "Close" -> Document Status: "Closed" - no other document action can be applied. Documents cannot be generated based on this document. A document can only be closed if it has no unprocessed documents associated.

• Completed By - displays the user who "completed" the document;

Copy Lines button - starts a process that will copy lines to the Inventory Move from a similar document.

Inventory Move Lines

Inventory move lines can be entered manually or automatically, using the Copy Lines button. In the Move Line tab a line will be entered for each product transferred. To enter a line press the New record button. The following fields are available:

• Product - the transfered product;

• Attribute Set Instance, Attribute Set Instance To - if applicable, select the source lot and destination lot;

• Locator - the source locator (from the source warehouse);

• Locator To - the destination locator (from the destination warehouse);

• Quantity - enter the product quantity for the selected unit of measure;

• UOM - if a conversion between units of measure has been defined, an alternate unit of measure can be used on the order;

• Movement Quantity - the product quantity transfered, displayed in the base unit of measure;

• Target Quantity - the quantity which should be be received;

• Confirmed Quantity - confirmed quantity received by the destination warehouse;

• Scrapped Quantity - product quantity lost during transfer;

Note: Starting with v15.03, when entering a quantity, the system will check the current stock and the in progress stock (from "Drafted", "In Progress", "Invalid" inventory move documents). If applicable, the user will be informed that he will register an inventory use which will surpass the existing product stock.

In the Stock Balance report, the product quantities involved in the inventory move will be displayed as such:

• For the source warehouse, the Movement Qty IN and Cost Qty IN fields will be registered with negative sign.

• For the destination warehouse, the Movement Qty IN and Cost Qty IN fields will be registered with positive sign.

Actual Costs Section:

• Cost Price - unit cost, according to warehouse discharge, for the selected product. Details in Costs.

• Cost Value - displays the total cost: Qty * Cost;

Inventory Transaction tab - displays the resulting inventory transactions after processing the document;

Attributes tab - displays the transferred product attribute set instances.

Posting Rules

Posting an Inventory Move will generate accounting transactions for each line, as such: