Small and medium business | Business Central, N...

Plan the Item using multiple Locations

(1) Share

Report

Posted on by Seif naguib

I have the following setup for the Item FG TEST1

The item Has On Hand of 10000 on the STS-Main Location

The item has the 2 SKU

Forecast Demand for the Item Vs locations Lyons and Jasper

The planning Worksheet generated the Output according to the Demand and did not consider the On Hand in the STS-MAIN location

My Question: How can i make the Planning Consider the Inventory On hand ?

All responses (2)

Answers (0)

Suggested answer

Ben Baxter 4,915 Super User 2024 Season 2 on at

Like (0)

Report

Plan the Item using multiple Locations

If I am reading your question correctly, you want to know how to get the system to supply Jasper and Lyons Locations from the SPS-Main Inventory?

You would need to adjust the Replenishment System on your SKUs for Jasper and Lyons. Currently, they are set for Purchase and Prod. Order, which is why you are getting those suggestions. When you want to supply from another Location, you would use a Replenishment System of "Transfer". This will require you first setup a Transfer Route from STS-Main to Jasper and another from SPS-Main to Lyons.

Once the SKUs are adjusted the worksheet will give you the suggestion to create Transfer Orders to supply those Locations from SPS-Main. This will cause demand at your SPS-Main Location, so I strongly encourage you setup a SKU for that Location as well as define the appropriate Replenishment System for how the Item is supplied.

As you get further in your testing of the MRP capabilities, I would encourage you to reach out to your BC partner for assistance. The MRP works very well, but it is data dependent. Little things such as a missing SKU, incorrect Replenishment System, or improper Planning parameters can all throw off the results.

P.S. If this answer helped resolve your question, please mark it as a Verified Answer to help other forum Users find the solution quickly.

Best Regards,

Ben Baxter

Accent Software Inc
MS ROCK 140 on at

Like (0)

Report

Plan the Item using multiple Locations

Hi,

As per your setup, you Don'nt have Demand for your STS-Main Location. So system not generating planning lines. Edit your demand forecast for STS-Main location and fill Qty more than you have in your inventory.

Can see below Same Test case scenario with correct output:

Item MAIN having 1000 Qty on Red Location.

Having 2 SKU Blue & Green.

As you can see in planning worksheet output system deducting the -1000 Qty on Red Location and suggesting 14000 Qty (As demand forecast have 15k).