Inventory Aging report

Hi,

One of our customers required to know what inventory is lying unutilised for the last 5 years or greater.

Hence need to know how does JDe support that.

I understand that there is no Std. JDe report for this.

I am considering the Date updated field to be used for F41021(Item avl.) table to achieve this as this is one of the most simple ways i thought of.

Alternately also thinking if to identify the items according to the lots and to check if it has been used in various transactions for a period of less than 5 years. If not, then that item lot could be marked as unused for last 5 years and qty can be summed up to show up the same in the report