List AOT Objects
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 dump of everything...it is essentially the UtilElements "table" that the cross [...]
Parameters – When are those records created?
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 ambitious person delete the parameter records from the table? The [...]
Table & Field Numbers – SQLDICTIONARY
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 anal retentive you can update data in this table to [...]
Copying AX Environments
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 login historyClear the pending outgoing emailsRemove all alertsDelete batchesChange paths [...]
User is not authorized to insert a record in table SYSSETUPLOG
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 version information as well as the status of the System [...]