Microsoft Dynamics AX 2012 R3 Development Cookbook

Microsoft Dynamics AX 2012 R3 Development Cookbook

By : Mindaugas Pocius

Buy this Book

Microsoft Dynamics AX 2012 R3 Development Cookbook

By: Mindaugas Pocius

Buy this Book

Overview of this book

<p>Microsoft Dynamics AX 2012 R3 Development Cookbook will help you manage your company's or customer's ERP information and operations efficiently. Beginning with exploring data manipulation concepts in Dynamics AX, you will build scripts to assist data migration and organize data in AX forms. You will learn how to create custom lookups using AOT forms and generate them dynamically. After this, you'll learn how to enhance your application by using advanced form controls, and integrate your system with other external systems. You will also learn how to enhance your user interface using various Dynamics AX UI elements.</p> <p>This book will help you look at application development from a business process perspective, and develop enhanced ERP solutions by learning and implementing the best practices and techniques.</p>

Microsoft Dynamics AX 2012 R3 Development Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Processing Data

Introduction

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 a 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

Introduction

Creating dialogs using the RunBase framework

Handling a dialog event

Building a dynamic form

Adding a form splitter

Creating a modal form

Modifying multiple forms dynamically

Storing user selections

Using a Tree control

Building a checklist

Adding the View details link

Working with Data in Forms

Introduction

Using a number sequence handler

Creating a custom filter control

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

Introduction

Creating an automatic lookup

Creating a lookup dynamically

Using a form to build a lookup

Building a tree lookup

Displaying a list of custom options

Displaying custom options in another way

Building a lookup based on the record description

Building the browse for folder lookup

Building a lookup to select a file

Creating a color picker lookup

Processing Business Tasks

Introduction

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

Introduction

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

Using Services

Introduction

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

Introduction

Creating a code 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 About Microsoft Dynamics AX dialog

Improving Dynamics AX Performance

Introduction

Calculating code execution time

Writing efficient SQL statements

Caching a display method

Using Dynamics AX Trace Parser

Using SQL Server Database Engine Tuning Advisor

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Creating a Word document from a template

Microsoft Office Word allows presenting Dynamics AX data in a variety of formats.Using Word templates makes things even more easier. The newly introduced Microsoft Office add-ins also provide a user friendly way to do this.

If add-ins have not been installed, Dynamics AX still allows you to create Word documents from the code. Although there are no Dynamics AX application classes for Word as we have for Excel, Word documents can still be created using a very similar approach by calling the COM components directly. The only inconvenience is that IntelliSense in the code editor will not provide method suggestions. However, the methods and their parameters can be easily looked up in the online MSDN library.

In this recipe, we will create a simple Word document from a template. We will use the COM component model to read a Word template and fill it in with data from the system.

Getting ready

Before we start with the code, we have to create a new Word template...

Microsoft Dynamics AX 2012 R3 Development Cookbook

By : Mindaugas Pocius

Microsoft Dynamics AX 2012 R3 Development Cookbook

By: Mindaugas Pocius

Overview of this book

Related Content you might be interested in

Current Title:

Microsoft Dynamics AX 2012 R3 Development Cookbook

Creating a Word document from a template

Getting ready