Module 1: DATA AND PROCESS MODEL
Module 2: MASTER TABLES AND PAGES
Module 3: DOCUMENTS
Module 4: POSTING
Module 5: FEATURE INTEGRATION
Module 6: REPORTING
Module 7: STATISTICS
Module 8: DIMENSIONS
Module 9: ROLE TAILORING
Module 10: INTERFACES
Module 11: WEB SERVICES
Module 12: TESTING AND DEBUGGING
Module 13: SQL SERVER OPTIMIZATION
- Lesson 1: SQL Server for Microsoft Dynamics NAV
- Lesson 2: Representation of NAV Tables and Indexes in SQL Server
- Lesson 3: Collation Options
- Lesson 4: SQL Server Query Optimizer
- Lesson 5: SQL Server Query Optimizer
- Lesson 6: Data Access Redesign
- Lesson 7: C/AL Database Functions and Performance on SQL Server
- Lesson 8: Bulk Inserts
- Lesson 9: Locking, Blocking, and Deadlocks
- Lesson 10: SIFT Data Storage in SQL Server
- Lesson 11: SQL Server Profiler
Lesson 2: Participants
The core business of CRONUS International Ltd. is organizing and delivering seminars. The Seminar Management solution must enable users to schedule seminars and enroll participants in the seminars. Very frequently, companies send several employees to participate in seminars, and those companies pay for their employees’ participation. Sometimes, participants are not related to a specific company, and they pay for seminar participation themselves.
CRONUS International Ltd. core functional requirements describe participants as persons who participate in seminars. For each participant, the solution must track the name, address, and contact details including at minimum, a telephone number and an email address. This means that the solution must give users a way to keep track of participants. This information is used for invoice processing.
One of the principles of solution design in Microsoft Dynamics NAV 2013 is to use standard functionality as much as you can. One of the customer’s nonfunctional requirements also emphasizes this principle whenever possible. The solution must not duplicate functions that are already present in the application or cause redundant functionality.
Therefore, you must make sure that you determine whether there is existing functionality in Microsoft Dynamics NAV 2013 that CRONUS International Ltd. can use to represent participants. Following is the minimum information that you must track:
- Phone Number
- Email Address
There are many tables in Microsoft Dynamics NAV 2013 that include this kind of information about an entity, You must determine whether there is a table that you can use, or if you must develop one.
Following are two candidate tables in Microsoft Dynamics NAV 2013 that both relate to sales and already contain all required fields and functionality:
- Table 18, Customer
- Table 5050, Contact
You may be able to use either of these tables to satisfy the requirement, and may not have to develop new tables. To make sure that you select the correct table, you must consider all requirements that may help you decide. There is a requirement that participants receive invoices for seminar participation. If participants pay for participation themselves, they receive the invoice. If a participant’s company pays for participation, the company receives the invoice. This means that there is a relationship between companies and participants. You have to make sure that the solution reflects that relationship.