MRP in Business Central: Common Issues And Solutions

Scheduling the replenishment of stock using MRP in Business Central is not always straightforward. As Dynamics consultants, it’s not unusual for customers to come to us expressing their confusion. The purpose of this blog is to look at two of the most common issues which cause problems and discuss how Business Central can handle them.

The MRP issues in Business Central we will cover

  • Out of date or generally inaccurate planning parameters on the Item Card
  • Overly convoluted Planning or Requisition Worksheets, caused by multiple small changes to planning Line suggestions
  • MRP suggests changes which cannot be acted upon. For example, where some vendors are not in a position to adjust quantities or amend dates to an existing Purchase Order. Similarly, where the shop floor cannot easily accommodate changes to the existing Production & Assembly Orders

How does Business Central deal with this?

Business Central has a variety of tools to tackle all of the above. Establishing your MRP process allows you to gain full control over one of the most functionally-rich areas of the Manufacturing module. By resolving issues early, you will save bundles of time and countless future headaches generating planning spreadsheets manually.

Maintaining MRP parameters with RapidStart

The planning parameters are an essential part of running MRP. Their accuracy is paramount to producing suggestions that are realistic and helpful. If you have to manually amend planning Lines each time you run MRP, you’re losing the benefit of having those calculations run in the background! Keeping tabs on all items’ planning parameters, especially when there are thousands, can be a mammoth task. But keeping the Planning and Requisition Worksheet recommendations logical and accurate is crucial.

The effectiveness of the MRP process is directly related to the accuracy of the planning parameters on each item. Maintaining item planning parameters can be an onerous task, especially when it has to be done on an Item by Item basis. When you have a couple of thousand items in the system, you can imagine how arduous this can be! If you neglect these parameters, it massively impairs the effectiveness and accuracy of the Planning and Requisition Worksheet recommendations.

In Business Central, users can mitigate these issues. I say ‘mitigate’ and not ‘remove’ as users must still enter the planning details for items. But you can manage this using RapidStart. Simply export the MRP planning parameters to Excel and make any necessary amendments. You can subsequently import this spreadsheet back into Business Central.

Using Dampeners to reduce the number of MRP recommendations

When using MRP in Business Central, the system has planning parameters to filter your results. In the ‘Planning’ tab on the Item Card, you will find options designed to reduce the number of proposals in the Planning Worksheet. This tab is only visible for items of type: ‘Inventory’ or ‘Service’.

A Dampener Period allows users to specify a number of days added on to the Delivery Date whereby if demand changes, the Planning Worksheet suggestion won’t change. Without a Dampener Period in place, users put themselves at risk of having lots of unnecessary, small, suggested replenishment changes.

Imagine a customer asks for an item to be sold to them and we are buying this item beforehand to meet the demand. Where the customer decides they’d prefer that item arrive a day later than previously stated, do we want the system to change the suggested purchase date by a day? Probably not. As a minimum it will cause unnecessary hassle and, for all we know, the vendor might not accept the change to the Purchase Order date. The vendor might base their replenishment on our previous requirement, and it might be delivering a day later brings about complications for them.

It might be that the item in question is large and it can’t be kept long, perhaps due to limited warehouse space or spoilage. In instances like that, not having a Dampener Period might be appropriate. But in the majority of cases, this amendment of the Purchase Order date is unnecessary, so a Dampener Period is useful. The effective setting of these dampener parameters can dramatically reduce the number of proposed MRP lines, making the process much more manageable.

For added information, make sure you see our step-by-step examples of Dampener Period and Quantity functionality.

Prevent MRP from adjusting existing orders

There may be a time where you don’t want MRP to amend planning Lines for existing Purchase, Production or Assembly Order quantities or dates. For example, where vendors are not in a flexible position to adjust their own shipments. It might be that the vendor has short lead times. Granted you know this is the case, you won’t want your Purchase Order amended. The same goes for manufactured items. The shop floor might be unable to easily accommodate changes to existing Production or Assembly orders. This could be because you use a batch style of manufacturing. The solution is Planning Flexibility.

Planning Flexibility for MRP in Business Central

To handle these situations, you need to specify that MRP doesn’t change the Line after creating it. To do this, set the Planning Flexibility field on the Line of a Purchase, Production or Assembly Order. This is similar to the aforementioned Dampener Period and Quantity fields. However, this field isn’t limited by the Dampener values you enter in the Planning tab on the Item Card, it’s done on a Line-by-Line basis on the relevant order. Note that to see the field, you may have to use Personalise to add the field to the Line on your view of the page:

This image shows how you can personalise a Purchase, Production or Assembly Order to add the Planning Flexibility field. This gives you additional flexibility when running MRP in Business Central.

When you click the dropdown for the field, you are presented with two fields: ‘None’ and ‘Unlimited’. ‘None’ means that MRP can’t suggest changes for this Line. ‘Unlimited’ is the opposite. MRP can therefore suggest changes to the Line based on planning parameters.

An example of using Planning Flexibility for MRP in Business Central

Let’s say we have a Sales Order for 10 chairs. We replenish these using Purchase Orders. If we run MRP and click ‘Carry Out Action Message’, the system will create a Purchase Order. If we set the Planning Flexibility field to ‘Unlimited’, we can change the dates on the Sales Order and if we click ‘Calculate Regenerative Plan’, the Planning Line will change, suggesting changes to the Purchase Order. This of course depends on the parameters set against the Item in the Planning tab. However, by setting the Planning Flexibility to ‘None’, we can stop the system making amendments to the Purchase Order. This is regardless of any date or quantity changes we make.

This image illustrates Planning Flexibility set to ‘Unlimited’. As you can see the Sales Order quantity has changed to 100. The dates have changed too, hence the Action Message entry on the left-hand side.

Where we have Planning Flexibility set to ‘None’, the system won’t ignore increases in demand. It simply means the original Purchase Order won’t change after clicking Carry Out Action Message. Instead, the system will suggest creating an additional Purchase Order to meet the demand.

This image illustrates Planning Flexibility set to ‘None’. No amendments are suggested for the existing Purchase Order but as demand from the Sales Order has risen from 10 to 100, MRP suggests creating an additional Purchase Order.

It’s worth mentioning, all Lines by default will have their Planning Flexibility set to ‘Unlimited’. Consequently, each time you wish to amend this, you will have to change it manually.

Closing remarks

As always, thanks very much for taking the time to read this. If you’re struggling with running MRP in Business Central, hopefully this has been useful. If you would like to get in touch with us and speak about any planning issues or otherwise, please contact us. Lastly, feel free to follow us on LinkedIn.