Report for showing comparsion between Inventory & Norms

[Former Member]

Hi All,

I have a requirement for developing a report where I need to compare the current inventory for a plant and compare it with the predecided inventory norm & to get red flagged in case there is a dissference between this comparision.

Regards,

Vivek

[former_member218067 · Accepted solution]

Hi,

Current Inventory is available in table MARD at storage location level with different stock types

From where you are going to pull the norms ? Probabaly may need to create one Z table to update norms

with Material, Qty stock type and storage location and run report between MARD and Z table

Just to give you head start, you can explore further

Thanks

Diwakar

[Former Member · Accepted solution]

Thanks Diwakar,

Secondly, is there any way I can develop any dashboard system to raise flag in case there is deviation.

Regards,

Vivek

[Former Member]

Query Answered