The Ultimate AX 2012 Table and Field ID Fix for Synchronization Errors
It is very frustrating to have a table ID conflict which causes AX to drop a table with data that is needed. As anyone with AX 2012 experience will tell you, these things can be a major pain, even with [...]
SysOperation Framework – Six years later where are we at with implementing it?
It has been six years since the SysOperation framework was made available for development in Dynamics AX 2012. The SysOperation framework replaced the RunBase Framework. It promised to run faster by limiting which code runs on each tier of the [...]
Defragment indexes on D365 Finance & Operations Virtual Machine
After downloading the Dynamics 365 for Finance and Operations 8.1 PU 20 VHD from LCS, I went about optimizing its performance. So far I used it a bit without doing a full compile and it seems to run less than [...]
Parse the Missing Values from Validate (DIXF)
I like to validate the data as much as possible throughout the process of migrating data into AX. Usually this means reviewing the input file, loading the file, and clicking "Validate all" before actually running the data into the target [...]
Latency Testing for Dynamics 365 for Finance and Operations
Recently I went on a journey testing the latency of the Azure dark fiber backbone between data centers. This is crucial for a global Dynamics 365 Finance and Operations ("FinOps") implementation. In general bandwidth can be purchased but latency is [...]
Debug AIF Document Service within AX
Sometimes it is a pain to create a .NET application and attach a debugger to the AOS service just to diagnose a problem with an AIF service. It is possible to do all debugging inside of AX. This example is [...]
Validate AX DLL Versions on Multiple Machines
List the versions for all DLLs which will load in AX using the Get-AxDllVersions. Download the PowerShell script. Run this script against all machines running the AX client (RDP/Citrix/end-user) and servers. This is useful to confirm that all DLLs deployed match in [...]
Unable to Enable Warehouse Management II License Key
In AX 2012 R3 CU12, after disabling Trade > Warehouse and Transportation Management the Warehouse Management II license cannot be enabled in License information.“You can not add this license code because the following required license codes have not been entered: [...]
Unreserve inventory
// Unreserves inventory static void unreserveInventTrans(Args _args) { InventTrans inventTrans; InventDim inventDim; InventDimParm inventDimParm; ; setPrefix(funcName()); select firstOnly inventTrans where inventTrans.StatusIssue == StatusIssue::ReservPhysical join inventDim where inventDim.inventDimId == inventTrans.inventDimId && inventDim.inventBatchId == "M0139812"; if (inventTrans.RecID) { setPrefix(inventTrans.caption()); [...]
Data Migration: Combining 105 Excel Files in 3 Minutes
I needed to import multiple Excel files into AX; all of them had a very similar format with the same columns. Python to the rescue. Ever since Build 2018 I've been using Visual Studio Code and enjoyed every moment of [...]
The Product variants form can only be opened for a product master
When right-clicking > View Details on a Variant number you may receive the following message "The Product variants form can only be opened for a product master."Call Stack Data DictionaryTablesEcoResProductMasterMethodsgetProductMasterFromCaller 34 ClassesEcoResProductVariantsCompanyHelpernewFromFormRun 18 ClassesEcoResProductVariantsFormHelpernewFromFormRun [...]
Generating Random Numbers and Dates (AX 2012)
The Random class creates random integer values. Although the range of an int (32 bit) is: [-2,147,483,647 : 2,147,483,647], Random.nextInt() generates values from 0 to 32,767, which is an unsigned 16-bit integer. Let's run the Random class to validate the [...]
pfSense Firewall Error 501
When setting up a new pfSense firewall via the web interface, if you change the ip address and/or device name while connected you may receive the following error: Error: 501 Description: An HTTP_REFERER was detected other than what is defined [...]
Logoff Disconnected Remote Desktop Sessions using PowerShell
AX 2012 users continue to appear active in AX although they have disconnected from their RDP session. You can manually open Task Manager on each RDP server and logoff users who have disconnected. Alternatively, save the following commands as a [...]
Installing Active Directory Part 2 – Dynamics 365 for Finance and Operations On-Premise at Home – 05
In the prior post we created the primary domain controller. In this article we will configure Active Directory and add a second domain controller.In a later post we'll set up ADFS and Azure Active Directory (AAD)- both of which are [...]
Installing Active Directory Part 1 – Dynamics 365 for Finance and Operations On-Premise at Home – 04
One of the 'shared service' environment requirements for Dynamics 365 for Finance and Operations is an Active Directory domain. There should never be just one Active Directory server, so we'll create two Windows Server 2016 virtual machines. AX needs an [...]