MRP Exclusion Utility
The MRP Exclusion Utility (MRPEU) replaces the Manufacturing “MRP Exclusions” window. MRPEU pulls together into one place all the different sources of “Calculate MRP” settings:
- Location Code (Site) Resource Planning window
- Item Engineering
- Item Resource Planning
- MRP Exclusions Table
This makes it easy to see why an item or site is, or is not, being included in MRP and to fix it. Additionally, the MRPEU window can perform mass updates to assist in quickly getting MRP configured correctly.
ROLLDOWN: The Calc MRP flag and the MRP Setting can be rolled-down to selected lines. “Selected” means the lines shown in the window. If you use the restriction criteria fields to restrict the window the rolldown will only affect the displayed records. You will be prompted to confirm you want to do the rolldown.
The MRP Setting rolldown only updates the MRP Exclusions table and only if the setting being rolled-down is compatible with the Calc MRP flag. For example, if you rolldown “Calculate but not show” it will only be applied to records where Calc MRP is TRUE.
Exclusion Views
Each view show a different slice of the MRP Exclusion Table data. Work Centers shows the list of Work Centers and the MRP Setting assigned to each Work Center. Items/Item Engineering shows the list of Items and the MRP Setting assigned to each Item. MRP Exclusions table shows everything currently in the table. NOTE: the MRP Exclusions table does not just store “exclusions” because some of the options control how and item or site is shown in the MRP windows. This can be confusing because if an Item-Site is NOT in the MRP Exclusions table at all that means it is “included” in MRP. However, and Item can have “Calculate MRP” marked on Item Engineering AND also be in the Exclusions table with a setting of “Calculate and show if Active”. Select a View then click REFRESH.
WORK CENTERS: GP Manufacturing requires that a Work Center also be set up as a Location Code (Site) even though you rarely, if ever, store inventory in a Work Center. The MRP Exclusion Utility shows Work Centers separately from “normal” Sites to make it easy to manage them separately. Normally they should not have the Calculate MRP flag marked. Work Centers are stored in WC010015 but one of the keys is EFFECTIVEDATE_I, so getting a list of work centers from this table is complicated by the fact that a single Work Center ID may appear multiple times.
SITES EXCLUDING WORK CENTERS: All Location Codes (Sites) that are not also Work Centers. These are your “normal” inventory locations. Remember that exclusions are additive, so if you need to include some Items in a Site, include the Site and then EXCLUDE the items that should not be calculated. Sites are in IV40700 but the Calc MRP checkbox (Include In Planning) is stored in IV00111 (Site Resource Planning).
UNUSED ITEM-SITE FOR WORK CENTERS: If you have run MRP with MRP Settings of “Calculate but not show” or “Calculate and show if active” it may have created a large number of unnecessary Item-Site records in IV00102. Depending on the number of records they can have a noticeable impact on system performance so you may want to delete them. See the end of the documentation for MRP Exclusion Utility for the query used by the window to identify these records. WilloWare is not recommending you delete records from this table.
ITEMS (ITEM ENGINEERING): Items are included or excluded from MRP on the Item Engineering window. Item Engineering is IVR10015.
ITEM-SITE: Item-Site (Item Resource Planning) is stored in IV00102.
MRP EXCLUSIONS TABLE: This shows the same information you see in the Manufacturing MRP Exclusion List window.