After getting many requests for lists, reports, exports I wrote a quick add-in script to give me a template for jobs.  With a little code you can add another template to the IDE which will allow you to easily write [...]

We all know that AX never came with enough Security reports.  Security is complex in AX, if someone asks a functional question, "Who has access to view fixed assets?" I've found it is not as simple as looking...instead you find [...]

There is a very easy way to get a list of AOT objects using Microsoft Dynamics AX 4.0 without having to write a job iterating over project nodes.Tools > Development tools > Application objects > Application objectsThis form has a [...]

AX seems to create parameters either when the data area is created or when the parameter's form is opened.  So what happens when the parameter table has no form and AX has not created the record...or maybe you had some [...]

Ever wondered how to lookup a table ID using a SQL statement or how tableid2str works?  The hidden table SQLDICTIONARY has the field and table numbers from the shown in the AOT.  It also includes the size and type of the columns.For the [...]

After making so many environment copies I like to think I have it down to a science. I have a program which runs SQL scripts from a directory. Here are a few things that I do:Disable all usersClear the user [...]

While doing a routine upgrade of a third-party add-on for Dynamics AX 4.0 I got the following error:User '____' is not authorized to insert a record in table 'SYSSETUPLOG'. Request denied.The SysSetupLog table, labeled "Installation information," stores application and kernel [...]