Microsoft Dynamics NAV - C/SIDE Solution Development -

Microsoft Dynamics NAV – C/SIDE Solution Development

Locus IT ServicesMicrosoft Dynamics NAV – C/SIDE Solution Development

Lesson 2: Seminar Statistics

Seminar Statistics

Seminarstatistics lets the user quickly and easily retrieve an overview of the price statistics for a specific seminar.

Solution Analysis

You can use FlowFields and FlowFilters on the seminar solution to provide statistics as described in the functional requirements in Module 1, Business Case Diagnosis and Analysis. The client requires statistics for different time periods, such as for a month, for last year, for this year, and up to the current date.

This requirement indicates that the client wants to open a Statistics page from a Seminar page. This page calculates the statistics for the total price and shows it for the four time periods that are listed. Seminar managers should have access to the seminar statistics from a Seminar Detail page. This page calculates the total price statistics for the seminar for the time periods that are indicated in the function requirements.

Solution Design

The Seminar Statistics page must be available from the Related Information menu on the Seminar Card and Seminar List pages. The SeminarStatistics page automatically calculates the statistics for the selected seminar by using the information from the Seminar Ledger Entry page.

Seminar Card (Page 123456700): The Seminar menu selection on the Related Information button on this page is changed to include a new command for seminar statistics.

Seminar List (Page 123456701): The Seminar menu selection on the Related Information button on this page is changed to include a new command for seminar statistics.  The solution requires the addition of FlowFields and FlowFilters to the Seminar table (123456700). Also, a key of Seminar No., Posting Date, Charge Type, Chargeable is added to the Seminar Ledger Entry table 123456732.

Use values from the Seminar Ledger Entry page to calculate the Total Price, Total Price (Chargeable) and Total Price (Not Chargeable) in the Seminar table, for four time periods. Use an array of four dimensions to store the totals for each of these three prices. Use the standard DateFilter-Calc codeunit to calculate date filters for the time periods. With the date filters, you can filter the Seminar table and use it to calculate the price fields that are shown on the page for each time period.

Locus IT Project Management Office
What’s it?