Skip to main content

Notifications

Business Central forum
Suggested answer

How Fixed Reorder Qty for Requisition worksheet works for multiple locations

Posted on by 272

Hi all,

I have an inventory Item No 1696 with Replenishment System = Purchase, Reorder Policy = Fixed Reorder Qty.  I have multiple locations and would like to use the requisition worksheet to calculate the requirements for multiple locations with respecting planning parameter enabled.  The actual results turned out did not consider a second location demand, and the result did not respect the reorder Quantity as well.  I need some help to identify what is wrong here.  Thank you for your help. 

1. Item 1696 and Item card Planning

  • Purchase UOM = BOX
  • 1 BOX = 20 PCs (base UOM = PC)
  • Replenishment System = Purchase
  • Reorder Policy = Fixed Reorder Qty.
  • Safety Stock Qty = Reorder Point = 30
  • Reorder Qty = 40
  • Lead Time Cal. = 1D

Order Modifiers:

  • Order Multiple = 20

Inventory on Hand

  • Location A = 15
  • Location B = 0
  • Location C= 0

Qty on Sales order = 80

  • SO 1 Location B = 10   requested date = 2/4/2022
  • SO 2 Location B = 50   requested Date = 2/25/2022
  • SO 3  Location A = 20  requested date = 1/31/2022

Qty On PO = 0

Qty On Job - 0

Run requisition worksheet to calculate Plan:

  • Start Date = 1/1/2022
  • Ending Date = 3/31/2022
  • Item No = 1696
  • Respect Planning Parameters

Actual Result: 

  • Item 1696  location A New PO Qty = 1 BOX Due date 1/24/2022 ( did not respect the Fixed Reorder Amount = 2 Box = 40 Base UOM)
  • no PO is suggested for location B

Expected Result: 

  • Item 1696 Location A PO Qty = 2 BOX due date /30/2022
  • Item 1696 Location B PO Qty = 1 Box due date 2/3/2022
  • Item 1696 Location B PO Qty = 2 Boxes due date 2/24/2022
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: How Fixed Reorder Qty for Requisition worksheet works for multiple locations

    Thanks for update. I do not know why MRP does not respect the planning parameters for other locations (without SKU). It makes sense to me that respect those but maybe has a logic that I do not know.

  • Suggested answer
    B@houston Profile Picture
    B@houston 272 on at
    RE: How Fixed Reorder Qty for Requisition worksheet works for multiple locations

    Hi,

    Thank you for your update.  The setup that missing in my case is the Manufacturing Setup page.  Once the primary location is setup it works as expected. 

    The suggested PO for the secondary location shows up now - this works.  However,  as you mentioned, the requisition worksheet calculation does not work the same way for Secondary Location,  the Calculation does NOT respect the Planning parameter for the secondary locations.  For example,   

    • the suggested PO qty for Loc 2 is 20 UOM, while the fixed order qty=40
    • the safety stock of 30 is ignored for secondary locations, Loc 2 in your example. 

    Thank you for your help on this.  

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: How Fixed Reorder Qty for Requisition worksheet works for multiple locations

    Hi

    I went ahead and created a new item in my test and then created exact setup to test. This what I realized 

    Go to Manufacturing Setup then look at Components at Location this is the only location that BC respect Planning Parameters for in your setup (without SKU). It does not do the same thing for other locations. In addition it ignore Modifier for none-primary location. 

    In your example it is a chance that Location A is not a main location in that setup.

    That being said it is strange that system did not recommended anything for Location B. I post my setup here and this way you can check and let me know if I missed anything here. This way I can try to replicate it. By mistake I created SO for 3 locations but you can see for Loc2 system ordered QTY and also generated 3 lines for Main Loc (to build back inventory to Reorder then for the rest of orders) 

    pastedimage1643379057815v1.png

    pastedimage1643379257135v3.png

    pastedimage1643379300331v4.png

    pastedimage1643379373027v5.png

    pastedimage1643379488667v6.png

    pastedimage1643379555820v7.png

    Sales (Sorry I added to 3 locations) 

    pastedimage1643379755938v8.png

    pastedimage1643379836715v9.png

  • B@houston Profile Picture
    B@houston 272 on at
    RE: How Fixed Reorder Qty for Requisition worksheet works for multiple locations

    Hi,

    No SKU is set up.  Thank you.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: How Fixed Reorder Qty for Requisition worksheet works for multiple locations

    Hi

    Quick question. Do you have any SKU setup for each location? and if yes what are planning parameters for those SKU? 

    Thanks 

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans