Skip to main content

Notifications

Announcements

No record found.

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

Requisition worksheet issue

(1) ShareShare
ReportReport
Posted on by Ollie 10

HI All, 

I am looking to get the requisition worksheet up and running for Lot-for-Lot ordering. 

When I run the requisition work sheet I am getting SKU's pull through where we have stock to cover the sales order however it is saying to purchase more stock? or to order stock when there is no sales order. 

Example:

Black 42S- 4 in stock and none on sales order yet it is saying to order x1

what we are trying to achieve is to run the report and get a order based on Demand. 

any help will be appreciated i have attached pictures of the stock keeping unit set up and the result once I've ran the Req worksheet.

TR5555_2D00_-Req-worksheet.PNGtr5555_2D00_-Variant-table.PNGreq-calculate.PNG

Categories:
Dynamics 365 Business Central
  • CaiParsons Profile Picture
    CaiParsons 5 on at
    RE: Requisition worksheet issue

    That's strange. I suggest reviewing the settings on the worksheet to ensure that it is set up correctly for Lot-for-Lot ordering. Double-check the SKU setup and make sure that there are no errors there. If it doesn't help, you could try another platform for worksheets with education topics. You may also want to consult with your team or a specialist to troubleshoot the issue further. Good luck!

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Requisition worksheet issue

    Have you studied.... learn.microsoft.com/.../design-details-handling-reordering-policies

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Requisition worksheet issue

    Hi

    Can you please post planning parameters for those items SKU (for the exact location). Also  in Requisition Worksheet do the following and post screenshot please

    1) Select the item in question then Line -> Order Tracking

    2) Select the item in question then Item Availability By then Events and also Locations

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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans