Dynamics AX 2012 R2: Key Office 365 scenarios

Dynamics AX 2012 R2 has a number of new and improved Office Interop capabilities. They enable a number of key scenarios for Office 365 that I wanted to list here. If you have other scenarios that you’d like to highlight or other scenarios that we don’t currently support, please mention them in the comments below….


Dynamics AX 2012 R2: Improved Office Interop capabilities

Dynamics AX 2012 R2 has been out for a while now, but I realized that I hadn’t posted updated information about its Office Interop capabilities here. In Dynamics AX 2012 R2 we responded to feedback from our customers and partners to provide new and updated support in a number of areas. Highlights for R2 Document…


Dynamics AX: Copy+Paste vs Export to Excel

I had a question from a customer recently: “On a Details Form, copy+paste gives me more fields than Export to Excel, so why would I use Export to Excel?”. Below was my answer… Copy+paste will give you values for all the visible form fields from the current datasource.Export to Excel will initially give you values…


Dynamics AX: Turning off specific tasks

Recently I had a someone ask me how to turn off or disable the Export to Excel task. Unfortunately, like most tasks, it can’t be disabled via the options dialog like the Document handling subsystem can be (Tools/Options/General/Miscellaneous/Document handling active). In the AX2012 client, the task keyboard shortcuts like Ctrl+T don’t go through the buttons, so disabling the Export…


Can Dynamics AX 2012 work with Office 365?

Office 365 provides secure anywhere access to Microsoft Office capabilities including document collaboration. Users can create, store, and edit Office documents online in Office 365. SharePoint Online can be thought of as the storage mechanism for Office 365 documents. Document Generation and Office 365 If Word and Excel documents generated by Dynamics AX 2012 are…

1

Dynamics AX 2012 Office Add-ins and Office 2007

One of the more common Office Add-ins questions I get asked is “Why don’t the Office Add-ins work with Office 2007?” They do, but you need a hotfix or service pack 3. Bill Thompson explains in more detail in his post: Dynamics AX 2012 Office Add-ins and Office 2007


Dynamics AX 2012 Excel Add-in: Timeout issues?

I’ve heard from a few people having problems with size limitations when publishing from the Dynamics AX 2012 Excel Add-in to the server. People that are receiving a message like “Method ‘System.ServiceModel.CommunicationObjectFaultedException.Detail’ not found” are probably running into a timeout on the service call made from the Excel Add-in to the server. This problem would…

1

Dynamics AX 2012 Office Add-ins: Information sources

The Office Add-ins for Dynamics AX 2012 are a great tool for working with Dynamics AX data. The Word Add-in primarily enables document generation and the Excel Add-in enables a number of scenarios involving Dynamics AX data including refreshable data exports, adhoc reporting, document generation, data manipulation, and data import. I recently became the guy…