We have the requirement to calculate the ageing of the raw material in the inventory which is not consumed for 30 days and 60 days and 90 days
we use the logic age = GR date of the raw material To till date that lay in the inventory without consumption.
my question is. we do lot of GR for a material and put in the same place in the storage location. and consume partial amount for the production (GI )
So how we can calculate the age of the material with refernce to GR. Since wedonot know what material is used which is received by which GR no.,