Inventory Item Inflow vs Outflow BI Report
There is a requirement to develop an item inflow vs outflow BI report. It would consist of data month wise from last 12 months to next 12 months. This would take into account the forecast demand(uploaded monthly) and monthly inbounds(Total quantity on exisitng PO or being generated by the MRP planning) for that item in the inventory org.
So, the formula for monthly data calculation will be like :- existing inv for item P - demand for item P for that month + inbound for item P for that month.
Does anyone have any idea/ reference code for the same. Any help will be appreciated.
0