How "Date Filter" field in Customer table works?

selece28

Hi All,
My client wants me to check on customers with overdue balance. They want a reports that print out customers with overdue balance

I know we can do this easily by SETRANGE("Date Filter", 0D, CurrentDate)
Then CALCFIELDS("BALANCE DUE")
Then I just filter the BALANCE DUE fields on Customer table to get the Customer with Balance Due.

But i'm curious bout the DATE FILTER field in Customer table. I check its just a FlowFilter without any codes in the C/AL.
Maybe this is a stupid question, but can anyone explain me how this field works? And how can i see whats the value of this field?

Thanks in advance,

Waldo

This is just the "flowfilter" principle. In fact a way to make a flowfield more dynamical, and less static.

Usually a flowfield is a total of a certain column in a certain table. But sometimes you want to change that total, because you only want to total a small selection of all the records ... an that's where flowfilters comes into place.

You define a field, make it a flowfilter, and use this field in the calcformula of your flowfield. The, indeed, if you filter on that flowfilter, the flowfield is influenced by it ... and only shows you the total of that selection ... .

Hope this is a bit clear. I can always reference you to the DEV I course for a better explanation... .

selece28

Thanks your explanation help me understand.
I already know a little 'bout FlowField but for FlowFilter i dont have any experince.
Could you tell me wheres the FlowField for Date Filter in Customer table?
I try to find it but not found it yet

Thanks Waldo

Waldo

Date Filter field is field 55 in Customer table .. this IS the flowfilter (look at the "field class" property.

selece28

Yes i know field 55 is a FlowFilter
But When i do SETRANGE("Date Filter", 0D, Current Date)
This means i set Date Filter range from 0D until Current Date right?
My question is where Date Filter gets its value? Coz it seems that i cant find the value in Customer Card.

Thanks

Waldo

It does not get a value.
Ranging (filtering) the date filter (flowfilter) is the way to influence your flowfields, not by setting values, but by ranging a flowfilterfield.

A flowfilter-field never gets a value.

Savatage

personally I would Use the Customer Ledger Entries. Any balance due doesn't actually mean OVERDUE. It depends on the customer's terms. Maybe all their customers have the same terms, I don't know.

But if you filter on your report any entries that are:
1. open
2. Current Date >= Due Date

then total the "Remaining Amount"

selece28

OK, thanks Savatage, now i know the other method to SUM the Overdue Balance.

But Waldo

It does not get a value.
Ranging (filtering) the date filter (flowfilter) is the way to influence your flowfields, not by setting values, but by ranging a flowfilterfield.

A flowfilter-field never gets a value.

It makes me confuse :-k
Can u explain more, coz i'm lost. I thought a Flowfilter is filled by value from FlowField then get filtered (SetRange).
Then if its like u'r explanation, what's the FlowField for Date Filter field?

Maybe my question is a stupid question, forgive me, but could u explain more coz i'm new and i want to learn more bout this.

Thanks in advance,

Waldo

selece28 wrote:

Then if its like u'r explanation, what's the FlowField for Date Filter field?

Maybe my question is a stupid question, forgive me, but could u explain more coz i'm new and i want to learn more bout this.

Thanks in advance,

There are no stupid questions, only stupid answers .

There could be more then one flowfield that is using only one flowfilter (e.g. data filter). So, if you filter the field "date filter", then it could be that the totals of numerous flowfields are affected (depends if they have "date filter" in their calcformula).


E.g.
Customer table:
there is a flowfilter: Date Filter
If you look at flowfield "Net Change" (field 60), go to CalcFormula, and then to Table Filter: you see the Date Filter flowfilter (forth line)
If you go to flowfield "Balance Due" (field 66), got to CalcFormula, and then to Table Filter: you see the Date Filter flowfilter even two times!

selece28

Ow yes this is what i mean Waldo, thanks

So if i Ranging(Filtering) the Date Filter flowfilter, then all flowfield with Date Filter in their calcformula will triggered and count the value. Is this right?

Thanks

Waldo

Indeed, something like that 8)

ayhan06

create a new form. place "Customer" in the sourcetable property of it. place a tablebox onto it. add no.,name,date filter and some amount fields. filter "date filter" field in the OnOpenform trigger.save and run the form.see the values in the date filter column.by using shift+f7 shortcut, change date filter....hope this helps you understand.