Flowfield Issue
ricky76
Member Posts: 204
I wondered if anyone could help. I have a field flowfield in table A that sums up the quantity from a decimal field in table B. However i only want to include it in the flowfield records that have a date greater or equal in table A than a date held in table B.
Example 2 records in table B
010108 - 10
010208 - 15
Records in table A
010108 - Flowfield should read 25
011508 - Flowfield should read 15 (ignoring the first record as the date is greater).
Can anyone help?
Regards,
Example 2 records in table B
010108 - 10
010208 - 15
Records in table A
010108 - Flowfield should read 25
011508 - Flowfield should read 15 (ignoring the first record as the date is greater).
Can anyone help?
Regards,
0
Comments
-
This cannot be done through flowfield definition. You need to add Date Fitler flowfilter field which will filter the data, which are summed and set this FlowFilter to correct filter for each record when showing them in a form.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 328 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
