RE: Stock versus sales orders reports or views
I think you can personalize Inventory management/Inquiries and reports/On-hand list for this purpose.
Make sure warehouse dimension is displayed, filter the list to a specific warehouse.
Physical inventory = quantity currently present in a warehouse
Available physical = quantity available for sale, not reserved against any order
On order = quantity on open sales order or production picking list
You can use it as is or create a simple Power BI report based on this and add any missing calculated fields, for example:
Short quantity (without inbound) = On order - Available physical
Short quantity (with inbound) = On order - Available physical + Ordered
