Book Image

Extending Microsoft Dynamics AX 2012 Cookbook

By : Murray Fife
Book Image

Extending Microsoft Dynamics AX 2012 Cookbook

By: Murray Fife

Overview of this book

Dynamics AX is built on a number of foundation products from Microsoft that are used to make it bigger, better, and stronger than the average business system. Taking advantage of these products will make your life easier. Use these tools to maximize the efficiency of your business management, taking advantage of a powerful and centralized tool set. "Extending Microsoft Dynamics AX 2012 Cookbook" will show you how to use tools that you already have to extend out Dynamics AX and discover potential new directions. You will be surprised at what you can do on a shoestring budget. The book will allow you to streamline your work processes, and use the system's powerful and centralised features to the advantage of your organization. "Extending Microsoft Dynamics AX 2012 Cookbook" will show you how to maximize the potential of Dynamics AX with common and popular tools to enhance your business management systems. We will begin by exploring how to extend Dynamics AX out with SharePoint. After this, the book will guide you through important elements in maximizing business management efficiency, focusing on key aspects like reports, dashboards, and workflows. The book will then finish by teaching you how to customize your management systems, achieving a comprehensive coverage of the most important extension processes relevant to you and your business with very little programming. This is a book for those of you that want to make the most out of Dynamics AX by using what you already have, and without breaking the bank.
Table of Contents (18 chapters)
Extending Microsoft Dynamics AX 2012 Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Building InfoPath lookups using OData queries


A feature of InfoPath that makes forms even more useful is the ability to allow fields to be populated with dynamic data coming from static lists, databases, and also web data sources, so that users do not have to remember field values such as part codes and customer numbers. Since you are able to query Dynamics AX data through web queries, we can use these queries to create dynamic lookups in our forms.

In this recipe, we will show how you can turn text fields into drop-down lists that use OData queries as a data source.

How to do it...

To use an OData query as a data source for a field, follow these steps:

  1. We need to first define the data source. To do this, select the From XML File option in the From Other Sources menu in the Get External Data group of the Data ribbon bar in the form designer.

  2. When the Data Connection Wizard pops up, paste the URL for the OData query that you want to use as a data source and click on Next.

  3. To store the data source...