Import an ISV licese file into Dev environment using Power Shell

 K:\AOSService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe --setupmode importlicensefile --metadatadir K:\aosservice\PackagesLocalDirectory --bindir K:\aosservice\PackagesLocalDirectory --sqlserver . --sqldatabase axdb --sqluser axdbadmin --sqlpwd *** --licensefilename "C:\Temp\A.txt"

Apply an ISV package on a Dev environment

 1. Upload the compressed package to LCS > Asset Library > Software deployable package

 2. Go to Dev environment > Maintain > Apply updates > select the package

3. After the update complete, open VS > Source Control Explorer > expand the dev branch > Metadata > choose the isv package folder > you can see the editted files

4. Click on "Add to Source Control" button to add newly created items (if any) > select both Bin & Resources folder 

5. 

6. Check in pending changes

7. Merge to other branches (if any)

Debug in a Tier-2 (UAT) environment

 From time to time, you may have to debug a copy of the production database, but you are unable to export & import the DB to your dev machine, for example: the DB's size is too large, or it's an urgent issue, or the customer doesn't allow to export their Prod DB... Then you have to debug directly in the UAT environment. 

There is an article from Microsoft that describes briefly about this here, but there is no screenshot and the information isn't detailed enough, so the purpose of this post is to guide you step by step to achive this :)

1. Find your ip address at https://nordvpn.com/what-is-my-ip/ and note it down  

2. Enable just-in-time database access

Go to LCS > Select the Tier 2 environment > Maintain > Enable access

Add your IP address in step 1: click on + button, then enter your IP as below: 

Click "Confirm" button at the bottom and then you can see a new record is added with your IP info.

Then under the Manage Environment, choose "Performance tuning for AX (write to AX)" as the "Reason for access" and write some descriptions and then click on "Request Access"

After that, refresh the page and you will see the login details under the Database Accounts

3. Change web.config in your DEV environment

In your DEV environment, backup the original web.config file at K:\AosService\WebRoot

Reference: https://stoneridgesoftware.com/how-to-connect-your-dev-and-uat-environments-in-dynamics-365-finance-and-operations/

Set up Onebox VM for D365 FO with non-organization microsoft account

With the release of the new VHD 10.0.37, I have tried to create a Onebox VM in my laptop instead of using the cloud hosted environment and found the below articles really helpful to setup the VM with my private Microsoft account:

https://alexdmeyer.com/2023/07/05/step-by-step-guide-to-deploy-a-local-vhd-of-d365fo/

https://community.dynamics.com/forums/thread/details/?threadid=01455e69-5d7e-4896-b2c6-673a49b28bfa

Optimization advisor in D365 FO

 https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/sysadmin/optimization-advisor-overview

Uninstall Store Commerce app using Power shell

 1. Search for the full package name of the current MPOS using command 

Get-AppxPackage -AllUsers

or 

Get-AppxPackage *pos* --AllUser

then find the package of the Microsoft.Retails

2. Uninstall the package using below command

Remove-AppxPackage -AllUsers <Package name in step 1>

3. Go to Control Panel to find the Commerce app and uninstall it.

Creat DB snapshot in order to reuse the test data

 --Taking the snapshot

CREATE DATABASE AxDB_Snapshot ON  

( NAME = <DB Logical name>, FILENAME =  

'J:\MSSQL_BACKUP\AX_Snapshot2.ss' )  

AS SNAPSHOT OF AxDB;

It took me around 2 mins to create the snapshot

--Restoring the database from the snapshot

ALTER DATABASE AxDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

RESTORE DATABASE AxDB from  

DATABASE_SNAPSHOT = 'AxDB_Snapshot';  

ALTER DATABASE AxDB SET MULTI_USER;