Skip to main content

Notifications

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

requistion worksheet with stock unit, Purchase order does does not transfer over

Posted on by 5

I am having issues with the requisition worksheet. 

when I run it with the below parameters it tells me to order another 100 however it should suggest 0 as I have 100 already -5 for my sales order I should be at 95 which is still between my reorder point of 80 and maximum inventory of 100.

Reordering Policy Maximum Qty order date Planned delivery Planned Shipment
Item P1442
Saleorder 5 19/05/2023 02/06/2023 19/05/2023
Purchase order 100 29/05/2023
Replenishment system Purchase
Lead Time Calculation 5D
Saftey Leadtime 5D
Reorder Point 80
Maximum Inventory 100
requistion suggests to order 100 29/05/2023

(today + 5 calender days Lead Time Calculation + 5 calender days Saftey Leadtime)

  • Jun Wang Profile Picture
    Jun Wang 7,437 Super User 2024 Season 2 on at
    RE: requistion worksheet with stock unit, Purchase order does does not transfer over

    do you have sku set up for the item? since planning will consider the planning parameters of skus, you need to check those as well. It also consider forecast, blanket order as demand etc.

    Demand is a very broad term in BC, which not only include sales but other outbound shipment as well such as transfer, returns, etc in a certain time bucket.

    There are also other planning parameters on the item card that control the behavior of the planning, without looking into those, it is hard to say the planning engine is not working correctly.

    For the testing, I would recommend to set up a new item and set up the planning parameters only as necessary. e.g.

    create a demand in sales, than test again.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans