how can i use flowfilter?

4711 · 2006-03-15

i got confusion.
i do not know how to use flowfilter and its benefit .
Does anyone could give me a hand?
thank you :?:

kriki · 2006-03-15

Flowfilters are used to filter on Flowfields.

Lets take Field 68:"Inventory" in Table 27:"Item".
This flowfield shows you the total inventory in all locations of current item.
If you are only interested in having the inventory in location "RED", what can you do.
There is a field "Location Filter", you can just put a filter on it (button flowfilter or SHIFT+F7) and it shows you only the inventory for location RED.
Of course:to be able to use "Location Filter", you need to put this field in the Calcformula of the flowfield.

johnson_alonso · 2006-03-15

Its benefit is
"FlowFilter fields let you set ranges on the calculations shown in FlowFields. For instance, if a FlowField contains the total of customer entries, you can use a FlowFilter to see the total for a single month or range of months"

e.g. :
if you select the location filter field of item table and press shift + F4, you can see flowfilter is a choice in the FieldClass property and it relates to tableRelation property.

rgds,
Johnson Alonso

andrejsm · 2006-03-15

Simple Example.
Open chart of account. Press view -> FlowFilter . There will be a list of available flowfilters. For example you could set "Date Filter", then press OK and in the chart of account form in the column "Balance at Date" you will get balance at date which you set in "Date Filter".
The main benefit is that flowfilters in connecition with flowfields works very fast.

4711 · 2006-03-15

i have got your advice.
and then i want to know the use of flowfilter in the development.

johnson_alonso · 2006-03-15

It will have the same as what all people have asnwered here. when you create something for example : an inventory field in a production order component table in a production order, you will have to use flowfilter besides another. I think flowfilter locates only in the properties of a table.

rgds,
Johnson Alonso

"Strength beyond strength"

4711 · 2006-03-15

thank you very much

kosta · 2006-03-15

4711 wrote:

i have got your advice.
and then i want to know the use of flowfilter in the development.

You must use the CALCFIELDS function to update them. For example, if you retrieve a record using the FIND and NEXT functions, the system sets the FlowFields in those records to zero (0). Then, when you call CALCFIELDS, the system updates their values.

how can i use flowfilter?

Comments

Categories