Skip to content

MRP Orders Causing Shortages — Drilldown

This documentation describes the drilldown feature on the MRP Orders Causing Shortages report (COrdersCausingShortages). The drilldown lets a user click a row in the main report and open a focused MRP Details view scoped to the relevant item, location, and week.

What the feature does

When a user double-clicks a row on the main report, the drilldown opens a new tab containing the MRP details that are causally related to the shortage on that row. The result set is narrowed by three things:

  1. The item on the clicked row (and any items related to it via the bill of materials).
  2. The location on the clicked row, if item_loc is included as a column on the main report.
  3. The week containing the row's MRP transaction date, where "week" is defined by the main calendar's configured production week start day.

If the user has not yet saved a layout for the drilldown, a sensible default layout is applied automatically — grouped by item_no with seventeen visible columns covering the standard MRP detail set.

Files touched

The change is contained entirely within COrdersCausingShortages.vb. No changes were required to PulseDevTools, the optimized table base, the calendar, or any shared UI code.

How to read this site

  • Architecture explains how the drilldown plugs into the box module lifecycle and which infrastructure it reuses.
  • Drilldown criteria documents how the WHERE clause is built and where each piece comes from.
  • Default layout fallback explains the empty-layout detection and the programmatic configuration of visible/grouped columns.
  • Color coding documents the conditional row appearance rules.
  • Reference is a flat list of the new methods, fields, and matrix elements involved.