generating report

Hello…How to generate the age of an item based on a purchase date?

You need to customize the report

Age := Round((TODAY - “Purchase Date”)/365,1);


You can query the InventTrans to get the last purchase date for each item and calculate the time up to systemdate.



i will be getting tha data in Microsoft Nav dynamics

the quantity of the item that should be generate is the total quantity from the transaction of the previous months in a different age…for example today it has purchase of 12 quantity so it must be in the within 15 days as of today but there are remaining quantity from the previous month which must be in the other age…How can I do it?