Use the Material Reconciliation window to make stock reconciliations for a warehouse. This includes freezing and unfreezing (sometimes called locking and unlocking) material transaction approvals for the part of the warehouse undergoing reconciliation. During reconciliation, material transactions can take place, but they cannot be approved (because that is when stock amounts are adjusted). Only one reconciliation effort can occur within a warehouse at one time. Only the current reconciliation (the one with the highest ID) can have its inventory reconciliation amounts edited.

The history of all reconciliations is available through this window. All fields are read-only for historical reconciliation records.

The Material Reconciliation window has two tabs: Freezing and Count.

Freezing Tab

The Freezing tab is used to begin a reconciliation effort and assign bins to be reconciled (by material class code selection). Once a reconciliation is underway, you also use this tab to complete the reconciliation by assigning a reconciliation reason to all inventory adjustments as well as generating and approving all inventory adjustment transactions.

The Freezing tab contains two panes: the Reconciliation pane and the Class Codes pane.

The Reconciliation pane shows information about reconciliations performed in the past, including the date the stock items were frozen and the reconciliation ID. When you right-click or select Actions, the common commands are available along with the following special commands:

• Complete Reconciliation: This command completes the reconciliation, which sets the reconciliation's completion date, permits (unfreezes) warehouse transaction approval, and also allows future reconciliations.
• Freeze Reconciliation: Once a reconciliation record is inserted, this command halts all transactions involving materials assigned the class codes selected during the record insertion process. It also enters today's date in the Date Started column.
• Insert: This command is available only when no open reconciliation currently exists. When available, it initiates a reconciliation by displaying a dialog box to select the classification codes of the materials that will be part of this reconciliation. Select materials by either clicking the square beside the name of the material or right-clicking the material and selecting the appropriate selection command. A check mark indicates when the classification code is selected. Once all classification codes are selected, click OK to close the dialog box. The selected class codes will then be shown in the Class Codes pane and the materials assigned the classification codes are shown on the Count tab.

For the selected reconciliation, the Class Codes pane shows the materials that are being reconciled.

Count Tab

For the reconciliation record selected in the Freezing tab, the Count tab provides a record for each material that is assigned one of the selected classification codes. Fields are provided to enter a corrected amount of stock on hand along with a unit cost for the stock.