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 [...]
Attaching an iSCSI LUN to Windows Server 2016 – Dynamics 365 for Finance and Operations On-Premise at Home – 03
Regardless of the NAS device you may be using, the following steps can attach iSCSI storage to your server for VM storage. These are the steps I took: Attach an iSCSI LUN to Windows Server 2016 1. Log into the [...]
Setting up iSCSI with Synology – Dynamics 365 for Finance and Operations On-Premise at Home – 02
Previous Post: Windows and Hyper-V Installation - Dynamics 365 for Finance and Operations On-Premise at Home - 01To support the number of VMs and possible environments I want to host I will be leveraging a network attached storage (NAS) device to [...]
Windows and Hyper-V Installation – Dynamics 365 for Finance and Operations On-Premise at Home – 01
Previous Post: Setting up Dynamics 365 for Finance and Operations- on-premise...at home!Setting up the ServerThe server arrived, it is time to get rolling! I first jumped into the BIOS. It is easier and better to configure things before the operating system [...]
Setting up Dynamics 365 for Finance and Operations- on-premise…at home!
In order to build some of the automation tools and test configurations I set down the path of purchasing a server. There are many servers available with decent specifications, still under warranty, and with good performance. The better deals are [...]
Converting Toodledo Tasks to Nozbe
Over the past ten years I have loved the Pocket Informant system of Getting Things Done (GTD) with Toodledo as the back end. However, I found Nozbe - yes they've been around this whole time! I wish I had known [...]
AX 2012 Database Synchronization Warnings and Errors
After making a change to the data dictionary AX will synchronize to the SQL database. If you have turned off configuration keys the window which pops up shows many warnings, most of which can be ignored every time. How do [...]
Performance Tweaks for AX2012 Demo VM
Open the VM Profile Manager within the VM, and change the default profile to "AX2012Minimum."Look at VM profile to see what order it starts and stops things. Take note and disable anything you do not plan on using.Enable SQL Trace [...]
Who is online for all AX databases on current SQL server?
In the situation where you must support more than one AX environment with the same SQL Server, maintenance can become tricky unless you know who is online. The following SQL Script will list all of the users who are online. [...]