Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
FactBox Data Source
doddwell
Member Posts: 65
Hello
We are a Property company and I have a Property Card in which I would like to display some associated Financial information in a Fact Box. The Financial information is a sum of some G/L Entry data. I have been looking at the Customer Card and can see that its Fact Boxes show data from FlowFields in the Customer table.
I can mirror that structure and add Financial Info FlowFields to the Property Table but I am wondering if that's the best approach. I don't need the Financial Info to be displayed with the List Page (only on the Card) - so I can see a performance disadvantage with adding the fields as FlowFields to the Property Table.
Many Thanks
We are a Property company and I have a Property Card in which I would like to display some associated Financial information in a Fact Box. The Financial information is a sum of some G/L Entry data. I have been looking at the Customer Card and can see that its Fact Boxes show data from FlowFields in the Customer table.
I can mirror that structure and add Financial Info FlowFields to the Property Table but I am wondering if that's the best approach. I don't need the Financial Info to be displayed with the List Page (only on the Card) - so I can see a performance disadvantage with adding the fields as FlowFields to the Property Table.
Many Thanks
0
Comments
The flowfields will only be calculated if you add them to the page or if you do a CALCFIELDS (or SETAUTOCALCFIELDS) - so as long as you do not add them to the list page then there will be no performance hit there. Obviously if you add to the Card page then it will need to calculated but only for 1 record at a time.