Microsoft Dynamics AX 2012 Development Cookbook -- Table of Contents -- Microsoft Dynamics AX 2012 Development Cookbook -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Processing Data -- Introduction -- Creating a new number sequence -- How to do it... -- How it works... -- See also -- Renaming the primary key -- How to do it... -- How it works... -- Merging two records -- How to do it... -- How it works... -- Adding a document handling note -- How to do it... -- How it works... -- Using a normal table as a temporary table -- How to do it... -- How it works... -- Copying a record -- How to do it... -- How it works... -- There's more... -- Building a query object -- How to do it... -- How it works... -- There's more... -- Using the OR operator -- Using arrays fields -- See also -- Using a macro in an SQL statement -- How to do it... -- How it works... -- Executing a direct SQL statement -- How to do it... -- How it works... -- There's more... -- Enhancing the data consistency check -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exporting data to an XML file -- How to do it... -- How it works... -- Importing data from an XML file -- How to do it... -- How it works... -- Creating a comma-separated value file -- How to do it... -- How it works... -- There's more... -- Reading a comma-separated value file -- How to do it... -- How it works... -- There's more... -- Using the date effectiveness feature -- How to do it... -- How it works...

There's more... -- 2. Working with Forms -- Introduction -- Creating a dialog -- How to do it... -- How it works... -- See also -- Handling a dialog event -- How to do it... -- How it works... -- There's more... -- See also -- Building a dynamic form -- How to do it... -- How it works... -- Adding a form splitter -- How to do it... -- How it works... -- Creating a modal form -- How to do it... -- How it works... -- There's more... -- See also -- Modifying multiple forms dynamically -- How to do it... -- How it works... -- Storing last form values -- How to do it... -- How it works... -- Using a tree control -- How to do it... -- How it works... -- There's more... -- Performance -- Drag-and-drop -- See also -- Building a checklist -- How to do it... -- How it works... -- There's more... -- Adding the View details link -- How to do it... -- How it works... -- 3. Working with Data in Forms -- Introduction -- Using a number sequence handler -- How to do it... -- How it works... -- See also -- Creating a custom filter -- How to do it... -- How it works... -- See also -- Creating a custom instant search filter -- How to do it... -- How it works... -- See also -- Building a selected/available list -- How to do it... -- How it works... -- There's more... -- Preloading images -- How to do it... -- How it works... -- There's more... -- See also -- Creating a wizard -- How to do it... -- How it works... -- Processing multiple records -- How to do it... -- How it works... -- Coloring records -- How to do it... -- How it works... -- Adding an image to records -- How to do it... -- How it works... -- There's more... -- Displaying an image as part of a form -- Saving a stored image as a file -- 4. Building Lookups -- Introduction -- Creating an automatic lookup -- How to do it... -- How it works... -- There's more... -- Creating a lookup dynamically.

How to do it... -- How it works... -- Using a form for building a lookup -- How to do it... -- How it works... -- See also -- Building a tree lookup -- How to do it... -- How it works... -- See also -- Displaying a list of custom options -- How to do it... -- How it works... -- There's more... -- Another way of displaying custom options -- How to do it... -- How it works... -- There's more... -- Building a lookup based on record description -- How to do it... -- How it works... -- There's more... -- Building the Browse for Folder lookup -- How to do it... -- How it works... -- There's more... -- Manual folder browsing lookup -- Adding a Make New Folder button -- Building a lookup for selecting a file -- How to do it... -- How it works... -- There's more... -- Creating a color picker lookup -- How to do it... -- How it works... -- There's more... -- 5. Processing Business Tasks -- Introduction -- Using a segmented entry control -- How to do it... -- How it works... -- There's more... -- See also -- Creating a general journal -- How to do it... -- How it works... -- There's more -- See also -- Posting a general journal -- How to do it... -- How it works... -- See also -- Processing a project journal -- How to do it... -- How it works... -- There's more... -- Creating and posting a ledger voucher -- How to do it... -- How it works... -- See also -- Changing an automatic transaction text -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a purchase order -- How to do it... -- How it works... -- See also -- Posting a purchase order -- How to do it... -- How it works... -- There's more... -- Creating a sales order -- How to do it... -- How it works... -- See also -- Posting a sales order -- How to do it... -- How it works... -- There's more... -- Creating an electronic payment format -- How to do it... -- How it works...

6. Integration with Microsoft Office -- Introduction -- Creating an Excel file -- How to do it... -- How it works... -- Reading an Excel file -- How to do it... -- How it works... -- Creating a Word document from a template -- Getting ready -- How to do it... -- How it works... -- Creating a Word document with repeating elements -- Getting ready -- How to do it... -- How it works... -- Creating a Microsoft Project file -- Getting ready -- How to do it... -- How it works... -- Sending an e-mail using Outlook -- Getting ready -- How to do it... -- How it works... -- 7. Using Services -- Introduction -- Consuming the system query service -- How to do it... -- How it works... -- Consuming the system metadata service -- How to do it... -- How it works... -- Consuming an existing document service -- How to do it... -- How it works... -- There's more -- Creating a document service -- How to do it... -- How it works... -- Consuming a document service -- How to do it... -- How it works... -- See also -- Using an enhanced document service -- How to do it... -- How it works... -- See also -- Creating a custom service -- How to do it... -- How it works... -- See also -- Consuming a custom service -- How to do it... -- How it works... -- See also -- Consuming an external service -- How to do it... -- How it works... -- See also -- 8. Improving Development Efficiency -- Introduction -- Creating an editor template -- How to do it... -- How it works... -- Modifying the Tools menu -- How to do it... -- How it works... -- Modifying the right-click context menu -- How to do it... -- How it works... -- Searching for an object in a development project -- How to do it... -- How it works... -- See also -- Modifying the Personalization form -- How to do it... -- How it works... -- Modifying the application version -- How to do it... -- How it works...

9. Improving Dynamics AX Performance -- Introduction -- Calculating code execution time -- How to do it... -- How it works... -- There's more... -- Writing efficient SQL statements -- How to do it... -- How it works... -- Caching a display method -- How to do it... -- How it works... -- Using Dynamics AX Trace Parser -- How to do it... -- How it works... -- See also -- Using SQL Server Database Engine Tuning Advisor -- How to do it... -- How it works... -- See also -- Index.