web
You’re offline. This is a read only version of the page.
close
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...
Suggested Answer

Requisition worksheet

(1) ShareShare
ReportReport
Posted on by 8
Hello,
 
I am testing the Requisition Worksheet and it does not look like it's working well.  Is there something in the item or system setup that I missing?  Thanks.
 
Item#1
Inventory=18
Sales Order=5
Purchase Order=5
Reordering Policy=Lot-for-Lot
Safety Stock QTY=100
After running Calculate Plan, it tells me to cancel the Purchase Order of 5
 
 
 
Item#2
Inventory=10
Sales Order=1
Purchase Order=0
Reordering Policy=Lot-for-Lot
Safety Stock QTY=50
After running Calculate Plan, nothing or no line shows up in the requisition worksheet.
 
I have the same question (0)
  • Gerardo Rentería García Profile Picture
    25,367 Most Valuable Professional on at
    Hi
    The calculations related to planning in business central are diverse and depend greatly on the configurations and situations.
    Surely you have already done it, but if you have not been able to review these pages,
    I advise you to take a look at it, it will surely give you some light.
    Best regards
    Gerardo
  • Suggested answer
    KasparsSemjonovs Profile Picture
    4,774 Super User 2025 Season 2 on at
    Please re-check this video. 
    There are other important fields in the Item card, that maybe are left blank for You ?
     
  • Suggested answer
    Ben Baxter Profile Picture
    6,620 Super User 2025 Season 2 on at
    As others have mentioned, there are a lot of factors the Req. Worksheet is considering when making suggestions.  For example, you did not mention Location on the demand (Sales Order) or the supply (Inventory and Purchase Order).  We don't know the dates of the demand or supply either, which is critical in the calculation.  Lastly, we don't know what criteria/filters were applied when running the Req. Worksheet calculation.
     
    If you are using Locations (which you should, even if you only have 1), then you will either use the Manufacturing Setup > "Components at Location" (single Location only!) OR use Stockkeeping Units.  The system looks at the SKU card first, and if you are planning the Item at that Location, a SKU card should exist for it.  The only exception is single Location environments, where you can tell the system to use the Item Card for the planning via the "Components at Location" setting.
     
    Your calculation start and end date are also important.  Generally, you want to use today or tomorrow as your start date (can't plan the past) and an end date that is longer than the lead time of any Item captured by the calculation.  You can always filter by Order Date before carrying out your plan, but if your end date didn't capture long lead demand you'll likely have a shortage or expedited shipping costs.
     
    Troubleshooting the Req. Worksheet through the forums is challenging.  I would strongly encourage you reach out to your partner for some training and review time to get started on the right path.  The planning in BC is good once you dial in your settings.
     
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans