Stock Balance
The Stock Balance model provides analysis on an item connected to several warehouses. The analysis covers the quantity of items that are allocated, for allocation, on-hand balance approved, on-hand balance for inspection, and rejected on-hand balance with its corresponding gross weight, net weight, and volume.
The model also provide information with regards to acquisition, material planning, method safety time, planning horizon, supply lead time, and time fences. Safety stock method is set for the item or warehouse combination.
The facts in this model can be analyzed by Last Receipt Date and Last Issue Date.
Source information
The main source for this model is the master file of Item – Warehouse (MITBAL) from M3 BE. The master file is automatically updated when transactions are made from the maintaining program, MMS002 (Item.Connect Warehouse).
- Master file of Item – Facility (MITFAC) from M3 BE
The model references to this master file to retrieve the Country of Origin, Customs Statistical Number, User-Defined Accounting Control Object, and Inventory Accounting Method.
- Item Dimension (MITMAS)
The model references to this dimension to retrieve the multiplier factors (Gross Weight, Net Weight, and Volume) used to calculate the measures.