Requisition worksheet and Inventory Reorders not actioning

(0) Share

Report

Posted on by MaddieGreen

Hi All,

We think we have the item cards set up correctly but when we process a Requisition worksheet or the Inventory Reorders report it doesn't prompt to order items.

To give a brief explanation, our BC is set up that we get Sales orders in and they will be send out immediately. So we don't order based on Sales orders but on Fixed re-order quantity.

1. We set the item cards to Fixed Reorder Qty, we have 1 in inventory, and even a safety stock.

2. I'm unsure if we need Availability by Events by Location set up, so I'm including this screenshot just for reference:

3. When we Go to Requisition Worksheet and calculate with any range of start and end date. It just doesn't show anything or in this case even says we need to cancel the PO (although we are out of stock of them)

4. If we run the Inventory Reorder report, it shows nothing at Qty to order.

I have the same question (0)

All responses (15)

Answers (1)

Suggested answer

MahGah 15,525 on at

Like (0)

Report

RE: Requisition worksheet and Inventory Reorders not actioning

Hi

I created a new part in my test environment with exact setup and tried and looks like your setup is correct. I can do more test but before that can you please answer the following questions.

1) When you run your requisition do you turn on "respect planning ..."?

2) Also can you use Planning Worksheet and then turn on both MRP/MPS and then again "respect ..." and see the result?

Thanks

Was this reply helpful? Yes No
MaddieGreen 35 on at

Like (0)

Report

RE: Requisition worksheet and Inventory Reorders not actioning

Hi MahGah,

Thanks for your reply.

I turned on 'Respect planning ..' for the requisition worksheets and that returns the same results.

I tried Planning Worksheet with the settings you provided and it also gives the same results.

I've ran both with all of our products and it just says to cancel everything on the current purchase orders.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 193 User Group Leader on at

Like (0)

Report

RE: Requisition worksheet and Inventory Reorders not actioning

What date range are you using in your calculation? You have 1 on hand and 2 on PO for a total of 3, I cannot see any demand that would pull your available inventory to -1. Check that demand and the date on that demand as compared to the date range in your calculation.

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,372 Super User 2025 Season 2 on at

Like (0)

Report
RE: Requisition worksheet and Inventory Reorders not actioning

Maddie,

I see a couple issues, with the first issue being the likely cause of your situation:

You are using Locations, but you do not have any Stockkeeping Units created for this Item.

Run "Create Stockkeeping Units" to have the system create the SKU.

I recommend applying filters when running this process to control what is created.

When using Fixed Reorder Point policy,

Zero out your Safety Stock Quantity, instead build it in to your Reorder Point. Its redundant and makes it harder to troubleshoot.

Get rid of all Order Modifiers, the system will suggest your Reorder Quantity, you don't need to modifiers because it is a fixed number.

See if either of these help you dial in your results. If you are still having issues, I would encourage you to reach out to your support partner to provide some additional troubleshooting.

Was this reply helpful? Yes No
Dallefeld 193 User Group Leader on at

Like (0)

Report

RE: Requisition worksheet and Inventory Reorders not actioning

Ben provided great information.

But to be clear, you are not required to have Stockkeeping Units. However, it makes sense to use them unless your replenishment parameters are the same no matter the location. And Stockkeeping units are the only way to indicate that replenishment is done via a Transfer Order/

Was this reply helpful? Yes No
Suggested answer

MahGah 15,525 on at

Like (0)

Report

RE: Requisition worksheet and Inventory Reorders not actioning

Hi

I replicate your setup (without using SKU) and BC generated the expected result

A few points to try

1) Remove 1D from Safety Stock. Since your safety stock 1D is less than your lead time 2D this can cause an issue. Then Run and test.

2) As Ben suggested add the 2 from safety stock to 1 in reorder point (change from 1 to 3). If you do not want to keep extra 2 in inventory for safety then just remove it and do not add it

3) Run and test

4) I see you have no demands for this part (see below). I am not sure why Available Inventory is -1. In addition I can see you have PO for 2 but that does not show up in inventory reorder. Can you run the Inventory Reorder for the main location and share the result.

5) System suggest to cancel the PO because of having more than 1 in inventory and short lead time.

Let us know the result

Was this reply helpful? Yes No
MaddieGreen 35 on at

Like (0)

Report

RE: Requisition worksheet and Inventory Reorders not actioning

Thanks for all the input! I've done some tests but for me it still results in the same problem.

I've set up the item card as you recommended (I'm not sure if the reorder point is based on Purchase Unit of Measure or always on individuals):

The item has SKU's:

I use the following setting for the Requisition Worksheet:

The result of the requisition worksheet is blank.

I then ran the Inventory Reorder report using these settings:

But that resulted in an empty report:

Was this reply helpful? Yes No
Suggested answer

MahGah 15,525 on at

Like (0)

Report

RE: Requisition worksheet and Inventory Reorders not actioning

Hi

Thanks for extra info.

the reorder point is based on Base Unit of Measure and not purchase UOM. For example if 1 Purchase UOM = 10 Base UOM and you need BC start ordering when you have 1 Purchase UOM then reorder point is 10

In your screenshot I see a few things

1) Looks like you have 2 locations (see below) in this case as Ben suggested you need to use SKU and then for each location define SKU (https://usedynamics.com/business-central/planning/stockkeeping/)

2) You can go to Manufacturing Setup then make sure you have the following setup.

3) I can see your reorder point is 10 but for both locations you have more than 10. In this case BC will not make any suggestion.

Was this reply helpful? Yes No
MaddieGreen 35 on at

Like (0)

Report
RE: Requisition worksheet and Inventory Reorders not actioning

Hi all,

Finally got it working. The reason it didn't work is because I tried it on our production environment (without SKU's) and it didn't work, and then I tried it on our Sandbox environment (with SKU's) and that didn't work either. I think on our Sandbox environment isn't setup correctly. When I added SKU's to our production environment it worked!

I do have three additional questions that I couldn't find the answer to on the forums:

As I understand the 'Lead time' of a product isn't factored in into the Requisition Worksheet or Planning Report. We have over 1000 products, and we get 80% of our products from the same supplier. That supplier delivers every week. But there are items of that supplier that sometimes take 2-3 weeks to deliver, hence we set the Lead Time of those products. Is there a way we can incorporate the lead time in the Requisition or do we just have to bump up the reorder point?

With the same supplier we get Perishables and Non-perishables, which both have a different delivery day. We have both Perishables and Non-perishables scattered over multiple item categories. What is the best way to categorise those items (dimensions maybe?) so that we can run a Requisition for the Perishables one day, and then Non-perishables another day?

The demand of our customers fluctuates (it mostly just goes up). But as we are getting more and more customers, we also are getting more orders, which means we need more stock. Besides just updating the reorder point on each SKU (we have 12 locations that sell items individually, so that is a lot of work), is it possible for BC to look at what we sold 2 weeks ago, and 1 week ago, and give an estimate on how much more we're going to sell this week, so how much more we should order. I've looked for demand forecast but that seems to be manual. As a reminder, we ship out sales orders immediately when they come in, so we can't forecast based on open sales orders.

Was this reply helpful? Yes No
Verified answer

Ben Baxter 6,372 Super User 2025 Season 2 on at

Like (3)

Report

RE: Requisition worksheet and Inventory Reorders not actioning

Glad to hear adding the SKUs resolved the issue!

In regards to the Lead Time, it is factored in to the suggestion made by the worksheet. You should see a Due Date and an Order Date (may have to display this field). When Carrying Out Action, we highly encourage Users to filter on the Order Date to ensure you don't order product to early.

Regards to applying a filter to your Calc. Plan, I always start with the Item Category. Since you mention it is already in use and not ideal for filtering, simply add a new field to the Item. I'd encourage an "enum" field so you can add to it in the future.

Lastly, BC currently doesn't have the ability to spot trends and make updated suggestions based on it. That being said Microsoft is doing a lot with Machine Learning, and you can add that to your planning. It won't be perfect to start, but as time and data build up the system should get better and better about the suggestions it makes.

Final point, just because you ship out same day doesn't mean you can't use order based planning. A Lot-for-Lot policy with a Safety Stock quantity allows you to maintain a base stock while also accounting for fluctuating demand. You would want to run plenty of test scenarios through the system to ensure you can keep up with demand. Just hoping you would keep an open mind to this policy.

Sounds like you're heading down the right path now. Good luck with your planning!

Was this reply helpful? Yes No