Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Requisition worksheet doesn't take purchase orders with delivery date in future into account

(1) ShareShare
ReportReport
Posted on by 4
I'm using the lot-for-lot replenishment system for my items with a safety stock.
Whenever I'm below the safety stock and I run the requisition worksheet, it suggests correctly the quantity that I have to purchase. 
I execute my requisition worksheet in order to have my purchase orders created. 
I send my purchase order to my vendor and when I receive my confirmation, I add my promised delivery date (and add the date to my lines). 
When I run my requisition worksheet again, it suggests again to purchase the quantity to have enough safety stock, although that I have a purchase order in the future.
When I put my promised delivery date of my purchase order again to today and I run the requisition worksheet, it suggests nothing (which is correct as I already have a purchase order). 
 
Can someone help me to solve this problem? I'd like to work with the safety stock, requisition worksheet AND to fill in the promised delivery date of my purchase orders. 
 
No solution in working with SKU's, releasing the purchase orders ... 
  • Community member Profile Picture
    4 on at
    Requisition worksheet doesn't take purchase orders with delivery date in future into account
    Hi, 
     
    Many thanks for your answers. 
    Indeed, if I run the requisition worksheet in the future (promised delivery date of PO), then it doesn't suggest to reorder the quantity.
    However, I'm purchasing a lot of items at different vendors with different lead times, so I can't really set my date to the future (also risky to not include sales orders I guess).
     
    When working with lot-for-lot I can only change the safety stock, not the min qty, reorder point, max qty ... 
    If I try the same scenario with fixed reorder quantity or maximum quantity as reordering policy, I get the same results.
    BC doesn't take the future purchase orders into account and will reorder the items. 
  • Jun Wang Profile Picture
    7,629 Super User 2025 Season 1 on at
    Requisition worksheet doesn't take purchase orders with delivery date in future into account
    I'm not sure if lot for lot and safety stock should be used together, lot for lot is to get the actual demand for a certain period of time, say 2 weeks. BC will create a purchase order for demand within 2 weeks. 
    safety stock is more on the fixed quantity side and is usually used with min qty, max qty.
    on the other hand, you mentioned that after receiving confirmation from vendor, you fill out the delivery time. You need to check the delivery time to ensure it doesn't fall out of the lot for lot range. If it does, BC will think the supply is in the future and will suggest a supply for the near date per date parameters on sku and item planning worksheet.
     
     
     
  • Verified answer
    Ben Baxter Profile Picture
    5,394 Super User 2025 Season 1 on at
    Requisition worksheet doesn't take purchase orders with delivery date in future into account
    This is actually standard behavior, so the good news is you aren't doing anything wrong.  Since moving the delivery date into the future moves the supply past the need date, the system is going to suggest a new PO and to cancel your existing PO (assuming you aren't changing the Planning Flexibility on the PO line).

    Try to run your Req. Worksheet with your Start Date being the Delivery Date promised by your Vendor.  Does this resolve your suggestion for a new PO?  Essentially telling the system you've planned up to that date and you're only planning from that date forward.  I didn't have time to test your scenario, but please give this a shot and let us know if it helps.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February 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... 293,041 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,856 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans