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 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]);
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"
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
Hi ,
Can use that as an array to put the values in the buckets for creating an aging report .
Warm Regards,
Bharath K
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (