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. [...]
AX 2012 Demo VM on Parallels (OSx)
So I've got this iMac in my office with 24 GB of RAM so naturally, what am I doing with all that? Well, I have hobbies and test my Linux scripts, firewalls, and even some CTF challenges within there. Dynamics [...]
Showing Bible Verse when PowerShell is Opened
Using the code created in a previous post in our PowerShell profile, we can have PowerShell display a random Bible quote whenever it is opened.StepsDownload PSBible-NET.psm1 from Github.Place the file in %UserProfile%DocumentsWindowsPowerShellModules. You may need to create the folders if they [...]
Search the Internet for Bible References on a Topic
Scraping a Web Site for Bible ReferencesUsing the function from the prior post, we can leverage PowerShell to download a web page and parse it for us to find references to scripture.$requestResult = Invoke-WebRequest-Uri "https://blogs.lcms.org/2018/loving-your-internet-neighbor"-DisableKeepAlive -UseBasicParsing-ErrorAction SilentlyContinueif ($requestResult.StatusCode -eq200){ Get-BibleReferences$requestResult.Content [...]
Find Bible Verses using PowerShell
Using regular expressions and PowerShell we can create some code which will parse a Bible verse and then these values can be used in other ways. In the function below I've used the .NET RegEx class to read Bible verses, [...]
Allow WEMO Communication through your Firewall
The following instructions will enable your WEMO devices to communicate through your firewall without Upnp enabled. Disabling Upnp is a best practice because otherwise any device inside your network would be able to open up any port to the outside [...]
Create a VM network in Parallels with a Linux VM Firewall
Parallels Desktop has been a solid virtualization option for my iMac. It enables easy sharing of folders and other advanced options I felt would be useful, i.e. seamless Windows programs. For my latest adventure I wanted to test out some [...]
Comparing BOMs in AX
Bills of material in AX 2012 can be effective dated, and this provides the ability to keep prior versions. Now it has been several years and the question arises- what changed between versions? There is a built-in way to compare [...]
Outlook Setup Wizard – Dynamics 365 for Finance and Operations
In Microsoft Dynamics 365 for Finance and Operations, you may want to connect your Office365 email to receive contacts, tasks, and appointments from the ERP. To do so, navigate to Organization Administration > Setup > Office integration > Microsoft Outlook [...]
Unable to Configure Report for PrecisionForms – Record Already Exists
Symptom:Cannot create a record in Delivery destinations (BT_DPA_AOT_ReportDestinations). AOT object ID: 13, 2.The record already exists.Solution:The unique index for the BottomLine tables is RecID. Run the following SQL statement on your AX database. Replace DATABASE with the name of your AX database.IF [...]
Export AX Ledger Transactions via SQL
This SQL serves as a starting point to include any number of financial dimensions.SELECT GENERALJOURNALENTRY.SUBLEDGERVOUCHER as Voucher, DIMENSIONATTRIBUTEVALUECOMBINATION.DisplayValue as [Account+Dims], MAINACCOUNT.MainAccountID as [Account], DIMENSIONATTRIBUTELEVELVALUE.DisplayValue as [Dept], GENERALJOURNALACCOUNTENTRY.ACCOUNTINGCURRENCYAMOUNT as AmountMST, GENERALJOURNALACCOUNTENTRY.TRANSACTIONCURRENCYAMOUNT as AmountCur, GENERALJOURNALACCOUNTENTRY.TRANSACTIONCURRENCYCODE as CurrencyCodeFROM DynamicsAX2012.GENERALJOURNALENTRYINNER JOIN DynamicsAX2012.GENERALJOURNALACCOUNTENTRY ON GENERALJOURNALENTRY.RECID [...]
Unable to deploy AX2012 Azure Virtual Machine
There is a AX 2012 virtual machine available on the Azure Portal. When I tried to create one, I received the following error (with typo):Project was created but there were problems creating deployment instance. You need to be a service [...]
Finding invalid document handling references
static void listDocuHandling_InvalidPaths(Args _args){ DocuRef docuRef; DocuValue docuValue; SysOperationProgress progress; Common common; ; setPrefix("Invalid document handling file references"); // Initialize progress indicator select count(RecId) from docuRef; progress = new SysOperationProgress(1, true); progress.setTotal(docuRef.RecId); progress.setCaption(funcname()); while select docuRef join docuValue where docuValue.RecId [...]
Work item could not be created. Insufficient rights for user
There are 60 workflows available within AX and it can be frustrating to try and set up specific security for each one. The following message is no exception (pun).SymptomStopped (error): X++ Exception: Work item could not be created. Insufficient rights [...]
Test Data Transfer Tool – Object reference error
The Test Data Transfer Tool can be invaluable in copying data from one environment to another for testing. Sometimes you may want to export the data against a restored copy of an environment, either due to security, or to limit [...]
List AOSs Supported by SQL Server Instance
I recently found myself in the situation of needing to know what Dynamics AX Application Object Servers (AOS) are online in an environment. The situation was a bit simplified because all of the AOS were served by the same SQL [...]