Demand & Supply link for better Inventory control and Inventory optimization

Hi Team,

We are using Material requirement Planning(MRP) for planning Raw material as well assemblies. We have using INV, PO, WIP, OM along with other financial modules.

We have restricted generation of manual supply like PR & PO. So ensuring that every supply should have demand.  Still we have high inventory which affecting our working capital.

Business wants to understand every supply and its corresponding demand. And this requirement is at Work order level for FG as well as Sub-Assy and purchased items.

Please guide us to achieve either with standard process or suggest if any customization is required. Customization details will help if anybody already using this.