Aging Inventory Report 10161

I am still very new at this so I apologize for asking such a basic answer.

This aging report does not calculate the age correctly because it is using the posting date which could be a transferr. How do I filter the posting date to the date of output?

Nav 6.0

DaysAged := WORKDATE - “Posting Date”;
TotalDaysAged := TotalDaysAged + DaysAged;
CALCFIELDS(“Cost Amount (Actual)”);
UnitCost := “Cost Amount (Actual)” / Quantity;

To set filters either use SETRANGE(field, fromdate, todate) or the more advanced SETFILTER(field, filtertext, filter1, filter2, …)

hi dennish,

and set the filter in Posting date itself.

Thanks again for everyone’s help