You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!