MRP Exclusion Utility

MRP Exclusion Utility

HelpID: 497022140

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.

Setup

Navigation: Tools >> Setup >> Manufacturing >> MFG PowerPack Setup

To enable the MRP Exclusion Utility, mark the box next to “MRP Exclusion Utility”.

Click DONE.

Close GP then log-in again to activate it.

Using MRP Exclusion Utility

Navigation:

  • Transactions >> Manufacturing >> MRP Exclusion Utility
  • Tools >> Utilities >> Manufacturing >> MRP Exclusion Utility
  • Opens automatically if you open the MRP Exclusion List window

A screenshot of a computer AI-generated content may be incorrect.

NOTE: Manufacturing’s MRP Exclusion List window uses rather confusing terms for the “Type” dropdown list. Below are the list of options in that window and what they mean.

  • View Only: Include in the MRP calculation but do not show in the MRP windows
  • View and Calculate: Do not include in the MRP calculation and do not show in the MRP windows
  • Inactive: Include in the MRP calculation and only show in the MRP windows if there is activity

The WilloWare MRP Exclusion Utility (MRPEU) window has uses different wording the MRP Setting dropdown list. Note that the column header for the “exclusions” says “In MRP it will:”

  • Calculate but not show
  • Not calculate or show
  • Calculate and show if active
  • Calculate and show

A screenshot of a computer AI-generated content may be incorrect.

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 Calc MRP rolldown will update the underlying records (i.e. Site Resource Planning, Item Engineering, or Item Resource Planning) and also set the MRP Setting to be compatible. If Calc MRP is TRUE then MRP Setting is “Calculate and Show” (which actually means there is no record in the MRP Exclusions table). If Calc MRP is FALSE then MRP Setting is “Not calculate or show”.

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.

MRP EXCLUSION LOGIC: The MRP Exclusions are additive so that when checking if it should plan 100XLG in NORTH, that combination will NOT be included if:

  • 100XLG is excluded (Calc MRP not marked in Item Engineering), or
  • NORTH is excluded (Calc MRP is not marked in Site Resource Planning), or
  • 100XLG-NORTH is excluded (Calc MRP is not marked in Item Resource Planning).

When thinking about how to use these settings start at the highest level with what you DO NOT want in MRP:

  • Should I include this site? If so, mark the Calculate MRP checkbox in Site Resource Planning
  • Should I include this item? If so, mark the Calculate MRP checkbox in Item Engineering
  • Should I include this item in this site? If so, mark the Calculate MRP checkbox for the Item-Site in Item Resource Planning

Then run the REBUILD EXCLUSIONS utility and use MRPEU to validate the results.

IMPORTANT: MRP will create new Item-Site records in IV00102 (Item Quantities Master/Item Resource Planning) if the Item-Site is in the MRP Exclusions table with any setting other than “Not calculate or show”. If looking at the MRP Exclusion List window, if an Item-Site has Type “View Only” or “Inactive” it will create an Item-Site record if one does not already exist. We strongly recommend using only “Not calculate or show” or “Calculate and show” because these correspond directly to Calc MRP unmarked/marked and neither will cause MRP to create IV00102 records.

REBUILD EXCLUSIONS: You will be asked to confirm you want to do this before it runs. Rebuild Exclusions runs a GP Manufacturing stored procedure ( ) that clears the MRP Exclusions table (MP030000) and repopulates it based on the “Calculate MRP” checkbox in the following locations:

  • Item Engineering
  • Site Resource Planning
  • Item Resource Planning

It is possible for the settings in those locations to become out of sync with the MRP Exclusions table. If you are having trouble figuring out why some items are, or are not, included in MRP running the Rebuild Exclusions routine is a good place to start.

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.

Unused Item Sites Query

A screenshot of a computer code AI-generated content may be incorrect.