Microsoft Dynamics AX 2012 Development Cookbook

Microsoft Dynamics AX 2012 Development Cookbook

By : Mindaugas Pocius

Buy this Book

Microsoft Dynamics AX 2012 Development Cookbook

By: Mindaugas Pocius

Buy this Book

Overview of this book

Microsoft Dynamics AX is a comprehensive Enterprise Resource Planning (ERP) solution for mid-size and large organizations. Dynamics AX implementations are used worldwide by thousands of customers. With the new version - Dynamics AX 2012 - the system is due to expand even more rapidly. Every new implementation requires some level of customization, and all organizations want this to be done to the highest standards using proven approaches. Written by one of the leading experts in Microsoft Dynamics AX, 'Microsoft Dynamics AX 2012 Development Cookbook' is packed with over 80 task-based and immediately reusable recipes that will help you manage your company's or customer's ERP information and operations efficiently, and solve your business process problems in an effective and quick way. This book focuses on commonly used custom modifications in major Dynamics AX modules. The recipes in this book cover various areas of Dynamics AX to help developers not only learn about programming, but also about the functional side of Dynamics AX. The practical recipes will also allow you to look at the development from the perspective of business processes. You will learn to enhance your user interface using various Dynamics AX UI elements and managing your data and functions will become easier.

Microsoft Dynamics AX 2012 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 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

Introduction

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

Introduction

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

Introduction

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

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

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

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Using a normal table as a temporary table

Standard Dynamics AX contains numerous temporary tables, which are used by the application and could be used in custom modifications too. Although new temporary tables can also be easily created using the AOT, sometimes it is not effective. One of the cases could be when the temporary table is very similar or exactly the same as an existing one. The goal of this recipe is to demonstrate an approach for using standard non-temporary tables to hold temporary data.

As an example, we will use the vendor table to insert and display a couple of temporary records without affecting the actual data.

How to do it...

Carry out the following steps in order to complete this recipe:

1. In the AOT, create a new class named VendTableTmp with the following code:

class VendTableTmp
{
}
server static void main(Args _args)
{
VendTable vendTable;
vendTable.setTmp();
vendTable.AccountNum = '1000';
vendTable.Blocked = CustVendorBlocked::No;
vendTable.Party = 1;
vendTable.doInsert();
vendTable.clear();
vendTable.AccountNum = '1002';
vendTable.Blocked = CustVendorBlocked::All;
vendTable.Party = 2;
vendTable.doInsert();
while select vendTable
{
info(strFmt(
"%1 - %2",
vendTable.AccountNum,
vendTable.Blocked));
}
}

2. Run the class and check the results:

How it works...

The key method in this recipe is in the setTmp() method. It is available on all tables, and it declares the current table instance to behave as a temporary table in the current scope. So in this recipe, we will first call the setTmp() method on the vendTable table to make it temporary in the scope of this method. That means any data manipulations will be lost once the execution of this method is over and actual table content will not be affected.

Next, we will insert a couple of test records. Here, we use the doInsert() method to bypass any additional logic, which normally resides in the table's insert() method.

The last thing to do is to check for newly created records by listing the vendTable table. We can see that although the table contains many actual records, only the ones which we inserted were displayed in the Infolog. Additionally, the two we inserted do not appear in the actual table records.

Microsoft Dynamics AX 2012 Development Cookbook

By : Mindaugas Pocius

Microsoft Dynamics AX 2012 Development Cookbook

By: Mindaugas Pocius

Overview of this book

Related Content you might be interested in

Current Title:

Microsoft Dynamics AX 2012 Development Cookbook

Using a normal table as a temporary table

How to do it...

How it works...