Posts

Showing posts from September, 2020

How to: Access Just In Time Self-service UAT database for Dynamics 365 Finance and Operations

Image
 In recent changes by Microsoft, you can't access the VM for Tier2+ environments. The only access you have is access to the Azure SQL database using Just In Time access. You get temporary access to different databases of UAT according to your need. This is access is only for 8 hours, post that you need to request access again. Let's access the AX database: Login to LCS Go to UAT environment -> Full details. You should see request access controls like below: you can get access as read-only or read-write depending on your request. 'AX troubleshooting' will give read-only access and 'Performance tunning for AX' will give read-write access to Azure SQL. Once you click on Request access, refresh the page you should see 'Database accounts' section: In the above screenshot, I requested both access.  The next step is to enable access using IP whitelisting. Go to Maintain -> Enable access You need to add the public IP address from where you are going to acc...

How to : get the Deep URL for a particular form with filter in Dynamics 365 Finance and Operations

Image
 If you are a developer and need to generate the Deep-link then you can follow the code mentioned in MS docs at https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/create-deep-links But if you want to share a few URLs with filters already applied to other users then you can use the feature of  'Get a link' in D365FO. Suppose I want to share the list of all sales orders for customer 'US-001'. Go to Account Receivable -> Orders -> All sales orders  Filter by customer account 'US-001' Then in the navigation ribbon, go to Options and click on 'Get a link'   Copy all and paste the URL into new browser window. You will only see the sales orders for US-001. If you want to generate lot of deep URLs then you can also enable  'Automatically update query parameter' Once you enable this, as soon as you apply a filter on forms URL will be updated with the query parameters like below: You can copy and share the link directl...