This document explains how to display and analyze information about stock and inventory.
The balance identity for an item is displayed on three different levels as follows:
The information is used for global planning, average price setting, planning, reservations, soft allocation, stock control, allocation, etc.
The following tables are updated:
Allocations per balance identity
All locations where an item is stored are displayed in 'Balance Identity. Display' (MWS060).
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.
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).
Stock transaction history
Stock transaction history is displayed in 'Stock Transaction. Display History' (MWS070).
Date analysis (expiry date, last sales date, re-inspection date) on lot-controlled items is performed in 'Balance Identity. Analyze per Date Type' (MWS320)
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.
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).
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).