Modifying tab order
In AX to change tab order normally you change the order of the controls in the form. You can set the "Skip" property on a control to Yes and when the user tabs it will skip that control. Certain forms [...]
Nagios: Automatically restart IIS after a CRITICAL alert
You can execute code when a service or host changes state. These are called event handlers.Go to the Windows server and create a local userCreate the following script called iisreset.sh in your Nagios plugins directory replacing the username and password in [...]
Deleting all transactions in a company
Sometimes when creating a new playground for testing you need to delete all transactions in a company. There is a nice utility included in AX for this purpose. The SysDatabaseTransDelete class will delete all tables by checking the TableGroup property [...]
How to modify the permissions of the Admin group
After creating a new security key you will need to modify the permissions of the Admin group, but the User group permissions form does not allow it. This small AX job will grant the Admin group permissions to the new [...]
Reports being used
I was asked recently which reports were being run by users so that some of the menus could be simplified. This SQL will list users and the AX report name for every report that has been run by anyone. It [...]
Inventory Closing and Adjustment
After writing a report which shows inventory transaction cost as of a specific date we had a small issue where very occasionally certain transactions were showing double cost. After some poking around I found this post:http://fedotenko.info/?page_id=31The developer goes into depth [...]
Physical remaining quantity and total quantity must have the same sign
When posting a production report as finished journal you may receive this error,Physical remaining quantity and total quantity must have the same sign.It is because the remaining quantity on the production order is incorrect.The quantity should never be negative. I think it [...]
You can’t have unallocated cost on a planning item
When using the functionality provided by Process Manufacturing by ToIncrease occasionally we get the following error when running inventory close and adjustments.You can't have unallocated cost on a planning itemThe error always occurs when it is trying to pass an adjustment through [...]
Offset voucher does not exist in account ____.
When posting a ledger journal you may receive:Whenever open accounts payable or receivable transactions are selected a corresponding record in SpecTrans is created, which just holds the ledger journal line record ID and the open transaction record ID.Open the ledger journalSelect the ledger [...]
Writing Quick Jobs/Exports
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 [...]
Security Rights
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]