Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Problem with suggestio...
Small and medium business | Business Central, N...
Suggested answer

Problem with suggestions in Requisition Worksheet

(0) ShareShare
ReportReport
Posted on by Typhooneforrest 27
Hi,
I really hope to find some help from this great community. As the headline says, I get really strange suggestions when using the requisition worksheet feature in BC.
Let me describe the problem:
In order to test the functionality I created a product from scratch and set the Replenishment system to Purchase. In the Planning section I set the Reordering policy to Fixed Reordering Qty and the Reordering point to 5 pcs. The Reordering Qty is also set to 5 pcs.
The item have no stock, no previous purchase orders nor any sales orders attached to itself.
In my world the Requisition worksheet should give me a suggestion of 5 pcs, right? But no matter the time frame I set when creating the worksheet the suggestion is 12 pcs. I can't get my head around this. Anyone have any idea why or have experienced the same issue?
For the record: I've tried to change Reordering policy to Maximum Qty. but with the same result: 12 pcs.
All the best
// Tony
  • Typhooneforrest Profile Picture
    Typhooneforrest 27 on at
    Problem with suggestions in Requisition Worksheet
     
    This was quite some time ago but it wasn't resolved.
     
    We built our own solution for this. It's not as complex as the built-in functionality but works better for most scenarios. We simply check the demands without considering any dates, e.g.
     
    - Current inventory qty
    - Qty on sales order
    - Qty on production order
    - Qty on purchase order
     
    Also, the number of the reordering parameters is considered, before we sum this and present a suggested qty to order.
     
    Not to any help to your problem, I guess but that's how we worked around the problem.
  • RD-29040923-0 Profile Picture
    RD-29040923-0 2 on at
    Problem with suggestions in Requisition Worksheet
    Good morning Tony,  did you find an answer to this ?  I'm using locations & bins.  BC is just ignoring the available qty in stock,  no POP orders or SOP orders and just suggesting I reorder the MAX qty amount and ignoring i've got in stock!  Reading the documentation it should be Qty - Max Qty = Re-order qty.  Thanks Rick
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,915 Super User 2024 Season 2 on at
    RE: Problem with suggestions in Requisition Worksheet

    The suggestion for 10 sounds correct, the first order of 5 will still leave you at your Reorder Point, therefore triggering another 5, so the system is combining them to suggest 10.  The suggestion for 12 is odd.

    Are you using Locations?  If so, add the related SKU for the Location and see if the suggestion changes.  When using Locations (and everyone should) the system responds better when a SKU is present.

  • Suggested answer
    Tech-Lucky Profile Picture
    Tech-Lucky 796 on at
    RE: Problem with suggestions in Requisition Worksheet

    Please recheck if any other document is there with this item like production order or this item is in any of the production order BOM Components,

    Find the link below to deeply understand the exact Item Planning Process :

    learn.microsoft.com/.../

    Mark this answer Varified if this was helpful.

  • Typhooneforrest Profile Picture
    Typhooneforrest 27 on at
    RE: Problem with suggestions in Requisition Worksheet

    Yepp, No template with a safety stock qty or any other parameters set. Meanwhile, I changed some other values and if I set reordering value to 10, then the suggestion will be 10 psc. But if I change back to 5 pcs the suggestion is still 10 pcs.

    I've forced a browser reload and a number of other actions but still with the same illlogical result.

    This is totally confusing.

  • Navision-ClockStone Profile Picture
    Navision-ClockStone 15 on at
    RE: Problem with suggestions in Requisition Worksheet

    Sure, you did not use a template to create the item defaulting a safety stock qty.?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans