Dynamics AX 2012 Data Import using Excel Add-in

Dynamics AX 2012 Excel Add-in - Issues and Solutions (Method UpdateRecIdVisibility not found)

2013-04-24T19:11:00Z

Dynamics AX 2012 Excel Add-in – Issues and Solutions (Method not found: ‘Void Microsoft.Dynamics.AX.Framework.OfficeAddin.DataSourceContainer.UpdateRecIdVisibility(Boolean)) Purpose: The purpose of this document is to outline some issues you may encounter when using Dynamics AX 2012 Excel Add-in for import of data and provide solutions to resolve them. Issue : ‘Method not found: ‘Void Microsoft.Dynamics.AX.Framework.OfficeAddin.DataSourceContainer.UpdateRecIdVisibility(Boolean...(read more)

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Business Logic)

2012-10-22T07:28:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Business Logic) Purpose: The purpose of this document is to provide answers to frequently asked questions related to Microsoft Dynamics AX 2012 Excel Add-in. Question : How can I execute additional business logic using Microsoft Dynamics AX 2012 Excel Add-in? Answer : Microsoft Dynamics AX 2012 Excel Add-in uses AIF Web Services for publishing the data into Microsoft Dynamics AX 2012. In order to automate certain processes or execute...(read more)

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Validation Logic)

2012-10-22T04:52:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Validation Logic) Purpose: The purpose of this document is to provide answers to frequently asked questions related to Microsoft Dynamics AX 2012 Excel Add-in. Question : How does Microsoft Dynamics AX 2012 Excel Add-in implement Validation Logic? Answer: The way the system implements Validation logic in Excel Add-in varies depending on AIF proxy classes implementation for particular business entities. In this document to illustrate...(read more)

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Related Records)

2012-10-21T09:45:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Related Records) Purpose: The purpose of this document is to provide answers to frequently asked questions related to Microsoft Dynamics AX 2012 Excel Add-in. Question : How does Microsoft Dynamics AX 2012 Excel Add-in deal with Related Records? Answer : The way the system implements Related records logic in Excel Add-in varies depending on AIF proxy classes implementation for particular business entities. In this document to illustrate...(read more)

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Depending Fields)

2012-10-21T06:35:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Depending Fields) Purpose: The purpose of this document is to provide answers to frequently asked questions related to Microsoft Dynamics AX 2012 Excel Add-in. Question : How does Microsoft Dynamics AX 2012 Excel Add-in deal with Dependent fields? Answer : The way the system implements Depending fields logic in Excel Add-in varies depending on AIF proxy classes implementation for particular business entities. In this document to illustrate...(read more)

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Defaulting Logic)

2012-10-20T22:43:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Defaulting Logic) Purpose: The purpose of this document is to provide answers to frequently asked questions related to Microsoft Dynamics AX 2012 Excel Add-in. Question : How does Microsoft Dynamics AX 2012 Excel Add-in implement defaulting logic? Answer : The way the system implements defaulting logic in Excel Add-in varies depending on AIF proxy classes implementation for particular business entities. In this document to illustrate...(read more)

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Number Sequences)

2012-10-20T08:08:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Questions and Answers (Number Sequences) Purpose: The purpose of this document is to provide answers to frequently asked questions related to Microsoft Dynamics AX 2012 Excel Add-in. Question : How do I work with Number Sequences in Microsoft Dynamics AX 2012 Excel Add-in? Answer : The way you work with Number Sequences in Excel Add-in varies depending on data model properties for Number Sequence controlled fields and AIF proxy classes implementation for...(read more)

Dynamics AX 2012 Excel Add-in – Issues and Solutions (Timeout issues)

2012-08-17T05:40:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Issues and Solutions (Timeout issues) Purpose: The purpose of this document is to outline some issues you may encounter when using Dynamics AX 2012 Excel Add-in for import of data and provide solutions to resolve them. Issue : 'Method 'System.ServiceModel.CommunicationObjectFaultException.Detail' not found'. Issue : 'The request channel timed out attempting to send after 00:10:00. Increase the timeout value passed to the call to Request...(read more)

Dynamics AX 2012 Excel Add-in – Issues and Solutions (Index was outside the bounds of the array)

2012-05-24T05:27:00Z

Dynamics AX 2012 Excel Add-in – Issues and Solutions (Index was outside the bounds of the array) Purpose: The purpose of this document is to outline some issues you may encounter when using Dynamics AX 2012 Excel Add-in for import of data and provide solutions to resolve them. Issue: 'Index was outside the bounds of the array'. Reason: This issue occurs because some mandatory fields are not specified for particular business entity. As the result validation of request XML will fail and exception...(read more)

Dynamics AX 2012 Excel Add-in – Issues and Solutions (Cannot have 0 columns)

2012-05-02T02:07:00Z

Dynamics AX 2012 Excel Add-in – Issues and Solutions (Cannot have 0 columns) Purpose: The purpose of this document is to outline some issues you may encounter when using Dynamics AX 2012 Excel Add-in for import of data and provide solutions to resolve them. Issue: 'Cannot have 0 columns'. Reason: This issue occurs because some tables in Microsoft Dynamics AX 2012 don't have any fields for specific functional purpose or for the purposes of table inheritance just being another logical level...(read more)

Dynamics AX 2012 Excel Add-in - Tracking Dimensions

2012-02-23T15:24:00Z

Dynamics AX 2012 Excel Add-in – Tracking Dimensions Purpose: The purpose of this document is to illustrate how to work with Tracking Dimensions in Dynamics AX 2012 Excel Add-in. Challenge : Data model changes in Dynamics AX related to high normalization and introduction of surrogate keys made import of data more complex. Additionally there are number of differences between Excel and AX Rich Client from UI standpoint when it comes to handling Inventory dimensions. AX Rich Client is obviously more...(read more)

Dynamics AX 2012 Excel Add-in - Vendor transactions import

2012-02-14T07:22:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Vendor transactions Import Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of vendor transactions with required level of detail. Challenge : Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. In fact the data model forming General Journal was not dramatically changed and import principle remains the same...(read more)

Dynamics AX 2012 Excel Add-in - Customer transactions import

2012-02-13T05:33:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Customer transactions Import Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of customer transactions with required level of detail. Challenge : Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. In fact the data model forming General Journal was not dramatically changed and import principle remains the...(read more)

Dynamics AX 2012 Excel Add-in - Storage Dimensions

2012-02-09T02:48:00Z

Dynamics AX 2012 Excel Add-in - Storage Dimensions Purpose: The purpose of this document is to illustrate how to work with Storage Dimensions in Dynamics AX 2012 Excel Add-in. Challenge : Data model changes in Dynamics AX related to high normalization and introduction of surrogate keys made import of data more complex. Additionally there are number of differences between Excel and AX Rich Client from UI standpoint when it comes to handling Inventory dimensions. AX Rich Client is obviously more dynamic...(read more)

Dynamics AX 2012 Excel Add-in - Add Data

2012-02-01T06:37:00Z

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...(read more)

Dynamics AX 2012 Sales Agreements Import using Excel Add-in

2012-01-30T07:03:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Sales agreements Import Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of sales agreements. Challenge : Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. Moreover Sales Blanket orders functionality was completely redesigned and in Microsoft Dynamics AX 2012 it’s called Sales Agreements now. Solution...(read more)

Dynamics AX 2012 Purchase Agreements Import using Excel Add-in

2012-01-30T07:02:00Z

Microsoft Dynamics AX 2012 Excel Add-in – Purchase agreements Import Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of purchase agreements. Challenge : Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. Moreover Purchase Blanket orders functionality was completely redesigned and in Microsoft Dynamics AX 2012 it’s called Purchase Agreements now...(read more)

Dynamics AX 2012 Excel Add-in - Replacement Keys

2012-01-27T06:14:00Z

Dynamics AX 2012 Excel Add-in – Replacement Keys Purpose: The purpose of this document is to illustrate options how to change Dynamics AX 2012 Data Model by adding appropriate Replacement keys to make Excel Add-in working to import the data. Challenge : Data model changes in Dynamics AX related to high normalization and introduction of surrogate keys made import of data more complex. Currently Excel Add-in has a number of limitations as it relates to the Data Model. In order to allow Excel Add-in...(read more)

Dynamics AX 2012 Excel Add-in - Issues and Solutions

2012-01-25T03:32:00Z

Dynamics AX 2012 Excel Add-in – Issues and Solutions Purpose: The purpose of this document is to outline some issues you may encounter when using Dynamics AX 2012 Excel Add-in for import of data and provide solutions to resolve them. Issue : “This operation is not supported for a relative URI”. Reason: This issue occurs because AppFabric Service Bus endpoint is not configured. AppFabric Service Bus endpoints are similar to WCF endpoints. The only difference is that specific binding are used to communicate...(read more)

Dynamics AX 2012 Data Import using Excel Add-in

2012-01-17T18:57:00Z

Dynamics AX 2012 Excel Add-in – Data Import Purpose: The purpose of this document is to illustrate how to use Dynamics AX 2012 Excel Add-in for import of data. Challenge : Data model changes in Dynamics AX related to high normalization and introduction of surrogate keys made import of data more complex. Additionally there are number of differences between Excel and AX Rich Client from UI standpoint when it comes to defaulting logic, use of number sequences, segmented controls and complex UI logic...(read more)

Dynamics AX 2012 Purchase orders Import using Excel Add-in

2012-01-17T16:07:00Z

Dynamics AX 2012 E xcel Add-in – Purchase orders Import Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of purchase orders. Challenge : Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. In fact the data model forming Purchase Orders was not dramatically changed and import principle remains the same – populate the header and related lines. However...(read more)

Dynamics AX 2012 Free text invoices Import using Excel Add-in

2012-01-17T16:07:00Z

Dynamics AX 2012 E xcel Add-in – Free text invoices Import Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of free text invoices. Challenge : Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. The data model forming Free text invoices was not dramatically changed and import principle remains the same – populate the header and related lines. In...(read more)

Dynamics AX 2012 Sales orders Import using Excel Add-in

2012-01-17T16:06:00Z

Dynamics AX 2012 E xcel Add-in – Sales orders Import Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of sales orders. Challenge : Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. In fact the data model forming Sales Orders was not dramatically changed and import principle remains the same – populate the header and related lines. However some...(read more)

Dynamics AX 2012 Inventory transactions/on-hand Import using Excel Add-in

2012-01-17T16:06:00Z

Dynamics AX 2012 E xcel Add-in – Inventory transactions/on-hand Import Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of inventory transactions (on-hand). Challenge : Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. In fact the data model forming Inventory Journal was not dramatically changed and import principle remains the same – populate...(read more)

Dynamics AX 2012 Ledger transactions/balances Import using Excel Add-in

2012-01-17T16:05:00Z

Dynamics AX 2012 E xcel Add-in – Ledger transactions/balances Import Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of ledger transactions. Challenge : Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex. In fact the data model forming General Journal was not dramatically changed and import principle remains the same – populate the journal and...(read more)