About flowfilter in nav

(0) Share

Report

Posted on by bharathkarunakaran

475

Hi guys,

I have created an aging report to print the no. of pstd, invoices based on the due date and start date value with bucket value of 0-30, 31-60,61-90,>90 days.

But now I need to filter the data using the date filter(flow filter) in the customer table.

Can you help me on that ..

Warm Regards,

Bharath K

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Hannes Holst 5,767 on at

Like (0)

Report

Just filter as usual in C/AL-Code by using SETRANGE or SETFILTER.

The filter will be considered when executing CALCFIELDS.

Of course, under the circumstance that the FlowField actually offers to use the Date Filter as a Filter-Option.

Was this reply helpful? Yes No
bharathkarunakaran 475 on at

Like (0)

Report

Hi ,

Can use that as an array to put the values in the buckets for creating an aging report .

Warm Regards,

Bharath K

Was this reply helpful? Yes No
Brad_P 1,549 on at

Like (0)

Report

You'd need to call it for each bucket. Set the date filter range for the bucket, CALCFIELDS, get value, repeat for each bucket.

Was this reply helpful? Yes No
bharathkarunakaran 475 on at

Like (0)

Report

Sorry to ask ,

Can you give some example for that above explanation.

So that i can find it easy to understand.

Warm Regards

bharath k

Was this reply helpful? Yes No
Brad_P 1,549 on at

Like (0)

Report

I am not certain of your field, but you can fill in the variables.

Customer.Setfilter(FilterField,'Date1..Date2');

Customer.Calcfields(ValueField);

Value := value field;

You can repeat it, however putting the values in dimensioned variables to loop through would be "ideal"

Was this reply helpful? Yes No
nav.mukesh 619 on at

Like (0)

Report

I am assuming that you have created it based on Report 105.

Just set your PeriodStartDate before -

PeriodStartDate[2]:=Customer.GetFileter("Date Filter");

FOR i := 3 TO 5 DO

PeriodStartDate[i] := CALCDATE(PeriodLength,PeriodStartDate[i - 1]);

Was this reply helpful? Yes No