You are previewing Microsoft Dynamics AX 2012 R3 Development Cookbook.
O'Reilly logo
Microsoft Dynamics AX 2012 R3 Development Cookbook

Book Description

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

In Detail

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.

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

  • Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

    Table of Contents

    1. Microsoft Dynamics AX 2012 R3 Development Cookbook
      1. Table of Contents
      2. Microsoft Dynamics AX 2012 R3 Development Cookbook
      3. Credits
      4. About the Author
      5. About the Reviewers
      6. www.PacktPub.com
        1. Support files, eBooks, discount offers, and more
          1. Why subscribe?
          2. Free access for Packt account holders
          3. Instant updates on new Packt books
      7. Preface
        1. What this book covers
          1. Exceptions and considerations
        2. What you need for this book
        3. Who this book is for
        4. Sections
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        5. Conventions
        6. Reader feedback
        7. Customer support
          1. Downloading the example code
          2. Downloading the color images of this book
          3. Errata
          4. Piracy
          5. Questions
      8. 1. Processing Data
        1. Introduction
        2. Creating a new number sequence
          1. How to do it...
          2. How it works...
          3. See also
        3. Renaming the primary key
          1. How to do it...
          2. How it works...
        4. Merging two records
          1. How to do it...
          2. How it works...
        5. Adding a document handling note
          1. Getting ready
          2. How to do it...
          3. How it works...
        6. Using a normal table as a temporary table
          1. How to do it...
          2. How it works...
        7. Copying a record
          1. How to do it...
          2. How it works...
          3. There's more...
        8. Building a query object
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Using the OR operator
          4. See also
        9. Using a macro in a SQL statement
          1. How to do it...
          2. How it works...
        10. Executing a direct SQL statement
          1. How to do it...
          2. How it works...
          3. There's more...
        11. Enhancing the data consistency check
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        12. Exporting data to an XML file
          1. How to do it...
          2. How it works...
        13. Importing data from an XML file
          1. How to do it...
          2. How it works...
        14. Creating a comma-separated value file
          1. How to do it...
          2. How it works...
          3. There's more...
        15. Reading a comma-separated value file
          1. How to do it...
          2. How it works...
          3. There's more...
        16. Using the date effectiveness feature
          1. How to do it...
          2. How it works...
          3. There's more...
      9. 2. Working with Forms
        1. Introduction
        2. Creating dialogs using the RunBase framework
          1. How to do it...
          2. How it works...
          3. See also
        3. Handling a dialog event
          1. How to do it...
          2. How it works...
          3. There's more...
          4. See also
        4. Building a dynamic form
          1. How to do it...
          2. How it works...
        5. Adding a form splitter
          1. How to do it...
          2. How it works...
        6. Creating a modal form
          1. How to do it...
          2. How it works...
          3. There's more...
          4. See also
        7. Modifying multiple forms dynamically
          1. How to do it...
          2. How it works...
        8. Storing user selections
          1. How to do it...
          2. How it works...
        9. Using a Tree control
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Performance
            2. Drag and drop
          4. See also
        10. Building a checklist
          1. How to do it...
          2. How it works...
          3. There's more...
        11. Adding the View details link
          1. How to do it...
          2. How it works...
      10. 3. Working with Data in Forms
        1. Introduction
        2. Using a number sequence handler
          1. How to do it...
          2. How it works...
          3. See also
        3. Creating a custom filter control
          1. How to do it...
          2. How it works...
          3. See also
        4. Creating a custom instant search filter
          1. How to do it...
          2. How it works...
          3. See also
        5. Building a selected/available list
          1. How to do it...
          2. How it works...
          3. There's more...
        6. Preloading images
          1. How to do it...
          2. How it works...
          3. There's more...
          4. See also
        7. Creating a wizard
          1. How to do it...
          2. How it works...
        8. Processing multiple records
          1. How to do it...
          2. How it works...
        9. Coloring records
          1. How to do it...
          2. How it works...
          3. See also
        10. Adding an image to records
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Displaying an image as part of a form
            2. Saving a stored image as a file
      11. 4. Building Lookups
        1. Introduction
        2. Creating an automatic lookup
          1. How to do it...
          2. How it works...
          3. There's more...
        3. Creating a lookup dynamically
          1. How to do it...
          2. How it works...
        4. Using a form to build a lookup
          1. How to do it...
          2. How it works...
          3. See also
        5. Building a tree lookup
          1. How to do it...
          2. How it works...
          3. See also
        6. Displaying a list of custom options
          1. How to do it...
          2. How it works...
          3. There's more...
        7. Displaying custom options in another way
          1. How to do it...
          2. How it works...
          3. There's more...
        8. Building a lookup based on the record description
          1. How to do it...
          2. How it works...
          3. There's more...
        9. Building the browse for folder lookup
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Manual folder browsing lookup
            2. Adding a Make New Folder button
        10. Building a lookup to select a file
          1. How to do it...
          2. How it works...
          3. There's more...
        11. Creating a color picker lookup
          1. How to do it...
          2. How it works...
          3. There's more...
      12. 5. Processing Business Tasks
        1. Introduction
        2. Using a segmented entry control
          1. How to do it...
          2. How it works...
          3. There's more...
          4. See also
        3. Creating a general journal
          1. How to do it...
          2. How it works...
          3. There's more
          4. See also
        4. Posting a general journal
          1. How to do it...
          2. How it works...
          3. See also
        5. Processing a project journal
          1. How to do it...
          2. How it works...
          3. There's more...
        6. Creating and posting a ledger voucher
          1. How to do it...
          2. How it works...
          3. See also
        7. Changing an automatic transaction text
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        8. Creating a purchase order
          1. How to do it...
          2. How it works...
        9. Posting a purchase order
          1. How to do it...
          2. How it works...
          3. There's more...
        10. Creating a sales order
          1. How to do it...
          2. How it works...
        11. Posting a sales order
          1. How to do it...
          2. How it works...
          3. There's more...
        12. Creating an electronic payment format
          1. How to do it...
          2. How it works...
      13. 6. Integration with Microsoft Office
        1. Introduction
        2. Creating an Excel file
          1. How to do it...
          2. How it works...
        3. Reading an Excel file
          1. How to do it...
          2. How it works...
        4. Creating a Word document from a template
          1. Getting ready
          2. How to do it...
          3. How it works...
        5. Creating a Word document with repeating elements
          1. Getting ready
          2. How to do it...
          3. How it works...
        6. Creating a Microsoft Project file
          1. Getting ready
          2. How to do it...
          3. How it works...
        7. Sending an e-mail using Outlook
          1. Getting ready
          2. How to do it...
          3. How it works...
      14. 7. Using Services
        1. Introduction
        2. Consuming the system query service
          1. Getting ready
          2. How to do it...
          3. How it works...
        3. Consuming the system metadata service
          1. How to do it...
          2. How it works...
        4. Consuming an existing document service
          1. How to do it...
          2. How it works...
          3. There's more...
        5. Creating a document service
          1. How to do it...
          2. How it works...
        6. Consuming a document service
          1. How to do it...
          2. How it works...
          3. See also
        7. Using an enhanced document service
          1. How to do it...
          2. How it works...
          3. See also
        8. Creating a custom service
          1. How to do it...
          2. How it works...
          3. See also
        9. Consuming a custom service
          1. How to do it...
          2. How it works...
          3. See also
        10. Consuming an external service
          1. How to do it...
          2. How it works...
          3. See also
      15. 8. Improving Development Efficiency
        1. Introduction
        2. Creating a code editor template
          1. How to do it...
          2. How it works...
        3. Modifying the Tools menu
          1. How to do it...
          2. How it works...
        4. Modifying the right-click context menu
          1. How to do it...
          2. How it works...
        5. Searching for an object in a development project
          1. How to do it...
          2. How it works...
          3. See also
        6. Modifying the Personalization form
          1. How to do it...
          2. How it works...
        7. Modifying the About Microsoft Dynamics AX dialog
          1. How to do it...
          2. How it works...
      16. 9. Improving Dynamics AX Performance
        1. Introduction
        2. Calculating code execution time
          1. How to do it...
          2. How it works...
          3. There's more...
        3. Writing efficient SQL statements
          1. How to do it...
          2. How it works...
        4. Caching a display method
          1. How to do it...
          2. How it works...
        5. Using Dynamics AX Trace Parser
          1. How to do it...
          2. How it works...
          3. See also
        6. Using SQL Server Database Engine Tuning Advisor
          1. How to do it...
          2. How it works...
          3. See also
      17. Index