Skip to main content

Notifications

Supply Chain Management forum
Answered

Material stockout list

Posted on by 97

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

  • Maria Profile Picture
    Maria 97 on at
    RE: Material stockout list

    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

  • Maria Profile Picture
    Maria 97 on at
    RE: Material stockout list

    Hi Carol,

    Thank you very much - this is very helpful.

    I will check this.

    Best regards  

    Maria

  • cksikes Profile Picture
    cksikes 25 on at
    RE: Material stockout list

    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:
    pastedimage1657028661896v1.png

    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:

    pastedimage1657028757406v2.png

    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

  • Suggested answer
    Dogan Adiyaman Profile Picture
    Dogan Adiyaman 672 User Group Leader on at
    RE: Material stockout list

    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:

    coh.PNG

    • Minimum: Item coverage's minimum quantity.
    • Physical inventory: Physical inventory.
    • Ordered: All incoming items to your warehouse.

    I hope this is what you need.

    Alternatively:

    • Maintain master plan components to trust the master plan, or
    • Develop a power apps report to have deeper insights.
  • Maria Profile Picture
    Maria 97 on at
    RE: Material stockout list

    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

  • BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,073 Most Valuable Professional on at
    RE: Material stockout list

    What kind of a report do you need? Maybe we can offer a report for you that exist which fulfill your needs.

  • Verified answer
    Dogan Adiyaman Profile Picture
    Dogan Adiyaman 672 User Group Leader on at
    RE: Material stockout list

    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.

    • There may be open "picking list journals" that are not posted. All lines will appear in this report.
    • There may not be any "picking list journals". However, you will still see some lines in this report if estimations for the consumptions are done for the production order.

    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.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans