Hi,
I have develop a report that is counting payments by looking at document Payment and subtract it from the months queried using start period and end period to get the months owed. The months owed is a global variable of type decimal. I want my report to be able to filter by months owed. say filter by all customers who owed 2months- 3months or 4months and so on.
How can i do this? Can someone help me please.
Thanks
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
monthsfilter text 250;
auxmonths record integer;
OnAfterGetRecord
monthsOwned := CalculateTheMonthsOwnedFunction("Customer");
IF (monthsfilter <> '') THEN
BEGIN
AuxMonths.SETFILTER(Number,MonthsFilter);
AuxMonths.Number = ROUND(monthsOwned,'>',1);
IF (NOT AuxMonths.FIND) THEN
CurrReport.SKIP;
END;
Kine, Can you please explain to me in steps form like apertierra does how to use the temp table.
Thanks
If you really need to ask where the code I put needs to go, you migth better ask your NSC to create the report for you.
Thanks