Determine table ID in SQL
Create this function to easily get the table number within a SQL statement.-- =============================================-- Create [...]
Change default layers when comparing code
During the integration of system patches or third-party layers I found it annoying to continually [...]
Convert Axapta Time in SQL
AX 4.0 stores time in the database using the seconds since midnight. So in order [...]
Disable users who are not active in Active Directory
Occasionally when auditors come by I like to disable all user accounts in AX which [...]
Line ###-Offset voucher does not exist in account ______.
If a vendor transaction is reversed but an AP check has been printed (and the [...]
Get the next unique file name
Sometimes you are saving a temporary file so you don't want to delete or overwrite [...]
Show the call stack in the infolog
info(con2str(xSession:: xppCallStack(), 'rn'));
Rename items quickly
Here is a little script to rename items quickly. Just provide a CSV file with [...]
Modifying tab order
In AX to change tab order normally you change the order of the controls in [...]
Nagios: Automatically restart IIS after a CRITICAL alert
You can execute code when a service or host changes state. These are called event [...]