Display Item per Facility

This instruction explains how to display an item per facility.

Outcome

The balance is displayed on the facility level. This is the level MPM works with.

Used for global planning and average price setting.

The item/facility connection is stored in the MITFAC file.

Before you start

  • In 'Item. Open' (MMS001/) you must enter 1 = Inventory accounted in the 'Inventory accounting' field. .
  • The balance is only totaled at the facility level if the 'On-hand balance total' field is activated in 'Warehouse Type. Open' (MMS006).

Follow these steps

  1. Open 'Item. Connect Facility' (MMS003). Option 25=Purchase costs, starts 'Purchase Distribution Costing. Calculate' (PCS280) and option 26=Product costing, calls 'Product Costing. Display' (PCS300). The functionality could be compared with the options in 'Product structure. Open' (PDS001).

  2. Open the E panel. Enter 1 = Accumulate changes in balance regarding statuses 2 and 3 in the 'On-hand method' field.

  3. The 'On-hand,' 'On-hand inspect' and 'On-hand reject' fields display the balance on the facility level.

    The E panel:

    • Press F14 to activate 'Average Cost. Display/Update History' (CAS371) where average price history is displayed
    • Press F16 to activate 'Item. Display Stock Transaction History' (MMS071) where stock transaction history per facility is displayed.

      Note: The balance must be totaled for the facility level (MITFAC) if average price handling or planning on facility level is used.

      For average price handling, the 'Inventory accounting method' field is set to 2 = Average cost in 'Item. Open' (MMS001/E)

      For planning on the facility level, the 'Planning method' field is set to 4 = Reorder point planned per item and facility in 'Item. Connect Warehouse' (MMS002/E).