Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Adding Total Button in Form No. 20 General Ledger Entries
Sbhat
Member Posts: 301
One of our user is requesting a Variable Field called 'Total Amount' button on Form no. 20 General ledger entries, whenever user drills down from Chart of accounts to Form no. 20 at the bottom they want to see a Total of Amount field from G/L entry, even if they filter on the Form no. 20 G/L entry the Total amount should change showing the Amount total for Filtered lines.
Is this doable and If yes, can someone please tell me how.
Many Thanks
S.
Is this doable and If yes, can someone please tell me how.
Many Thanks
S.
0
Comments
yes this is doable. Maybe different in pages... What you need:
- a variable to store the current filters on the table,
- a function to do the calculation and save the result to a display variable,
- use of the apropriate triggers and properties. You would need to set UpdateOnActivate, and you should call the calculation on activation, and when a record is fetched. The actual calculation should only be performed when the filters on the table have changed (in that spirit, anyway).
with best regards
Jens