MRP Requirements by Item
Form ID: (AM401200)
On this form, you can view item quantities that the system calculates based on the results of material requirements planning (MRP) for a specific item in a specific warehouse. The quantities are grouped by buckets, which are periods defined on the MRP Buckets (AM201200) form. The system aggregates the quantities from the last MRP regeneration by period starting with the current business date. Past-due supply and demand documents are considered for buckets with a negative value (which correspond to past-due periods) specified in the Value column of the MRP Buckets form.
Form Toolbar
The form toolbar includes standard buttons and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands can be shown as buttons on the form toolbar, as commands on the More menu, or in both places. These commands are listed in the following table in alphabetical order.
| Command | Description |
|---|---|
| Detail Inquiry | Opens the Detail Inquiry (AM404000) form for the item and warehouse specified in the Selection area. |
| Inventory Allocation Details | Opens the Inventory Allocation Details (IN402000) form for the item and warehouse specified in the Selection area. |
| Inventory Transaction Details | Opens the Inventory Transaction Details (IN404000) form for the item and warehouse specified in the Selection area. |
| Item Warehouse Details | Opens the Item Warehouse Details (IN204500) form for the item and warehouse specified in the Selection area. |
Selection Area
In this area, you can select the bucket, item, and warehouse for which you would like to view the MRP regeneration results. You can also view item settings, which are read-only.
| Element | Description |
|---|---|
| Bucket ID | The identifier of the bucket for whose periods you would like to view data. |
| Inventory ID | The identifier of the item for which you would like to view data. |
| Warehouse |
The warehouse in which the item is stored. By default, the system inserts the default warehouse specified for the item on the General tab of the Stock Items (IN202500) form. You can select another warehouse, if needed. This box is visible only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form. |
| Qty. on Hand | The on-hand quantity of the item that the system used for the last MRP regeneration, which may differ from the current on-hand item quantity. |
| Product Mgr. |
The product manager assigned to the item. If the item is stored in only one warehouse, the system inserts the product manager specified for the item in the Summary area of the Stock Items form. If the item is stored in multiple warehouses, the system inserts the product manager specified for the item and warehouse in the Summary area of the Item Warehouse Details form. |
| Safety Stock |
The safety stock specified for the selected item and warehouse. If the item is stored in only one warehouse, the system inserts the safety stock specified for the item on the Manufacturing tab of the Stock Items form. If the item is stored in multiple warehouses, the system inserts the safety stock specified for the item and warehouse on the Manufacturing tab of the Item Warehouse Details form. |
| Rep. Source |
The replenishment source specified for the selected item and warehouse. If the item is stored in only one warehouse, the system inserts the replenishment source specified for the item on the Manufacturing tab of the Stock Items form. If the item is stored in multiple warehouses, the system inserts the replenishment source specified for the item and warehouse on the Replenishment tab of the Item Warehouse Details form. |
| Preferred Vendor ID |
The default vendor of the item with the Purchase replenishment source. The system inserts the vendor specified for the item on the Vendors tab of the Stock Items form. |
| Lead Time | The lead time in days for the vendor displayed in the Preferred Vendor ID box. The system calculates this value as the sum of the Lead Time (Days) and Add. Lead Time (Days) columns for the vendor row on the Vendors tab of the Stock Items form. |
Table
In the table, you can view the quantities the system calculated based on the results of material requirements planning for the item and warehouse you specified in the Selection area. The quantities are grouped by periods of the bucket you also specified in the Selection area.
The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
| Column | Description |
|---|---|
| From Date | The starting date of the period. |
| To Date | The ending date of the period. |
| Begin Qty | The on-hand item quantity at the start of the period. For the first bucket, it is the current on-hand quantity. |
| Actual Supply | The available item quantity. The system calculates the quantity as the sum of the beginning quantity and the item quantities in open purchase orders, production orders, and transfer orders within the period. |
| Actual Demand | The item quantity that is on demand. The system calculates the quantity as the sum of item quantities in production orders for materials, sales orders, shipments, and transfer orders within the period. |
| Net Qty | The difference between the actual supply quantity and actual demand quantity. A negative value indicates that the available item quantity is insufficient to meet the demand. |
| Planned Supply | The sum of item quantities in planned orders created by MRP and MPS (master production schedule) in the period. |
| Planned Demand | The sum of item quantities in forecasts and planned orders that generate demand for other production orders in the period. |
| End Qty |
The projected on-hand quantity of the item at the end of the period. The system
calculates this quantity as follows: This quantity becomes the beginning quantity for the next period. |