Hi experts:
I am going in the process of developing a new report in which i have:
PO, material, vendor, material, On hand Inventory, Safety stock and firm requirements.
the purpose of the report is to serve the users: what is the on hand inventory on today and how much we are falling short of the material.
Let me give me a eg:
today i have On-hand Inv: 1000 units
safety stock: 200
firm reqt came up (i mean, an order): 700
so, i willbe still having 500 (1000+200-700) as of today.
i get a new firm reqt tomorrow for 800 units. my on-hand inv will become -300 (500-800).
i want to see this -300 in the report for a period of 10 days.
so, in essence the user can estimate, ohhhh i am falling short of this amount of material in the inven and it needs to be replinished.
I hope i made myself clear. I would really appreciate if you can throw some light into this matter. You might be having similar reports or scenarious. please share with me.
i am assuming, i will be doing reporting on IM, MM, WM modules.
this report basically adds a lot of value to the end users and i would like to get your expertise suggestions and guidelines to make this happen.
You will be rewarded for sure.
You can email me at kalyan.sdn@gmail.com
Thanks
kavi