web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / On Order qty split in ...
Supply chain | Supply Chain Management, Commerce
Suggested answer

On Order qty split in D365fo

(1) ShareShare
ReportReport
Posted on by Manufacturing 252
Hi All,
 
From Sales order line level to components level, we would like to see below information may be in 1 click.
 
1. On Hand inventory of all components. (We use PCM and also standard BOM).
2. Remaining Qty  = On Hand inventory - Qty that is available in COmponents level of Production order.
3. Qty on Open Purchase orders - So that they can visualize all in one screen to visualize the open orders and its delivery date from vendor to plan for there production in D365fo.
 
I know we have ways to get it by clicking multiple  clicks on on hand form and also on Open purchase order lines, but on PCM components n exploring it may be in single click would be helpful.
 
Thanks.
Categories:
Dynamics 365 Supply Chain Management
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,535 Super User 2025 Season 2 on at
    On Order qty split in D365fo
    Hi Manufacturing,
     
    Did you want to share feedback only, or do you have an actual question that we might be able to answer for you?
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    CA Neeraj Kumar 3,443 on at
    On Order qty split in D365fo
    Hi Kishore,
     
    For first point, i have given detailed answer in this link please refer.
     
    If you apply the similar query on On-hand form and Inventory transactions form, it will help you to save time in doing these navigations for BOM components. And once you setup the query, you can add those in any of the workspace that you generally use as a Tile, it will be opened directly.. and you just need to open the form and filter with your Main item, it will give details of its BOM line items.
     
    If you find any difficulty in applying the solution, please let us know.
     
    Actually to handle these kind of scenarios, Microsoft gives lot of other options like Explosion, Net Requirements (on Sales order lines), and Available to Promise (which works on concept of MRP and give you delivery dates that can be promised, after considering the on-hand stock, lead time, open PO, SOs and many other important setups.. 
     
    If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified
     
    Regards,
    Neeraj Kumar

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 675

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 249 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 215 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans