Book Image

Microsoft Dynamics AX 2012 Development Cookbook

By : Mindaugas Pocius
Book Image

Microsoft Dynamics AX 2012 Development Cookbook

By: Mindaugas Pocius

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.
Table of Contents (15 chapters)
Microsoft Dynamics AX 2012 Development Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

Creating a lookup dynamically


Automatic lookups, mentioned in the previous recipe, are widely used across the system, and are very useful in simple scenarios. When it comes to showing different fields from different data sources, applying various static or dynamic filters, or similar, some coding is required. Dynamics AX is flexible enough that the developer can create custom lookups, either using AOT forms, or by running them dynamically from the X++ code.

This recipe will show how to dynamically build a runtime lookup from the code. In this demonstration, we will modify the Vendor account lookup on the Customers form to allow users to select only those vendors that use the same currency as the currently selected customer.

How to do it...

  1. 1. Open the VendTable table in the AOT, and create a new method:

    public static void lookupVendorByCurrency(
    FormControl _callingControl,
    CurrencyCode _currency)
    {
    Query query;
    QueryBuildDataSource qbds;
    QueryBuildRange qbr;
    SysTableLookup lookup;
    query...