Dynamics AX allows you to track the traditional contact details such as phone, fax, url, and email, but what if you want to also track social media accounts like Twitter. Although you could reuse one of the existing electronic contact types, it would be much better if you could have a dedicated contact type just for Twitter so that you can segregate out the data for reporting and analysis.
In this worked example I will show you how you can easily add a new contact type to Dynamics AX for Twitter, and also any other Social Media type that you may want to track. Read More
I was tipped off about a new add-on for Excel 2013 that Microsoft have just released called Power Query, so I had to take a look at it. As the name hints, this is the data query function on steroids, and it looks great.
The following walkthrough is an example of what I did. Read More
At this point in my GuygAX project (a.k.a. implementing Dungeons & Dragons within ERP), I have been configuring all of my merchants and customers. Doing this by hand would take forever, so I decided to use the Excel Add-In make the loading of the records a little easier.
This process is not quite as simple as loading a table, because all of the contact information is initially stored within the Global Address book, and the tables that you update are slightly different depending on if you are creating an organization, or a person, but once we got the hang of it, importing became a breeze.
In this walkthrough I will show how to use the Excel Add-In for Dynamics AX to create a template that you can use to easily import customer and vendor records. Read More