Flowfields and Flowfilters

andisklavins
Member Posts: 8
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?
0
Comments
-
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.
DjangMan0 -
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?0
-
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.
DjangMan0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions