Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Plan the Item using multiple Locations

(1) ShareShare
ReportReport
Posted on by 84
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 ? 
 
  • Suggested answer
    Ben Baxter Profile Picture
    5,626 Super User 2025 Season 1 on at
    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
  • M0HAN SINGH Profile Picture
    209 on at
    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).
     
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,137 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,877 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans