Why there is always Flow Filter for a Date Filter available on Documents List?

elnowako · 2016-09-08

Hi All,

Why there is always a Flow Filter set on Date Filter with a date before today value on Sales Order and Sales Quotes list?

kabroco · 2016-09-08

In Page 9300 there is a line of code
OnOpenPage()
SetSecurityFilterOnRespCenter;
In that function is set a date filter.

SetSecurityFilterOnRespCenter()
IF UserSetupMgt.GetSalesFilter <> '' THEN BEGIN
FILTERGROUP(2);
SETRANGE("Responsibility Center",UserSetupMgt.GetSalesFilter);
FILTERGROUP(0);
END;

SETRANGE("Date Filter",0D,WORKDATE - 1);

Theunis_Modderman · 2016-09-08

Like the other List-Pages on table 36 (Sales Order List, Sales Invoices etc.), the Sales Quotes-Page has also a few FactBoxes. They are linked with a SubPageLink that says No.=FIELD(Bill-to Customer No.),Date Filter=FIELD(Date Filter). So the filter is basically set in order to be copied to the factboxes...

kabroco · 2016-09-08

In Page 9300 there is a line of code
OnOpenPage()
SetSecurityFilterOnRespCenter;
In that function is set a date filter.

SetSecurityFilterOnRespCenter()
IF UserSetupMgt.GetSalesFilter <> '' THEN BEGIN
FILTERGROUP(2);
SETRANGE("Responsibility Center",UserSetupMgt.GetSalesFilter);
FILTERGROUP(0);
END;

SETRANGE("Date Filter",0D,WORKDATE - 1);

Theunis_Modderman · 2016-09-08

Like the other List-Pages on table 36 (Sales Order List, Sales Invoices etc.), the Sales Quotes-Page has also a few FactBoxes. They are linked with a SubPageLink that says No.=FIELD(Bill-to Customer No.),Date Filter=FIELD(Date Filter). So the filter is basically set in order to be copied to the factboxes...

postsaurav · 2016-09-08

To put it simply -

A Flowfilter is used for filtering flowfields.

Let's see -

1. Open your customer List Page -
2. Add Field Net Change in the List either by developer Environment.
3. Now From the Advanced Filter apply date filter lets say Last month.
4. you will see that the value of net change will change based on your filter.

Only records which were between those days will be considered for calculation of flow field (Net Change).

This should give you a demo case also -

https://www.youtube.com/watch?v=DXBoINO7qCs

elnowako · 2016-09-08

Thank you for the explanation. This is exactly what I need.

Why there is always Flow Filter for a Date Filter available on Documents List?

Best Answers

Answers

Categories