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?