Stock and Inventory Information

Outcome

The balance identity for an item is displayed on three different levels as follows:

• At the lowest level—the location level—all locations where this item is stored are displayed.
• At the next level—the warehouse level—information is displayed about items per warehouse or per warehouses if the item is stored at several warehouses.
• At the highest level that MPM works with, balance per facility can be displayed.
• You can also display stock transaction history and perform date analysis on lot-controlled items.

The information is used for global planning, average price setting, planning, reservations, soft allocation, stock control, allocation, etc.

The following tables are updated:

• Items per facility are stored in the MITFAC table.
• Items per warehouse are stored in the MITBAL table.
• Items per location are stored in the MITLOC table.
• Lot numbers are stored in the MILOMA table.

Before you start

No prerequisites needed.

How

1. Allocations per balance identity

   All locations where an item is stored are displayed in 'Balance Identity. Open Toolbox' (MWS068).

2. Allocations per warehouse

   On the warehouse level, balance IDs are displayed mainly in 'Item. Open Toolbox' (MMS200) and 'Item. Connect Warehouse' (MMS002/H). 'Availability. Display All Warehouses' (MMS081) displays items that are stored at several warehouses.

3. Allocations per facility

   The highest level that we work with in MPM is the facility level. The balance IDs on this level are displayed in 'Item. Connect Facility' (MMS003).

4. Stock transaction history

   Stock transaction history is displayed in 'Stock Transaction. Display History' (MWS070).

5. Date analysis

   Date analysis (expiry date, last sales date, re-inspection date) on lot-controlled items is performed in 'Balance Identity. Analyze per Date Type' (MWS320)

6. Recreate MITBAL and MITFAC

   If there is a problem with balance IDs, these two programs can be useful:

   'On-Hand. Re-Create in MITBAL via MITLOC' (MMS998) and

   'On-Hand. Re-Create in MITFAC via MITBAL' (MMS984).

   These programs also could be useful when installing M3 BE and the parameters have been changed.

7. Consignment stock information

   If an item is under consignment, information about consignment stock quantities per owner and warehouse is displayed in 'Consignment Owner Quantities. Open' (MWS020).

   If the item is both lot controlled and under consignment, information about consignment stock quantities per warehouse, owner, and lot number is also displayed in (MWS020).

8. Pending consignment transactions

   If there is a problem with reporting issue of an item under consignment, information about the active job can be found in 'Pending Consignment Transactions. Open' (MWS025).