| # Check and Repair Inventory (whwmd6290m000) Use this session to rebuild the inventory quantities for selected warehouses and items. To rebuild the inventory, inbound and outbound order related data such as receipts, inbound or outbound advice, shipments, and so on, is used. The quantities listed on this order data is used to rebuild the inventory tables related to the following sessions: Item Inventory (tcibd1500s100) Warehouse - Item Inventory (whwmd2515m000) Warehouse - Item Inventory Ownership (whwmd2615m000) Inventory by Warehouse, Item and Effectivity Unit (whwmd2516m000) Warehouse - Item - Lots Inventory (whltc1505m000) Stock Point Inventory (whinr1540m000) Item - Serials and Warehouses (whltc5100m000) Item - Inventory Structure (whinr1550m000) Note that as a result, the existing data in these sessions are overwritten. If the applicable valuation method is lot pricing, the lot inventory on hand present in the Warehouse - Item - Lots Inventory (whltc1505m000) session is balanced with the inventory receipt transactions present in the Inventory Receipt Transactions (whina1512m000) session per item, warehouse and lot. If the applicable valuation method is serial pricing, the serial inventory on hand present in the Item - Serials and Warehouses (whltc5100m000) session is balanced with the inventory receipt transactions per item, warehouse and serial. For the other valuation methods, the inventory on hand present in the Warehouse - Item Inventory (whwmd2515m000) session is rebuilt based on the quantity be to consumed present in the Inventory Receipt Transactions (whina1512m000) session. Before actually correcting the inventory data, you can perform a trial run using the Simulate option in the Update Mode group box. Note that in addition to the selected report options, ERP Enterprise prints an error report and an information message report listing the information messages generated during the actual or simulated inventory rebuilding process. Warehouse The warehouse or warehouses whose inventory you want to rebuild. Warehouse The warehouse or warehouses whose inventory you want to rebuild. From Item The item or items for which you want to rebuild the inventory. To Item The item or items for which you want to rebuild the inventory. Correct On Hand Inventory based on Inventory Receipt Transactions If this check box is selected, the inventory on hand present in the Warehouse - Item Inventory (whwmd2515m000) session is rebuilt based on the quantity be to consumed present in the Inventory Receipt Transactions (whina1512m000) session. If this check box is cleared, the inventory on hand present in the Warehouse - Item Inventory (whwmd2515m000) session is not changed. However, the inventory on hand is also rebuilt based on open order data such as receipts, inbound or outbound advice, shipments, and so on. This calculated quantity is the minimum quantity on hand regardless of the setting of this check box. Allow Automatic Processing of Adjustment Orders If this check box is selected, adjustment orders are automatically created and processed to balance the inventory receipt transactions present in the Inventory Receipt Transactions (whina1512m000) session with the the Warehouse - Item Inventory (whwmd2515m000) session. To balance the inventory receipt transactions with the order data, it may be required to insert missing receipt transactions. This is done by automatically creating and processing adjustment orders. For example, if 100 items A are present in the Inventory Receipt Transactions (whina1512m000) session, but 150 items A are allocated to outbound order data, such as outbound order lines, shipment lines and so on, adjustment orders are created and processed to insert new receipt transactions to balance the difference of 50 items A. If this check box is cleared, the inventory is not rebuilt if adjustment orders are required as shown in the previous example, but a message appears saying that adjustment is required and showing by how much the inventory receipt transaction quantity differs from the expected quantity. This can be regarded as trial run, thus you know how much inventory is to be adjusted, before actually rebuilding the inventory. Because inserting inventory receipt transactions impacts the financially registered inventory value, you may consider rebuilding the inventory without selecting this check box first. Employee The ID of the employee who performs the automatic adjustments by selecting the Allow Automatic Processing of Adjustment Orders check box. Employee The name of the employee who performs the automatic adjustments by selecting the Allow Automatic Processing of Adjustment Orders check box. Reason for Adjustment The code of the reason for the inventory adjustment. Reason for Adjustment The description of the reason for the inventory adjustment. Location If the rebuilt quantity of a location controlled item is larger than the existing quantity, the difference is automatically added to the correction location. For example, item A is location controlled. Before correction, 10 items A are present in pick location X and 15 items A in bulk location Z. If the correction result is 34 items A, 9 items A are put in the correction location. The correction location is manually inserted. If it is not present in the system, it is generated during the rebuild process. By default, the correction location is of type Bulk and it is blocked for inbound and outbound movements. After the rebuild process is completed, you can use adjustment orders to store the items in the required locations. You are recommended to always use the same correction location, because ERP Enterprise only recognizes the correction location defined in the current run. ERP Enterprise regards correction locations from previous correction runs as regular locations. If the inventory must be decreased during a particular correction run, ERP Enterprise first reduces the inventory from the correction location. If the required reduction exceeds the quantity on the correction location, inventory is decreased from the other locations, without reducing any inventory from the previous correction locations first. Lot If the rebuilt quantity of a lot controlled item is larger than the existing quantity, the difference is automatically added to the correction lot. For example, item A is lot controlled. Before correction, 10 items A are present in lot X and 15 items A in lot Z. If the correction result is 34 lot items A, 9 items A are put in the correction lot. The correction lot is manually inserted. If it is not present in the system, it is generated during the rebuild process. After the rebuild process is completed, you can use adjustment orders to store the items in the required lots. You are recommended to always use the same correction lot, because ERP Enterprise only recognizes the correction lot defined in the current run. ERP Enterprise regards correction lots from previous correction runs as regular lots. If the inventory must be decreased during a particular correction run, ERP Enterprise first reduces the inventory from the correction lot. If the required reduction exceeds the quantity on the correction lot, inventory is decreased from the other lots, without reducing any inventory from the previous correction lots first. Print Inventory Structure If this check box is selected, ERP Enterprise prints both the Check and Repair Inventory Structure report and the Check and Repair Inventory report. If this check box is cleared, ERP Enterprise prints only the Check and Repair Inventory report. The Check and Repair Inventory Structure report prints the inventory quantities before and after correction displaying the data of the Item - Inventory Structure (whinr1550m000) session. The Check and Repair Inventory report displays the inventory quantities before and after correction of the inventory tables, which are expressed in inventory unit. The related sessions of these tables are: Item Inventory (tcibd1500s100) Warehouse - Item Inventory (whwmd2515m000) Warehouse - Item Inventory Ownership (whwmd2615m000) Inventory by Warehouse, Item and Effectivity Unit (whwmd2516m000) Warehouse - Item - Lots Inventory (whltc1505m000) Stock Point Inventory (whinr1540m000) Item - Serials and Warehouses (whltc5100m000) The inventory quantities on this report are displayed according to the inventory hierarchy in ERP Enterprise: Item Inventory Warehouse – Item Inventory Inventory by Item, Warehouse, and Owner Inventory by Item, Warehouse and Effectivity Unit Warehouse – Item – Lots Inventory Stock Point Inventory Item – Serials and Warehouses Inventory Print Only Differences If this check box is selected, only the differences the between existing inventory and the rebuilt inventory is printed (that is, if there is no difference between the existing quantity and the rebuilt quantity, the item is not printed). Suppress Zero Inventory If this check box is selected, Items without inventory in both existing and rebuilt inventory are not printed. This option is not available if the Print Only Differences check box is selected. Print Basic Report If this check box is selected, the information of the Check and Repair Inventory report is printed but the attributes of the printed quantities are printed on a single line separated by the pipe (|) sign to allow easy export to a spreadsheet for analysis. For a description of the Check and Repair Inventory report, see Print Inventory Structure. Update Mode Select Simulate to perform a trial run, that is, only print reports as specified before actually rebuilding the inventory quantities. Select Update to actually rebuild the inventory quantities and print reports as specified. Continue Use this command to launch the process of rebuilding the inventory for the selected items and warehouses according to the settings specified in this session. |