Archive

Monthly Archives: December 2012

Retrieving and Publishing a Budget Through Excel

By
December 31, 2012
Dynamics AX
Leave a comment
The Excel add-in for Dynamics AX is a great tool for getting data from AX into Excel for reporting and analysis. But if you set up your document services the right way then it becomes more useful by allowing you to publish data back into AX directly from the Excel spreadsheet.

A while ago I came across a blog post by Becky Newell on Importing a Budget via the Excel Add-in and thought that it would be a good exercise to recreate her example, and get it working for myself. Read More
Advertisement

Robert Greene has a new book

By
December 28, 2012
Book Club
Leave a comment

I love almost all of Robert Greene’s books – the one that he write with 50 cent, not so much. The way that he explains everything through historical figures and analogies are great. So when I saw that he had a new book out the other week as I was browsing at B&N, I grabbed a copy right away, and am now avidly reading it. Maybe some of you all out there will do that same. Read More

Creating & Consuming Web Services with Excel

By
December 28, 2012
Dynamics AX, Excel, Office Interoperability, SharePoint
1 Comment
There are a whole slew of web services available in Dynamics AX 2012, but how do you use them?In this example we will show how you can publish the web services so that you can use them in an application, and also show an example of the web services in action by using them to create a simple sales order import routine from Excel. Read More

Book Club – ERP Pulp Fiction

By
December 28, 2012
Book Club
Leave a comment

This week’s book club suggestion will set you back $0.99, is a whopping 6 pages long which will probably take you about 3 minutes to read (if you read as slow as I do), and it’s also written about Great Plains. I think that it also creates a new book category of ERP Pulp Fiction by showcasing all of the Microsoft technologies though a quick and trashy novel full of secret agents, spy missions, and accountants. Read More

Dissecting Dynamics AX Role Centers

By
December 27, 2012
Dynamics AX
Leave a comment

Wouldn’t it be nice to come into work in the morning, open up Dynamics AX, and see everything that you could possibly want to see in one place? It may seem like a pipe dream, but not really. Dynamics AX has a feature called the Role Center that will do this and more for you, without even breaking a sweat.

In this walkthrough we will give you an overview of the Role Centers, how you can tweak the standard ones that come out of the box, and also how you can add additional features that may make your life a little easier. Read More