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 where there are many groups or process flow should be [...]
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 the three locations below#!/bin/sh## Event handler script for restarting IIS [...]
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 on the table. All WorksheetHeader, WorksheetLine, and Transaction tables will be [...]
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 security key.static void grantSafetyAccess(Args _args){ #Admin SecurityKeySet securitySet; ; setPrefix(funcName()); [...]
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 is a good start, but it cannot get us the [...]
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 about the procedure conceptually, technically, and differences between AX 4.0 [...]
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 happens after running estimation incorrectly. Run this job and 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 a production order ("Batch order"). Every other month we encounter [...]
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 journal line with the issueClick Inquiries > Marked for settlementThis [...]
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 an export to CSV (Excel) with a dialog asking for [...]
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 yourself answering a dozen questions to answer just the one [...]
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 [...]