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…
Tag: Excel
Microsoft Dynamics Ax
Dynamics AX 2012 Excel Add-in – Vendor transactions import
by Bo Jensen •
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…
Microsoft Dynamics Ax
Dynamics AX 2012 Data Import using Excel Add-in: Dynamics AX 2012 Excel Add-in – Customer transactions import
by Bo Jensen •
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…
Microsoft Dynamics Ax
Dynamics AX 2012 Data Import using Excel Add-in: Dynamics AX 2012 Excel Add-in – Storage Dimensions
by Bo Jensen •
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…
Microsoft Dynamics Ax
Dynamics: Import Data into AX from excel file
by Bo Jensen •
Import Data into AX from excel file
Microsoft Dynamics Ax
Export to Excel with X++ code ~ IT Pro Ramblings
by Bo Jensen •
Every user of Microsoft Dynamics AX knows the possibility and the ease-of-use to copy-paste data from a Dynamics AX grid to a Microsoft Excel worksheet. However, as Dynamics AX developer, you can achieve the same through X++ code, with a lot of more possibilities. In this post, I show an example of such an export…
Microsoft Dynamics Ax
X++ code to Read/Write Dynamics Ax data to excel
by Bo Jensen •
Here are some bits of X++ code to read and write AX data from Excel
Microsoft Dynamics Ax
Dynamics AX: AX 2012 – Excel Add-in Revisited
by Bo Jensen •
With the release of Microsoft Dynamics AX 2012, came some great new ways of achieving business requirements, and user experiences. One of those is the Excel Add-in for Microsoft Dynamics AX 2012.
Microsoft Dynamics Ax
Dynamics AX: Microsoft Dynamics AX 2012 Excel Add-in
by Bo Jensen •
With the release of Microsoft Dynamics AX 2012, the lines between the Rich Client, the Portal as well as Microsoft Office are going to be blurred. This is out-of-the-box ability, that replaces a lot of older ways for doing things. One such topic, is the old Microsoft Excel Export / Import Wizard for Microsoft Dynamics…
Microsoft Dynamics Ax
Reading Excel worksheets in Dynamics AX using CCADOConnection, CCADOCommand & CCADORecordSet classes
by Bo Jensen •
Reading Excel worksheets in Dynamics AX using CCADOConnection, CCADOCommand & CCADORecordSet classes ~ Zubair’s Microsoft Dynamics AX blog
Microsoft Dynamics Ax
How to create an Excel file in X++
by Bo Jensen •
Create a new Job in AOT and write the code shown below:
Webdevelopment
Export datagrid to Excel in asp.net (Revised) – Asp.Net, C#, SQL Blog
by Bo Jensen •
Export datagrid to Excel in asp.net (Revised) – Asp.Net, C#, SQL Blog