Course Outline
Module 1: Objects
- The Object Designer
- Overview of the Types of objects that can be managed- Where objects are stored
– The Logical Database
- The use of License files to enable access to objects
- The significance of IDs and ranges
- The role of properties and triggers
Module 2: Tables
- The Role of Tables an overview
- Table Properties and their Usage
- The Use of Triggers in Tables
- An Overview of Field Properties
Module 3: Pages
- The Role of Pages an Overview
- Page Properties and their Usage
- The Use of Triggers in Pages
- Controls in Pages an Overview
- The use of Controls in Making a Card Page
- Using Controls in a List Page
- Control Properties an Overview
- Triggers in Controls
- The use of Page Parts
- An Introduction to Actions
Module 4: C/AL Programming (Classic)
- Using C/AL statements in Triggers an Overview
- The use of Code Units as a code Container
- C/AL Syntax, Variables and Identifiers
- Data Types
- Arrays
- Variable Assignment intro
- The use of the Symbol Menu
- Using Code Completion
- Expressions
Module 5: C/AL Programming (Classic) Statements
- Conditionals If Then Else and Case
- Looping Repetitive execution
Module 6: C/AL Programming (Classic) Built In Functions
- Data Access
- Sorting
- Filtering
- Data Manipulation
- Field Functions TestField and Validate
- Interaction Functions Message
- String Functions
- Date Functions
- Numeric Functions
- System Functions
- Array Manipulation Functions
- Stream Functions
Module 7: C/AL Programming (Classic) Custom Functions
- Creating your own Functions
- Defining Parameters
- Calling your Function
- Function Scope
Module 8: Reporting
- Report Objects an Overview
- The Design Process Overview
- Creating a Data Model using The Data Set Designer
- Report Properties and Data Item Properties
- Column Properties
- Designing the layout
- The use and designing of Request Pages
- Triggers and Functions in Reports
Module 9: Code Unit Objects
- Introduction to the Code Unit Object
- Accessing Code Units
Module 10: Query Objects
- An Overview of the Query Object
- Using the Query Designer
- Using C/AL to run Queries
- Mapping Queries to T-SQL
Module 11: XMLPORTS for importing and exporting data
- An Overview of XMLPORT functionality
- Designing an XMLPORT
- XMLPORT Properties
- Using XMLPORTS to transfer Plain Text
- Using C/AL to run the import or export process
Module 12: Application design Principles and Coding Guidelines
- Overview of Design Patterns and Anti Patterns
- Extensions only in the 365 Product
- Coding Guidelines
- Introduction to Events
- Using Hooks when events are not available
- Multi-language facilities
Module 13: The data process model
- Functional Table Types and flows
- The Standard Data Model
- Set Up Tables and The Implementation of the Singleton Pattern
- Master Table and Page Standards
- Creating a Document Page
- Page Functions frequently used in the page object
- Document and Journal Functions
- Journals v Ledgers when to use
- Journal Posting Flow
- Posting Design Patterns
- Document Posting Routines
- Document posting Design Patterns
- Document Posting Setup Patterns
Module 14: Course Review
- Course Review
