PacktLib: Microsoft Dynamics AX 2012 Development Cookbook

Microsoft Dynamics AX 2012 Development Cookbook


About the Author

About the Reviewers


Processing Data


Creating a new number sequence

Renaming the primary key

Merging two records

Adding a document handling note

Using a normal table as a temporary table

Copying a record

Building a query object

Using a macro in an SQL statement

Executing a direct SQL statement

Enhancing the data consistency check

Exporting data to an XML file

Importing data from an XML file

Creating a comma-separated value file

Reading a comma-separated value file

Using the date effectiveness feature

Working with Forms


Creating a dialog

Handling a dialog event

Building a dynamic form

Adding a form splitter

Creating a modal form

Modifying multiple forms dynamically

Storing last form values

Using a tree control

Building a checklist

Adding the View details link

Working with Data in Forms


Using a number sequence handler

Creating a custom filter

Creating a custom instant search filter

Building a selected/available list

Preloading images

Creating a wizard

Processing multiple records

Coloring records

Adding an image to records

Building Lookups


Creating an automatic lookup

Creating a lookup dynamically

Using a form for building a lookup

Building a tree lookup

Displaying a list of custom options

Another way of displaying custom options

Building a lookup based on record description

Building the Browse for Folder lookup

Building a lookup for selecting a file

Creating a color picker lookup

Processing Business Tasks


Using a segmented entry control

Creating a general journal

Posting a general journal

Processing a project journal

Creating and posting a ledger voucher

Changing an automatic transaction text

Creating a purchase order

Posting a purchase order

Creating a sales order

Posting a sales order

Creating an electronic payment format

Integration with Microsoft Office


Creating an Excel file

Reading an Excel file

Creating a Word document from a template

Creating a Word document with repeating elements

Creating a Microsoft Project file

Sending an e-mail using Outlook

Usin´╗┐g Services


Consuming the system query service

Consuming the system metadata service

Consuming an existing document service

Creating a document service

Consuming a document service

Using an enhanced document service

Creating a custom service

Consuming a custom service

Consuming an external service

Improving Development Efficiency


Creating an editor template

Modifying the Tools menu

Modifying the right-click context menu

Searching for an object in a development project

Modifying the Personalization form

Modifying the application version

Improving Dynamics AX Performance


Calculating code execution time

Writing efficient SQL statements

Caching a display method

Using Dynamics AX Trace Parser

Using SQL Server Database Engine Tuning Advisor