Microsoft Dynamics AX 2012 R3 Development - Level 1

Learn to design and create tables in Microsoft Dynamics AX 2012 R3, apply naming conventions, define table relations, and follow best practices with design and documentation.

Learn to create extended data types in Dynamics AX 2012 R3, base them on primitive types, and reuse them across tables to improve readability, consistency, and data integrity.

Create and design various forms in AX 2012, including tree forms, using templates, link them to tables, and drag data into grids to build functional forms.

Create a table relation in AX 2012 by linking the child table's employee i.d. to the parent employee table, name the relationship, and validate the link for data access.

Create and customize a simple form in AX 2012, add a data source and controls, enter and save new employee records, and arrange fields with extended date fields.

Learn to create and use enums in AX 2012, including defining values in the database and binding them to UI controls like combo boxes and radio groups.

Create and attach an information part in AX 2012, configuring groups, fields, and data sources, and linking employee skill via a query and a relation for display in forms.

Learn to create and use the form part in AX 2012 by building a new table, adding fields, and configuring data sources and design.

Create and attach a form part in ax 2012 r3, add a new menu item, customize the form template, set an index, and ensure proper data references while optimizing performance.

Create simple queries in ax 2012 using either a graphical interface or code, define data sources and fields, and apply them to reports, forms, or an info pack.

Create a query with multiple data sources in ax 2012 by linking a parent table to two child tables and joining on employee I.D.

Explore views in AX 2012 as virtual tables that dynamically combine data. Create and synchronize a view from multiple tables, with a compiled definition that can improve performance.

Explore conditional table relations in Microsoft Dynamics AX 2012 R3 development, using field fix and related field fix to filter records in a primary–related table setup, such as male employees.

Create the assignment's data model for field fix, defining two base types (men/women/children and Nike/Puma/Adidas) and an extended type with name, color, and size.

Explore the assignment solution by implementing enums for collections and brands, extending the database with color and size fields, and establishing relationships across tables and forms.

Build a field-fixed conditional relation between parent and child tables, linking by collection type to filter brand codes and show gender-specific records.

Explore how indexes in Microsoft Dynamics AX 2012 R3 improve data retrieval and enforce unique records, and learn to create, enable, and manage system indexes synchronized with the database.

Turn a unique index into the table's primary key by setting its key property to yes, and designate employee_id as the primary key (surrogate key and default index context).

Learn how to create and use a cluster index in Microsoft Dynamics AX 2012, switch to the employee id, and synchronize to enforce a desired record sequence for performance tuning.

Explore creating an extended data type array, add elements like address, zip code, and country, and apply them to a table and a form in Microsoft Dynamics AX 2012 R3.

Learn to design an extended data type lookup in ax 2012 r3 by turning a text field into a dropdown bound to the employee table.

Add multiple data sources to a form by linking the employee and skill tables with a joint data source and parent-child relationships. Ensure the related records update automatically.

Explore active link types in Microsoft Dynamics AX 2012 R3 development, showing how an active link updates records immediately and can affect performance with large data sets.

Explore the delay link type in Dynamics AX 2012 R3 development, replacing the active method to speed navigation on large datasets by delaying child updates until focus or stop scrolling.

Implement passive link type in AX development by overriding the active method and invoking execute to update the data source, and expose a button to trigger manual updates.

Explore the inner join link type in dynamics ax 2012 r3 development, showing how only matching records from two tables appear and non-matching records are eliminated.

Explore the outer join link type in Dynamics AX 2012 R3 development by fetching all records from the main table and matched records from the child table for reports.

Explore the exist join link type in Microsoft Dynamics AX 2012 R3, contrast it with inner and outer joins, and learn how it processes only the first matching child record.

Explore the not exist join type in Dynamics 2012, selecting main-table records with no match in the joined table, and contrast it with inner joins.

Learn to create and use labels in Microsoft Dynamics AX 2012 R3 with label editor, applying text to ui elements and using the level editor for tables, forms, and reports.

Explore how to create and use menu items in Microsoft Dynamics AX 2012 R3 to provide access to forms and reports, covering display, action, and output fact menu types.

Create and configure display menu items in the Dynamics AX project to present employee data from the HR module, linking forms or tables to a front-end menu and testing navigation.

Create and use action menu items in Microsoft Dynamics AX 2012 R3 by linking a menu item to a class method and testing with hello world.

Create a simple query-based report by building a query, selecting fields, and designing the report, then deploy it and link to an output menu item in Dynamics AX 2012 R3.

Create a query-based report with a custom parameter by building a new report project, configuring the data set, fields, and a query, then design the report and apply auto design.

Add a parameter and group a query-based report in Microsoft Dynamics AX 2012 R3, configuring fields, deploying changes, and filtering by shipping requested, customer, and sales order.

Design and customize a query-based report by adding headers, footers, and a report body, configuring datasets, parameters, and fields, and deploying with layout, margins, and orientation settings.

Design and deploy a Dynamics AX 2012 R3 report by adding groupings by society, row numbers, page numbers, batch breaks, headers, and totals for accurate, paginated summaries.

Fix the report format in Microsoft Dynamics AX 2012 R3 by setting group-based row numbers and two-decimal totals, deploy updates, and validate across pages.

Create and add a new user in Microsoft Dynamics AX 2012 R3 via system administration and Active Directory import, then configure roles, passwords, and profile settings.

Assign a security role to a user in Microsoft Dynamics AX 2012 R3 to grant report access, verify by logging in, and remove the role to revoke access.

Apply security policies to a report by creating a privilege, duty, and rule, then assign access to a specific user or group.

Explore a high level overview of security in Microsoft Dynamics AX 2012, covering security policies, rules, roles, duties, privileges, and permissions to control user access.

Learn to configure view, create, and delete privileges in Microsoft Dynamics AX 2012 R3 by linking entry points, menu items, and duties to roles and demo users.

Create and assign a security role from the AX client by defining duties, privileges, and permissions in system administration, then map them to users and sales order access.

Apply best-practice checks to a student table, fix labels and mandatory fields, set primary key rules, build field groups and relationships, and achieve zero remaining issues.

Learn how to export and import objects in Microsoft Dynamics AX 2012 R3 development, including tables and labels, with practical steps and best-practices backup for moving between environments.

Learn how to export and import a project and its label file, including private projects, destination folders, and object comparisons before importing.

In this MorphX VCS lecture, explore the modern version control system in Dynamics AX 2012, compare local, centralized, and distributed setups, and learn checkout, history, and revert to earlier versions.

Explore the 16 layers in ax 2012, including the core application, application object layer, globalization, feature pack, solution, and independent software vendor layers.

Understand how models in Microsoft Dynamics AX 2012 organize elements within layers, including the model store, deployment artifacts, and export/import workflows to move configurations between environments with minimal downtime.

Create and manage AX 2012 models using both model management and command-line tools; set the current model, define publisher and layer, and import or export model files.

Learn to create a dynamics ax 2012 model from xml by building a manifest, generating the smi file, and importing the xml via the command line.

Learn to edit a Microsoft Dynamics AX 2012 R3 model using direct edits and by updating a model file from a shared drive, adjusting version and publisher, and publishing changes.

Learn how to add elements such as tables to a model in Ax 2012, assign elements to the correct model, move items between models, and export or import models.

Drain the users from the application object server during maintenance by rejecting new clients and notifying active users, then restart the server to complete the process.

Learn how to export a Dynamics AX 2012 model to a model file and import it back into the model store.

Import a model in AX 2012 by running the import command, selecting the file, resolving conflicts by overwriting when necessary, and then compile and synchronize to complete maintenance.

Delete the demo one model using the delete command, confirm the deletion, restart, compile, and synchronize, then re-import the demo one model to restore elements.

Explore the high level database architecture of Microsoft Dynamics AX 2012, including the transaction database, model store, baseline data, and associated reporting and SharePoint integrations.

Learn how to back up and restore the Dynamics AX 2012 database by draining users, stopping the service, taking a full backup offline, then restoring and restarting the service.

Identify which tables and fields are used in a Dynamics AX 2012 R3 form by inspecting the design and using personalize to trace customer reference and requisition through sales orders.

Identify and map security roles to a specific entry point, such as price and discount, by examining related duties, privileges, and full control access.

Learn how to create an auto report in Microsoft Dynamics AX 2012 R3 by selecting fields, using a field group, and generating a simple order report from a table.

Configure the Dynamics AX 2012 report to send by email, set the outgoing mail server, define the destination email, and schedule recurrence with timezone, start time, and frequency.

Deploy default AX 2012 cubes to analysis service by selecting the analysis project in Visual Studio and deploying. Process the deployment to create the database and browse the cubes.

Learn to create a perspective in Ax 2012 by building a cube, adding views and tables, configuring transactions, and deploying the setup to the server.

Deploy a custom cube to ssas on ax 2012 by configuring deployment and processing options, then explore the deployed cube with measures and attributes like vendor and currency.