Back

General idea of the Simple MRP journal

Simple MRP Planning and Direct Replenishment Journal
Video 2/12
Play
Close
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
This video includes functionality from the app "Reverse Planning" which is available at Microsoft AppSource. Click to visit AppSource. Reverse Planning Watch the "basic" videos to take the tour of the main processes of Business Central. This is the basic, need-to-use functionality. The Basics An intermediate video requires some previous experience with Business Central, but it is still easily accessible to most people. Intermediate

Playlists  Manage

Log in to create a playlist or see your existing playlists.

Presenter: Sune Lohse, Chief Strategy Officer

The simple MRP journal is like an MRP journal that only creates new order suggestions opposite to a true MRP journal, the planning worksheet or requisition worksheet.

The simple MRP journal would only suggest new supplies.

It has a lot of complexity and a lot of flexibility opposite to the true MRP planning journals, but it’s also much more complex than what we call the dynamic replenishment, where you can do all the planning manually.

So in the SimpleMRP, you can calculate SimpleMRP.

We have made a lot of templates with different logic in it.

The most common one, or not common one, the most simple one is the first one, find critical items.

And actually, if I just run it now, it will find all items with an end inventory below zero on whatever location you have selected, and it would suggest to fill up until zero, because that’s a template I set up.

So it didn’t do that.

I have to suggest quantity to order here.

So this actually explains me that we have a lag five of this one and three of this one and so on.

This is a very simple calculation in here, and if you open it again, the template we just used, you can look at the template here.

If you enter the template card, we will do that, run through that in detailed videos, because this is all the complexity.

Once you understand all the fields in the reverse template card, you are an expert.

Here it says where you want to calculate from and to, which demands and supplies to include, and in our example just before, we said we’d like to trigger on inventory level zero, opposite to safety stock or reorder point.

We would like to trigger an end inventory, meaning we don’t care that it gets below zero within the period, because that’s only a matter of moving dates around.

We have other tools for that, but often when you have a positive end inventory, you don’t want it to show up as very critical.

And likewise, we have many different check marks in here.

Calculate per location.

We can calculate with locations together, with variants together, and there’s so much functionality in here, very much complexity, and the template does it out of the box, but you can make many, many templates of your own with an infinite amount of functionality.

For instance, the run for all LLC code will run per one location code at a time and break down the hierarchy and automatically suggest quantity to order and automatically carry out.

So if we look at that template, for instance, critical items in all levels, like this one, we’re still triggering on zero.

We still trigger on end inventory, so it’s still for critical items, but we have a check mark in run for all LLC code.

We want to suggest quantity to order based on a template we set up over here.

select the template here, meaning this one.

We would look from end inventory up to zero using order modifiers and rounding up.

So there’s a lot of setup in here that we built out of the box and you can change it as you want and you can make your own templates.

But if you take this one for example, normally the first one it will create the lines in here, you would suggest quantities to order, you would set the action message, meaning that it will place the check mark over here and you will carry out that it will transfer the lines into the journal so if i carry out all of this one that we just made just for the example it will take all my items that are truly critical that we just calculated but not within low level code transfer them into the reverse planning worksheet journal just in a second and if i say yes to open the journal i can see all my lines in here and i can see the oops not that many lines.

It takes like one or two pictures scrolling up and down to view all the lines in here.

That’s the true critical item, like an MPS, the items that are critical right now.

If I delete those and I run it again, go back from the reverse planning worksheet, calculate simple MRP, now taking the other template, find critical items, all levels, trying to do that one.

It will, and maybe still on location code production.

It will do the same except it will take level 0 first, suggest quantity to order, transfer it into the reverse planning worksheet and take low-level code 1, including the demand from the planning worksheet, the depending demand and so on.

So now we will have more lines and it breaks down the full hierarchy doing both the MPS and the AMRP at the same time, but still only suggesting new orders.

Therefore it takes longer time of course because we have more lines to handle, but it’s still around 20 times faster than a standard MRP.

And the lines is empty because we said we wanted to transfer the lines into the planning worksheet, so they will all be over here.

And I expect if I scroll down to have quite a lot of lines more in here because this is including the full breakdown of items.

This was just two templates you can use.

If you look at the templates in here, you can calculate below safety stock reorder points, purchase transfer lines in iteration with different templates running after each other, breaking down forecasts and so on.

There’s no limit to what you can do in here.

A good planner, you might want to have hundreds of templates in here used for different times of year and different purposes, but that’s the idea.

And normally the simple MRP is used for that.

1128765281--ENG25072915