Course 80437A: C/Side Solution Development in Microsoft Dynamics® NAV 2013

Type:Course
Audience(s):Developers
Technology:Microsoft Dynamics NAV
Level:200
This Revision:A
Delivery method:
Instructor-led (classroom)
Length:5 days
Language(s):English

First published:

13 December 2012
Overview
About this course
This five-day instructor-led course leads students through a simulated implementation project, where their goal is customize Microsoft Dynamics® NAV 2013 to meet customer’s requirement. It explains standard application concepts and provides insight into most important processes in Microsoft Dynamics NAV 2013, including documents and journals posting, dimension management, feature integration, role tailoring, and automating unit testing.
Audience profile
This course is intended for a partner that sells and implements the C/SIDE Solution Development module to customers. The typical partner has an ERP background.
At course completion
After completing this course, students will be able to:
  • Explain the different table types and their characteristics.
  • Present the standard data model and introduce the data-related business logic.
  • Present the standard process model that governs the transactions in Microsoft Dynamics NAV 2013.
  • Explain the master table and page standards.
  • Work with table event triggers.
  • Work with complex data types and their member functions.
  • Explain the multilanguage functionality.
  • Define the strategy for implementing Customers and Participants.
  • Create the tables to manage the seminar rooms.
  • Create instructor data management.
  • Create seminar data management.
  • Import and export objects as text files.
  • Support multilanguage functionality.
  • Use document pages.
  • Use virtual tables.
  • Use temporary tables.
  • Review the various types of tables.
  • Review different page and table C/AL functions.
  • Create additional tables and pages to maintain registrations.
  • Explain the working and posting tables.
  • Explain the posting routines and their relationships.
  • Create journal posting routines.
  • Create document posting routines.
  • Present the best practices for documenting changes to existing objects.
  • Program for minimum effect on the application.
  • Integrate previously created Seminar Management module features with one another.
  • Explain the architecture of the Navigate feature.
  • Extend the Navigate functionality to enable finding posted seminar information.
  • Enable easier searching for information by adding Navigate functionality to Seminar Management pages.
  • Enable looking up Seminar Management information from standard application areas.
  • Use report event triggers.
  • Use special report functions.
  • Create reports for the RoleTailored client.
  • Create a seminar participant list.
  • Create a ProcessingOnly report that posts invoices.
  • Create a page that calculates price sums efficiently.
  • Make the page available from the Seminar pages.
  • Use FlowFilters to easily calculate statistics for different time periods.
  • Describe Global, Shortcut, and Budget dimension types and their functions.
  • List the basic rules of Dimension Setup.
  • Present the dimension management data and process models.
  • Implement dimensions on the master record level.
  • Define the components of the RoleTailored user interface.
  • Explain the structure, purpose, and functionality of a Role Center-type page.
  • Create the Seminar Manager Role Center page.
  • Describe the functionality of the Departments page and the MenuSuite object type.
  • Integrate the Seminar Management department into the Departments page.
  • Explain how to use Automation and OCX to perform tasks with other applications.
  • Describe file handling functions to import or export data.
  • Describe Microsoft Dynamics NAV 2013 Web services architecture.
  • Explain the protocols that Microsoft Dynamics NAV 2013 uses for Web services.
  • Evaluate the benefits of Web services over other integration options in Microsoft Dynamics NAV.
  • Explain how to expose codeunit, page, and query objects as Web services.
  • Consume Web services from external applications.
  • Demonstrate the testing features of Microsoft Dynamics NAV 2013.
  • Explain the test codeunits, test functions, and handler functions.
  • Describe how to automate user interface testing.
  • Explain the functionality and purpose of test runner codeunits.
  • Develop a unit testing framework for the Seminar Management solution.
  • Describe the Debugger functionality and features.
  • Demonstrate the debugging process.
  • Explain the advantages of SQL Server for Microsoft Dynamics NAV 2013.
  • Work with tables and indexes.
  • Use collation options and descriptions.
  • Explain SQL Server Query Optimizer.
  • Explain the areas within Microsoft Dynamics NAV that can be optimized.
  • Explain how the Microsoft Dynamics NAV database driver enables the Microsoft Dynamics NAV clients to communicate with SQL Server.
  • Understand the performance effect of locking, blocking and deadlocks.
  • Understand how SIFT data is stored in SQL Server.
  • Present the case study for the CRONUS International Ltd. implementation project.
  • Provide test scripts for function testing of customized functionality.
Course details
Course OutlineModule 1: Data and Process ModelThis module explains the standard application functionality in Microsoft Dynamics NAV 2013 and it discusses the importance of following the same standards in all customizations.Lessons
  • Table Types and Characteristics
  • Standard Data Model
  • Standard Process Model
After completing this module, students will be able to:
  • Explain the different table types and their characteristics.
  • Present the standard data model and introduce the data-related business logic.
  • Present the standard process model that governs the transactions in Microsoft Dynamics NAV 2013.
Module 2: Master Tables and PagesThis module explains what is involved in solution development to meet customer requirements.Lessons
  • Prerequisite Knowledge
  • Participants
  • Instructors and Rooms
  • Seminars
Lab : Customize Resource Tables and PagesLab : Creating Seminar Tables and Pages
After completing this module, students will be able to:
  • Explain the master table and page standards.
  • Work with table event triggers.
  • Work with complex data types and their member functions.
  • Explain the multilanguage functionality.
  • Define the strategy for implementing Customers and Participants.
  • Create the tables to manage the seminar rooms.
  • Create instructor data management.
  • Create seminar data management.
Module 3: DocumentsThis module explains the purpose and benefits in using documents to enter transactions in Microsoft Dynamics NAV 2013. Lessons
  • Prerequisite Knowledge
  • Registrations
  • Reviewing the Table Code
Lab : Importing, Reviewing, and Completing the Seminar Registration TablesLab : Create Seminar Registration Pages
After completing this module, students will be able to:
  • Import and export objects as text files.
  • Support multilanguage functionality.
  • Use document pages.
  • Use virtual tables.
  • Use temporary tables.
  • Review the various types of tables.
  • Review different page and table C/AL functions.
  • Create additional tables and pages to maintain registrations.
Module 4: PostingThis module explains the posting routine.Lessons
  • Prerequisite Knowledge
  • Posting Seminar Registrations
Lab : Reviewing and Completing the Journal and Ledger TablesLab : Creating Codeunits and Pages for Seminar Journal PostingLab : Creating the Tables and Pages for Posted Registration InformationLab : Modifying Tables, Pages, and Codeunits for Resource PostingLab : Creating the Codeunits for Document Posting
After completing this module, students will be able to:
  • Explain the working and posting tables.
  • Explain the posting routines and their relationships.
  • Create journal posting routines.
  • Create document posting routines.
  • Present the best practices for documenting changes to existing objects.
  • Program for minimum effect on the application.
Module 5: Feature IntegrationThis module explains the integration of custom features into standard functionality to provide a seamless and familiar experience to the users.Lessons
  • Prerequisite Knowledge
  • Seminar Feature Integration
  • Navigate Integration
Lab : Integrating Seminar FeaturesLab : Changing Objects to Integrate with Navigate
After completing this module, students will be able to:
  • Integrate previously created Seminar Management module features with one another.
  • Explain the architecture of the Navigate feature.
  • Extend the Navigate functionality to enable finding posted seminar information.
  • Enable easier searching for information by adding Navigate functionality to Seminar Management pages.
  • Enable looking up Seminar Management information from standard application areas.
Module 6: ReportingThis module explains reporting principles.Lessons
  • Prerequisite Knowledge
  • Reporting Lab Overview
  • Participant List Reporting
  • Invoice Posting Batch Job
Lab : Creating the Seminar Participant ListLab : Creating the Invoice Posting Batch JobModule 7: StatisticsThis module explains the different types of statistics in the standard application.Lessons
  • Prerequisite Knowledge
  • Seminar Statistics
Lab : Creating FlowFields for SumsLab : Creating the Seminar Statistics Page
After completing this module, students will be able to:
  • Create a page that calculates price sums efficiently.
  • Make the page available from the Seminar pages.
  • Use FlowFilters to easily calculate statistics for different time periods.
Module 8: DimensionsThis module explains the importance of dimensions and their use throughout the standard application and accompany all transactional data and process.Lessons
  • Prerequisite Knowledge
  • Integrating Seminar Management with Dimensions
Lab : Integrating with Dimension Management
After completing this module, students will be able to:
  • Describe Global, Shortcut, and Budget dimension types and their functions.
  • List the basic rules of Dimension Setup.
  • Present the dimension management data and process models.
  • Implement dimensions on the master record level.
Module 9: Role TailoringThis module explains the importance of user roles and profiles in Microsoft Dynamics NAV 2013.Lessons
  • Prerequisite Knowledge
  • Seminar Manager Role Center
  • MenuSuite Object Type
  • Seminar Management Department Page
Lab : Create the Seminar Manager Role CenterLab : Create Seminar Management Department Page
After completing this module, students will be able to:
  • Define the components of the RoleTailored user interface.
  • Explain the structure, purpose, and functionality of a Role Center-type page.
  • Create the Seminar Manager Role Center page.
  • Describe the functionality of the Departments page and the MenuSuite object type.
  • Integrate the Seminar Management department into the Departments page.
Module 10: InterfacesThis module explains how interfacing with features or applications outside Microsoft Dynamics NAV is a frequent requirement. It also describes the different types of interfacing features that are present in Microsoft Dynamics NAV. Lessons
  • Prerequisite Knowledge
  • Email Confirmation
Lab : Create Email Confirmations
After completing this module, students will be able to:
  • Explain how to use Automation and OCX to perform tasks with other applications.
  • Describe file handling functions to import or export data.
  • Design and implement email capability.
Module 11: Web ServicesThis module explains what web services are and how they are used in Microsoft Dynamics NAV 2013.Lessons
  • Prerequisite Knowledge
  • Registration Web Service
Lab : Creating a Web ServiceLab : Create a Windows Forms Application to Test the Web Service
After completing this module, students will be able to:
  • Describe Microsoft Dynamics NAV 2013 Web services architecture.
  • Explain the protocols that Microsoft Dynamics NAV 2013 uses for Web services.
  • Evaluate the benefits of Web services over other integration options in Microsoft Dynamics NAV.
  • Explain how to expose codeunit, page, and query objects as Web services.
  • Consume Web services from external applications.
Module 12: Testing and DebuggingThis module explains testing practices and presents the test-driven development (TDD) approach followed by Microsoft.Lessons
  • Prerequisite Knowledge
  • Testing Seminar Management
  • Debugging
Lab : Create Seminar Management Unit Tests
After completing this module, students will be able to:
  • Demonstrate the testing features of Microsoft Dynamics NAV 2013.
  • Explain the test codeunits, test functions, and handler functions.
  • Describe how to automate user interface testing.
  • Explain the functionality and purpose of test runner codeunits.
  • Develop a unit testing framework for the Seminar Management solution.
  • Describe the Debugger functionality and features.
  • Demonstrate the debugging process.
Module 13: Optimizing for SQL ServerThis module explains the SQL Server for Microsoft Dynamics NAV 2013.Lessons
  • SQL Server for Microsoft Dynamics NAV
  • Representation of Microsoft Dynamics NAV Tables and Indexes in SQL Server
  • Collation Options
  • SQL Server Query Optimizer
  • Optimizing a Microsoft Dynamics NAV Application
  • Data Access Redesign
  • C/AL Database Functions and Performance on SQL Server
  • Bulk Inserts
  • Locking, Blocking, and Deadlocks
  • SIFT Data Storage in SQL Server
  • SQL Server Profiler
Lab : Analyze Index UsageLab : Optimize C/AL Code
After completing this module, students will be able to:
  • Explain the advantages of SQL Server for Microsoft Dynamics NAV 2013.
  • Work with tables and indexes.
  • Use collation options and descriptions.
  • Explain SQL Server Query Optimizer.
  • Explain the areas within Microsoft Dynamics NAV that can be optimized.
  • Explain how the Microsoft Dynamics NAV database driver enables the Microsoft Dynamics NAV clients to communicate with SQL Server.
  • Understand the performance effect of locking, blocking and deadlocks.
  • Understand how SIFT data is stored in SQL Server.
Module 14: AppendixThis module contains reference information about the case study that is implemented throughout the course.Lessons
  • CRONUS International Ltd.
  • Functional Requirements
  • Content Structure
Lab : Function Testing
After completing this module, students will be able to:
  • Present the case study for the CRONUS International Ltd. implementation project.
  • Provide test scripts for function testing of customized functionality
Prerequisites
Before attending this course, students must have:
  • knowledge of Microsoft Dynamics NAV 2013
  • completed course 80436A C/SIDE Introduction in Microsoft Dynamics NAV 2013
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks:

Find a Microsoft Learning Partner near you