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: 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…


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…