Dynamics AX 2012 Excel Add-in - Add Data

Dynamics AX 2012 Excel Add-in – Add Data

Purpose: The purpose of this document is to illustrate how to enable AIF Web Service for Dynamics AX 2012 Excel Add-in.

Task: In order to enable AIF Web Service for Dynamics AX 2012 Excel Add-in 2 main prerequisites have to be met: AIF Web Service has to be deployed as a part of Service Group and AIF Web Service has to be added to Document Data Sources. This document describes the sequence of steps on how to enable existing (standard) or brand-new (custom) AIF Web Service for Dynamics AX 2012 Excel Add-in.

Data Model:

Table Name	Table Description
AlexTable	Sample table

Data Model Diagram:

Sample Data Model

Walkthrough:

Existing (standard) AIF Web Service

In this demonstration I will enable existing VendVendTableService (Vendor) AIF Web Service for Dynamics AX 2012 Excel Add-in

At the beginning VendVendTableService AIF Web Service is not available in Excel Add-in

In order to deploy VendVendTableService AIF Web Service I will add it to AccountsPayableServices Service Group which is currently not deployed

I added VendVendTableService AIF Web Service to AccountsPayableService Service Group in AOT and then deployed Service Group

After Service Group is deployed you will see the following infolog

Now Service Group will be activated in Inbound ports form in Administration > Setup > AIF

Please note that you can see WSDL in Web Browser as shown below

Finally VendVendTableService AIF Web Service has to be added to Document Data Sources form

Result:

VendVendTableService AIF Web Service is now available in Excel Add-in

Brand-new (custom) AIF Web Service

In this demonstration I will create custom AlexQueryService AIF Web Service

Project

Create Document Service

Welcome

Select document parameters

Select code generation parameters

Generate code

Completed

AxdAlexQuery Project

Generate incremental CIL

AIF Web Service

Add AIF Web Service to Service Group

Deploy Service Group

After Service Group is deployed you will see the following infolog

AlexServiceGroup will now be activated in Inbound ports form

Also you can see WSDL in Web Browser

Finally you will have to add AIF Web Service in Document data sources form

Result:

AlexQueryService AIF Web Service is now available in Excel Add-in

Summary: In order to enable AIF Web Service for Dynamics AX 2012 Excel Add-in 2 main prerequisites have to be met: AIF Web Service has to be deployed as a part of Service Group from AOT or from Inbound ports form in Administration > Setup > AIF and AIF Web Service has to be added to Document Data Sources on Document data sources form in Organization administration > Setup > Document management. You can add your AIF Web Service to newly created custom Service Group for deployment, or you can add your AIF Web Service to existing Service Group and redeploy it.

Author: Alex Anikiev, PhD, MCP

Tags: Dynamics ERP, Dynamics AX 2012, Excel, Dynamics AX 2012 Excel Add-in, Data Import, Data Conversion, Data Migration, Application Integration Framework, Web Service, Add Data.

Note: This document is intended for information purposes only, presented as it is with no warranties from the author. This document may be updated with more content to better outline the concepts and describe the examples.