In this video, I will show you how to fill up an order for a vendor to utilize a custom mount to get discounts or free freight or stuff like that.
Or maybe if you fill up a container, you want to be able to have that.
In the example here, this is my business all around the world.
I have a main office and production areas in Europe, maybe.
I have a production site in the east somewhere, and I do have some vendors and subcontractors out in the Far East as well, also in the other end of the world, which is not on this map.
And of course, when I buy from this vendor, I want to make the orders as good as possible because it’s not easy to just create many orders.
So I want to make sure that I fulfill up my orders nicely.
The demand is coming from my small sales shops or my customers, of course, and most of my customers is around in Europe.
And therefore, the supply is coming in through from transfer orders and I create production orders and then I can create purchase orders in the end to my vendors.
And this example, we did the first and I’m just going to do my purchase orders.
Let’s see how it looks in Business Central when I calculate my simple MRP.
In here, I in here.
I will calculate using a template which is called purchase items up to safety stock.
That’s just a template where I run to safety stock, triggering on end inventory.
I have a filter which is all purchase item.
Basically, it’s just looking at the item card for all items that has a replenishment system purchase.
and I will filter on my location code production, which is my main location that I’m buying to from all my vendors in this way.
This will calculate, of course, everything I need to buy, and I can handle those per vendor or just carry out all of it.
But in this example, I have only one line for vendor number 87,000, this line, and that’s a tire, a big tire big tire that’s the one up here and I’m going to buy a lot of those 40 pieces from my vendor here and my vendor is a factory somewhere that does maybe rubber parts here and we’re going to buy this tire from our little vendor and of course the whole idea now is to fill up to that vendor so I will suggest quantity maybe even change the quantity here for whatever reasons accept action messages carry out actions and put this in the reverse planning worksheet to be ready to be handled if i create a purchase orders from here if i select carry out action it will create a purchase order for this line only so i’m cancelling this one instead i will go to my simple sorry my direct replenishment like this calculate my dynamic replenishment like this, calculate my direct replenishment, and here I will use a template to fill up to purchase orders, to reorder quantities, I’m looking for reorder quantity for right now, I’m just going to fill up a container or a ship or whatever, a truck from this vendor to gain a discount or to gain free freight or whatever.
So the template here is purchase items only and I’m looking at my location co-production and I want to filter on my vendor number that we are looking at.
So the idea is here that we are actually taking all the items for this specific vendor.
So all items that has this vendor on it except for the one that we already entered in the worksheet because we had a check mark that skipped if already planned.
So if I open my worksheet, I would expect the tire already to be there.
So from here I can select which other items I want to put in here.
And I can of course change the quantities like I want to.
I can look up my order quantity to see what my reordering parameters are for this item here.
When I carry out actions and transfer those into my planning worksheet i can see all the lines here with total custom amount total volume and total weights and by exporting this to excel it’s easy for me to see what is the total cost amount now and if i know per this vendor i need to have a cost amount of 200 000 i still lack something and i can just add to it or I could also change the amounts in here, the quantities in here that will update my cost amount.
So this way I can change my vendor order and when I’m done I can carry out for all of them creating one nice purchase order for this vendor.