Excel rounding and comparing to AX
I was working on something for a customer related to the contribution ratio in AX that I’ll cover in a later post. While I was working on that I decided I’d […]
Tag Archives: Excel
Using the filter button in the Excel add-in.
In a previous post we had a look at adding a new record into Dynamics AX. When you are working with data you can filter the records in Excel or […]
Add a new record from the Excel add-in for the new Dynamics AX
In a previous post we had a look at the new Excel add-in. This has always been a great tool for getting data in and out of Dynamics AX. With […]
Export to Excel vs Open in Excel in the new Dynamics AX.
If you are starting to work with the new Dynamics AX there are some nice updates to the Excel integration. You still have the basic export to excel download which is […]
Create new spreadsheet for price discount journal maintenance
In a previous post I walked through the basic actions of using the edit in Excel for the price discount agreement journals. As I mentioned there I had to create […]
Edit Price Discount Agreement journals in Excel
In previous post I did a quick overview of how to setup the service so you can use the Edit in Excel capability of the price discount agreement journals. In […]
Price Discount Agreement journals edit in Excel Setup
There is a handy feature when you do a lot of editing of price discount agreement journals and you want to be able to use the flexibility of Excel. When […]
Excel Add-In security difference between Add Tables and Add Data
This question often comes up in projects once people start using the Excel Add-In with Dynamics AX 2012 and working through security. There are two functions from the Add-In to […]
Export to Excel
Export to Excel is a ubiquitous feature you can find on any form in AX. While some forms have a button that is usually on the main tab of a ribbon on a […]
AIF setup and use in Excel Add-in
There are a couple of ways to leverage the Excel Add-in with AX one using the tables as just a data source another using a prepared service. This allows you […]
