Hello,
Can someone explain Material stockout list logic?
I don't understand how it works. We have on hand inventory for some of items that are shown there - so I am not sure that I understand how it works.
Can anyone help me, please?
Best regards
Maria
Hi Dogan,
Thank you very much. I know this report, that's helpful if you want to check inventory against safety stock but I want to check against production orders (that we have enough raw materials to produce specific finished product).
Thanks again
Best regards
Maria
Hi Carol,
Thank you very much - this is very helpful.
I will check this.
Best regards
Maria
If you are using job scheduling and have a production unit assigned to your resource group, then you can see material shortages by production order from the "production orders to release" inquiry available in the production floor workspace:
from the top section of this inquiry, there is a quick view of any job-scheduled order and an indicator of whether all necessary materials are available on-hand:
in the bottom section for the selected order, you can also view the status for each individual item on the BOM/Formula. Note: while there is a Microsoft idea for allowing this view on operations scheduled orders (https://experience.dynamics.com/ideas/idea/?ideaid=d09adb3b-9f83-e811-9cca-0003ff68aa6f ), there is no indication that this is on the roadmap to be fixed so you have to use job scheduling to make this inquiry work. If you don't use production units for any other functionality, then you can just assign a single generic production unit to all of your resource groups.
Hope this helps -
Carol
Hi Maria,
Ideally, you don't need such a report if your inventory policies are correct and using the master plan properly.
Otherwise, what you need is the Critical On-hand Inventory report. But still, It will not work properly if inventory policies (like coverage settings, default order settings, etc.) of items are not correct.
Go to Inventory management >> Inquiries and reports >> On-hand reports >> Critical on-hand inventory
This report shows on-hand inventory that is below defined levels. I suggest you use filters to run the report faster.
There are 3 important columns in the report: Minimum(which is defined in the item coverage setup), physical inventory, and ordered.
Take a look at my report output below:
I hope this is what you need.
Alternatively:
Hi Dogan,
Thank you very much for your respond - it explained everything.
Maybe do you know that there is report that looks at the inventory on-hand and production orders and based on that show "critical" items.
Best regards,
Maria
What kind of a report do you need? Maybe we can offer a report for you that exist which fulfill your needs.
In my opinion, the report name is a bit deceptive.
This report shows the items that are required to be consumed for the production orders once the system does consumption estimations.
In another saying, it is a production report that shows you items that are requested to be picked but have not been picked yet.
Finally, the "Material stockout list" report works regardless of on-hand quantity. In other words, it doesn't look at the inventory on-hand. It just shows you whether required materials are consumed or not.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,867 Super User 2024 Season 2
Martin Dráb 229,173 Most Valuable Professional
nmaenpaa 101,156