How "Date Filter" field in Customer table works?

selece28
selece28 Member Posts: 316
edited 2007-05-15 in NAV/Navision Classic Client
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,
______________

Regards,
Steven

Comments

  • Waldo
    Waldo Member Posts: 3,412
    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... .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • selece28
    selece28 Member Posts: 316
    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
    ______________

    Regards,
    Steven
  • Waldo
    Waldo Member Posts: 3,412
    Date Filter field is field 55 in Customer table .. this IS the flowfilter (look at the "field class" property.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • selece28
    selece28 Member Posts: 316
    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
    ______________

    Regards,
    Steven
  • Waldo
    Waldo Member Posts: 3,412
    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.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Savatage
    Savatage Member Posts: 7,142
    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"
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • selece28
    selece28 Member Posts: 316
    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,
    ______________

    Regards,
    Steven
  • Waldo
    Waldo Member Posts: 3,412
    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 :wink: .

    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!

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • selece28
    selece28 Member Posts: 316
    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
    ______________

    Regards,
    Steven
  • Waldo
    Waldo Member Posts: 3,412
    Indeed, something like that 8)

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • ayhan06
    ayhan06 Member Posts: 210
    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.

Categories