Full Database Cleanup Routine, Part 3
Jul22

Full Database Cleanup Routine, Part 3

Submitted by Nathan Clouse on 07/21/20. In part 2, we talk how to collect some data and shrink our database. Here are the results. After part 2, here are the numbers, with charts, to show how different areas of the system were affected. As a refresher, here are the companies we will be looking at: AAA – All buy, make, sell, and retail sale operations in one legal entity with WMS… Continue Reading Nathan Clouse’s...

Read More
Full Database Cleanup Routine, Part 2
Jul20

Full Database Cleanup Routine, Part 2

Submitted by Nathan Clouse on 07/19/20. In part 1, we talk about the process of cleaning. Now we’re going to do it. In part 1 of this series, we talk about how to clean up your database. Now, we’re going to run that process and record the changes as they occur and evaluate what those changes mean. We’ll still be sticking with weight lifting puns here and there.  What We’ll Be Measuring… Continue Reading...

Read More
Staging and Git
Jun29

Staging and Git

Submitted by Nathan Clouse on 06/29/20. Tags:  Git ALM A simple gotcha when woring with Git Evaldas Landauskas asked a question on some missing code when using Git so I thought I’d walk through a common “gotcha” when using Git, if you’ve not had this issue before. First, we’re going to start with this repo: 

Read More
Refresher On Database Upgrade Scripts for D365 F&O
Jun05

Refresher On Database Upgrade Scripts for D365 F&O

Submitted by Nathan Clouse on 06/04/20. Tags:  Upgrade Database Sample database upgrade scripts with use cases. Database upgrade scripts from AX 2012 to D365 F&O have changed a little when you compare them to AX 2009 to AX 2012 upgrade scripts. We’re going to cover a few use cases and script samples for how to perform… Continue Reading Nathan Clouse’s Article on their blog Refresher On Database Upgrade...

Read More
Moving from TFVC to Git in AZDO
Jun03

Moving from TFVC to Git in AZDO

Submitted by Nathan Clouse on 06/02/20. Tags:  TFVC TFS Git Moving from TFVC to GIT in Azure DevOps is easy! I have some TFVC code repo in Azure DevOps that I would like to move to use Git. We’re going to walk through the process of moving code from TFVC to Git on a single dev machine.  First,… Continue Reading Nathan Clouse’s Article on their blog Moving from TFVC to Git in AZDO Moving from TFVC to GIT in Azure...

Read More
Full Database Cleanup Routine, Part 1
May13

Full Database Cleanup Routine, Part 1

Submitted by Nathan Clouse on 05/12/20. Over time your database size can grow quite large, depending on you use AX / Finance and Operations. Let’s talk about trimming down. Some of you may not know that I enjoy weight lifting in my spare time. I’m not especially good at it but its still a hobby I enjoy. I thought it would be fun to talk about our AX / F&O databases like they are a body… Continue Reading Nathan...

Read More
Batch Job History Clean up
Apr28

Batch Job History Clean up

Submitted by Nathan Clouse on 04/27/20. Clean up after your batch jobs! There is now standard functionality in Dynamics 365 for Finance and Supply Chain to clean up Batch Job History entries created from batch jobs. In AX 2012, you had to write something custom to handle this. There are two different jobs available to help clean up your Batch History table. To see your Batch Job history,… Continue Reading Nathan Clouse’s...

Read More
Notification Cleanup
Apr28

Notification Cleanup

Submitted by Nathan Clouse on 04/27/20. Clean up your Event Alerts / System Notifications. AX 2012 and Dynamics 365 for Finance and Supply Chain allows you to create alert rules for lots of different actions in the system. This could be for if a new customer is created, a sales order status advances to invoiced or some field is set to a specific value. These create records for end users… Continue Reading Nathan Clouse’s...

Read More
Work User Session Log Cleanup
Mar03

Work User Session Log Cleanup

Submitted by Nathan Clouse on 03/02/20. Clean up your warehouse user session log!   Just like Work Creation history purge and Containerization history purge, your warehouse user session log needs to be cleaned up every once and a while for the same reasons.  AX 2012 In Warehouse Management > Periodic > Cleanup, look for work user session log cleanup. This will ask you to number of… Continue Reading Nathan Clouse’s...

Read More
Mobile Device Activity Log Cleanup
Mar03

Mobile Device Activity Log Cleanup

Submitted by Nathan Clouse on 03/02/20. Clean up the mobile device activity log!   The Mobile device activity log (WHSMobileDeviceActivityLog) table contains a log of activity for mobile devices like production order start operations, driver check ins and outs, and removing LPs. There is functionality to clean up entries in this table. AX 2012 In Warehouse Management > Periodic >… Continue Reading Nathan Clouse’s...

Read More
Create LCS Hosted Build VM
Dec03

Create LCS Hosted Build VM

Create LCS Hosted Build VM 12/02/19 ALM Build Let’s walk through creating a standard Build VM Before we can get started, we must have the following complete: Create a generic servicing account for environment creation like DynamicsServicing@Contoso.com Add the generic servicing account to Azure DevOps (AZDO) Generate a… Continue Reading Nathan Clouse’s Article on their blog Create LCS Hosted Build VM Let’s walk...

Read More
Create Cloud Hosted Build VM
Dec02

Create Cloud Hosted Build VM

Create Cloud Hosted Build VM 12/01/19 Need an extra build box? Look no further for how to set that up. If you need an extra build box, those are easy to setup as a cloud-hosted VM. To get started, you’ll need to have performed the following: Create a generic servicing account for environment creation like DynamicsServicing@Contoso.com Add the generic servicing account to Azure DevOps… Continue Reading Nathan Clouse’s...

Read More
Warehouse Dimension Link Setup Overview
Jul25

Warehouse Dimension Link Setup Overview

Learn more about this community mod that allows you to create a warehouse financial dimension, associate it with an inventory warehouse and have the financial dimension from the inventory warehouse default onto all transactions using that warehouse.   You can get the code, a model or deployable package here: https://github.com/NathanClouseAX/AAXWarehouseDimensionLink Submitted by Nathan… Continue Reading Nathan Clouse’s...

Read More
Developer Managed Azure VMs To Save Money
Oct27

Developer Managed Azure VMs To Save Money

Developer Managed Azure VMs To Save Money10/27/18 VM Can developers manage their VM uptime and save some money? Yes! Similar to OMS, each VM in Azure has an option to add a shutdown time. This is especially helpful for developer VMs. The schedule for this is set at each VM so if you have developers in different time zones, you can manage that… Continue Reading Nathan Clouse’s Article on their...

Read More
Use Azure OMS to Reduce Azure Spend
Oct27

Use Azure OMS to Reduce Azure Spend

Azure OMS has some great features to help reduce spend but you have to set it up. We’re going to go through how to schedule a specific VM to be available for service during specific hours. This is great for environments like a TEST or TRAIN instance that we only want to be on during waking hours. Let’s get started. OMS interacts with resource groups so if you want to schedule a specific VM… Continue Reading Nathan...

Read More
7.3 On Prem Deployment With Deployable Package Failure
Jul25

7.3 On Prem Deployment With Deployable Package Failure

EDIT: This is a known issue that MSFT is actively working on addressing EDIT 2: This has been addressed by KB 4461011. If you are an on-prem customer that is attempting to upgrade to 7.3 from 7.2, you may run into an error. The full error is pasted below: 07/23/2018 21:43:05: Microsoft.Dynamics.AX.Metadata.Storage.MetadataReadMissingFileException: The static metadata file… Continue Reading Nathan Clouse’s Article on their...

Read More
Powershell To Install ADFS for D365 FFO On Prem
Jul25

Powershell To Install ADFS for D365 FFO On Prem

Setting up ADFS for D365 On Prem? Easy!  Setting up ADFS for D365 on Prem is now a little easier (hopefully). Below is a script that can be used to configure ADFS for D365. It is assumed that the this is running from the ADFS box from inside the InfrastructureScript folder as a domain adminst in an elevated powershell.   Step 1 Simply run this as is # Run the following PowerShell script on… Continue Reading Nathan Clouse’s...

Read More
Tool Kit User for AX 2012 R3 for Retail
Jul11

Tool Kit User for AX 2012 R3 for Retail

Tool Kit User for AX 2012 R3 for Retail07/11/17 2012 toolkit SQL AX 2012 Retail Setting up a Tool Kit User for AX 2012 R3 for Retail can be a bit trying, espcially since the techNet article for this topic is based on 2012 FP and is no longer current…. Continue Reading Nathan Clouse’s Article on their...

Read More
Fixed Assets Balance by Asset
Oct25

Fixed Assets Balance by Asset

Fixed Assets Balance by AssetSubmitted by Nathan Clouse on 10/25/16.Fixed Assets Balance by Asset to today. This can be modified to get a balance at a point in time by replacing getDate() with a particular date. AX Version:  AX 2012 R3 Module:  Fixed Assets CREATE VIEW… Continue Reading Nathan Clouse’s Article on their blog

Read More
Job to Bulk Assign Organization Security
Sep13

Job to Bulk Assign Organization Security

Assume you have one company already live on AX and things are well with them. Now you are bringing a second company online and adding them into the same environment as the first company. You will want to assign everyone from company 1 to only be allowed to see stuff for company 1; same with company 2. Below is a job that will bifurcate security by domain for each company. We have Users in… Continue Reading Nathan Clouse’s...

Read More
AX 2012 Database Log Cleanup Automation
Aug28

AX 2012 Database Log Cleanup Automation

The database log is a great tool to capture and troubleshoot odd or unexpected behaviors in AX. Depending on what and how much you log, there is a lot of helpful info that can be stored for review later. However, if you are collecting info, you either need someone to clean up data you no longer want or need or just let it sit and take up space which could slow down finding meaningful info on… Continue Reading Nathan...

Read More
AX 2012 AIF and Batch Cleanup Automation
Aug27

AX 2012 AIF and Batch Cleanup Automation

AX 2012 AIF and Batch Cleanup Automation08/27/15 Code Cleanup 2012 AIF and Batch Cleanup AutomationLogging for the AIF and Batch system is a great tool to identify what is going on and when things go wrong. Sometimes the errors could be a little more descriptive but all in all still useful. However,… Continue Reading Nathan Clouse’s Article on their...

Read More
AX 2012 Enum Dictionary For Reporting
Aug09

AX 2012 Enum Dictionary For Reporting

I have run into several instances where I would like an easy way in SQL to convert an enum into its label equivalent. Converting some stuff by hand just to get meaningful data can be tedious; LedgerTransType is a good example. So, I created this simple solution. The attached project allows you to dump out to a table, called AAX_EnumDictionary, all of your enums so you can join then in on a… Continue Reading Nathan Clouse’s...

Read More