Microsoft Dynamics AX 2012 R3 Development Cookbook

Over 80 effective recipes to help you solve real-world Microsoft Dynamics AX development problems

Microsoft Dynamics AX 2012 R3 Development Cookbook

This ebook is included in a Mapt subscription
Mindaugas Pocius

Over 80 effective recipes to help you solve real-world Microsoft Dynamics AX development problems
$0.00
$24.00
$59.99
$29.99p/m after trial
RRP $47.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 4,000+ eBooks & Videos
  • 40+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781785281693
Paperback388 pages

Book Description

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.

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.

Table of Contents

Chapter 1: 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
Chapter 2: 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
Chapter 3: 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
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: 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
Chapter 9: 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

What You Will Learn

  • Explore data manipulation concepts in Dynamics AX
  • Build scripts to assist data migration processes
  • Organize data in Dynamics AX forms
  • Make custom lookups using AOT forms and dynamically generate them from the X++ code
  • Create a custom electronic payment format and process a vendor payment using it
  • Integrate your application with Microsoft Office Suite and with external systems using various approaches
  • Export and import business data for further distribution or analysis
  • Improve your development efficiency and experience

Authors

Table of Contents

Chapter 1: 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
Chapter 2: 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
Chapter 3: 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
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: 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
Chapter 9: 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

Book Details

ISBN 139781785281693
Paperback388 pages
Read More

Read More Reviews