The MRP exclusions list view shows the demands that have been excluded from MRP along with the reason why.
Standard columns include:
Type: The type of demand. One of:
AB – Aggregate Bucket
SO – Sales Order
PRO – Proforma Sales Order
QUO – Quotation (Sage 50 Accounts)
MFS – Make for Stock Demand
SF – Sales Forecast
ROL – Re-order Level Demand
WO – Works Order
Reference: The demand reference.
Stock Code: The demand item stock code.
Description: The demand item description.
Qty Required: The quantity required by the demand.
Due Date: The due date on the demand.
Exclusion Reason: The reason why the demand has been excluded by MRP.
Resource servicing exclusions
The Exclusions list view also surfaces machine resources and tooling resources that Cim50 was unable to produce a service recommendation for, because of a problem with the resource’s configuration. These appear with a Type of “Resource Machine” or “Resource Tool” and use the resource’s reference and description in place of the stock columns.
You will see a resource on the Exclusions list view in any of the following cases:
The resource has a machine-hours service interval but no Last Serviced date is set against it. Cim50 needs a Last Serviced date to use as the starting point for totaling up the machine hours. Set a Last Serviced date on the resource record in the Bill of Materials module to clear the exclusion. The Exclusion Reason on these rows reads “Hours-mode resource has no Last Serviced datetime to measure usage from”.
The resource has a time-based service interval (Days, Weeks, Months or Years) with an interval greater than one, but no Last Serviced date is set against it. As above, Cim50 needs a baseline date to measure elapsed time from. Set a Last Serviced date to clear the exclusion. The Exclusion Reason on these rows reads “Time-mode resource has no Last Serviced datetime and interval is greater than one [days/weeks/months/years]”.
The resource has a Last Serviced date that is in the future. Cim50 cannot use a future date as the baseline for either time-based or machine-hours service intervals. Open the resource record and correct the Last Serviced field. The Exclusion Reason on these rows reads “Last Serviced datetime is in the future — check the configured value”. Note: this particular case also shows on the Servicing list view as a configuration warning, so you can spot and correct it from either screen.
To investigate or correct a resource servicing exclusion, open the affected Machine Resource or Tooling Resource from the Bill of Materials module and review its service interval settings.
Note: A resource that has its Frequency set to None, or an Interval Value of zero, is not considered to be on a service schedule and will not appear on either the Servicing or the Exclusions list view.
