I have a requirement from user where we need to display consumption of quantities, Prompt help will

Consumption of any material is Issued Quantity From Inventory. Once Po Receipt Delivered Item Quantity Increased After Item Quantity Issue on Job Or Transfer, Move Order Issue, Or Any Negative Material Transactions.

For Ex. Item Code L01701301145  its Overall Consumption is

Transaction Type is Other Than PO Receipt and Transaction Quantity in Negative.

For Above Item Code Total Po Receipt Quantity is 4

And Consumption  4 time WIP Issue with 1 qty Means 4 Quantity Consumed.

And To Organized this Transaction Date wise like

For 3 Month Consumption Today’s Date- 90 Days.

For 6 Month Consumption Today’s Date- 180 Days.

For 1 Year Consumption Today’s Date- 364 Days