Skip to Content
0
Former Member
Nov 30, 2006 at 05:51 AM

Inventory Report

87 Views

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