Flowfields and Flowfilters

andisklavins

Why doesn't Date Filter Flowfilter on affect flowfield in for example Client table's Balance field? As far as I know, there are some properties that enable this, but there are not set in Demo database. Is there any underwater stones?

DjangMan

The data filter doesn't affect the balance because the CalcFormula for Balance doesn't include the date filter in it's calculations.

In the G/L Account table you see two columns Balance and Balance at Date. Balance at Date uses the Date Filter, Balance does not.

DjangMan

andisklavins

OK, but how about e.g. Client table. There is no Balance at Date field. Won't there be any negative consequences adding date filter to CalcFormula?

DjangMan

As long as the existing code didn't reference that field then the existing fields would be fine. However, if the user added a flow filter then the field value would change and they might not know why right away.

I'm a big proponent of leaving existing functionality alone when ever possible and adding new fields to handle new functionality. That way when you're upgrading your life is made easier and you don't have to worry about other objects that rely on the standard fields remaining un-touched.

DjangMan