Skip to main content
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested answer

Data Entity for Net Requirements

(2) ShareShare
ReportReport
Posted on by 39

Hello All,

We are on 10.0.30 version.

Is there a OOB data entity for Net requirements? we are trying to build Power BI report to view the net requirements for all Items because there is no OOD form form which displays net requirements for all Items. The report will display the quantity remaining for each Item after consumption for the real demand like production order, Transfer order, sales order etc.

The reason behind the report is we wanted to know the Items inventory with no demand. We use MRP, firm planned purchase and planned productions orders. We do buy Items with MOQ (Min order qty) so we have some left overs sitting on the Inventory for a while with no real demand. we wanted to identify those Items so we can take action against those items since our Items are batch controlled with an expiry date on it.

Is there a better way/form to identify the Items with no demand?

  • Suggested answer
    Zain Mehmood Profile Picture
    4,161 Moderator on at
    Data Entity for Net Requirements
    Hi ,
    I experienced this requirement in 2020 where I needed to add some planning items through a master plan, and I think till date there is no data entity available to this out of the box. 
     
    You can get this information from net requirements page, or even Gross requirements if you are dealing with Forecast Planning. 
     
    Thanks, 
    Warm Regards,
    Zain 
  • BS_BS_PC Profile Picture
    48 on at
    Data Entity for Net Requirements
    Hi Sarani, 
     
    Did you ever come up with a solution for this? 
     
    I have the same issue and additionally would like to be able to report out when a subset of parts are expected to hit zero on hand inventory. Apart from running net requirements for hundreds of parts and compiling the data there seems to be no way to do this out of the box. 
     
    -Braiden
  • Suggested answer
    Hana Xue Profile Picture
    Microsoft Employee on at
    RE: Data Entity for Net Requirements

    Hi Sarani,

    The Net requirements page shows the net requirements that master planning calculated for the product. It also shows the coverage settings that were applied during the master planning run, a breakdown of the requirements totals by transaction type, and pegging information. For content on net requirement, you can check the link below.

    Net requirements and pegging information - Supply Chain Management | Dynamics 365 | Microsoft Learn

    Net Requirements Explained: D365 Finance and Operations – Dynamics Tips (dynamics-tips.com)

    In addition, through document query, no OOB data entity for net requirements is found, and you may need to create this data entity by yourself.

    Best Regards,

    Hana

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

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 171 Super User 2025 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 140 Super User 2025 Season 1

#3
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 127 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans