Help!! I closed the Excel Addin

A colleague of mine pinged me today and wondered if there is a way to reopen the Dynamics Excel Addin if you accidentally closed it, other than going back to Dynamics and reopen the file.

Since she was nice enough to ask the question and i did not know the answer I thought I might as well write it down so I do not forget 🙂

1. In Excel, go to the insert tab. Then click My Addins

2. Click on Microsoft Dynamics (if it is not there, click See all… instead and you will find it in the list)

3. The Addin will open up again and reload the condent of the excel file from Dynamics 365 FO

Good Luck

Issues syncing Sales Order Lines with Dual Write

I am doing some experimenting with Synapse Links for Dataverse and to do that I need my FnO data in Dataverse. The way I do it, is using Dualwrite. When I try to sync Sales Order Lines V2 to salesorderdetails I get the following error:

Reason: Bad Request, Header x-ms-client-request-id f1004256-8a98-42fe-86a9-02b8e64a81a9, Produkten kan inte läggas till eftersom den inte är aktiv

(for those of you, not fluent in Swedish it says “The product cannot be added because it is not active)

This means that the product is synced but it is not active. To activate the product it needs to be published. To do this go through the following steps:

  1. In Sales open products
  2. Select a product and click Publish

The problem was I had a couple of thousand products. So I googled and found this forum thread helping me to write a workflow to automate it (this is way beyond my knowledge in CRM).

Links:
https://learn.microsoft.com/en-us/dynamics365/sales/publish-product-bundle-make-available-selling
Bulk publishing products – Dynamics 365 Sales Forum Community Forum

Not able to activate Data Events for entities

Yesterday I looked into an issue for one of my customers. In one of their environments they where not able to activate Data Events for any of their entities. The Activate button was completely grayed out and the “Active Data Events” and “Inactive Data Events” tabs did not exist

This is an environment where we are currently running a PoC for DualWrite so I just “assumed” that I had configured PowerPlatform correctly (you know what we say about assumptions)

Turns out I had not followed my own advice and done the PowerPlatform configuration from LCS… Instead I did the linking from within FnO, in the DataManagement workspace.

The solution was to go through the linking wizard in LCS and then the tabs showed up



Note that the change to the Business Events Screen is not instant… I had to have it sitting over night to have the tabs show up

Links:
Figuring out DataVerse and DualWrite in Dynamics 365 FnO – JohanPersson.nu

User Access issues to Synapse Serverless Views

I just set up the CDMUtil for a customer to let them access Dynamics 365 for Finance and Operations Data, exported to a DataLake, through a serverless instance in Synapse. The customer had added a new user and got an error which vas not perfectly logical

Msg 15151, Level 16, State 1, Procedure CustTable, Line 1 [Batch Start Line 0]
Cannot find the CREDENTIAL 'dynamics365_financeandoperations_XXXXXXXX_sandbox', because it does not exist or you do not have permission.
Msg 4413, Level 16, State 1, Line 223
Could not use view or function 'dbo.CustTable' because of binding errors.

The issue was obiously a permission issue… but where??

When we added an earlier user we set up a Role in SQL that had read access to the SQL DataBase. When we added the user to that role it started working… The confusing part was that the error message did not mention the new user anywhere.

When you set up the Synapse connection to Data Lake and FnO… Make sure you add the correct permissions to new SQL-Native users using TSQL in Management Studio.

UPDATED: Configuring access for mobile warehousing app in Dynamics 365 for Operations

Back in 2018 I wrote an article on how to configure a D365FO instance to enable the Warehousing App. A lot of time has passed and tonight I will set up the all new and improved Warehouse App so I thought I would also take the time to update the original article

  1. Go to the azure portal. In Azure Active Directory – App Registrations create a web application for the warehouse portal
    Name: WhatEverYouWant
    Who can use thisapplication or access this API: Accounts in this organizational directory only
    Application Type: Web app/API
    Sign-on URL: https://[theURLforyourdynamicsinstance]/oauth
  2. Open the application to edit it
  3. Verify Application ID. Save this for later…
  4. Go to API Permissions and click Add a permission
  5. Select the API called Microsoft Dynamics ERP (Microsoft.ERP)
  6. Choose Delegated Permissions
  7. Under Permission to other applications click add application and add Microsoft Dynamics ERP
  8. Add the following permissions
    – Access Dynamics AX online as organization users
    – Access Dynamics AX data
    – Access Dynamics AX Custom Service
    Click Add Permissions
  9. Click Grant admin consent for [Your Organization] and confirm your choice
  10. Go to Certificates and Secrets and click New client secret. Select an expiration and give the key a description like D365FO Warehousing App
  11. Log into Dynamics 365 for Operations and go to System Administration – Users and create a new user (in my case called WMAPP. The email address can be anything since it will never be used. The user needs this role:
    – Warehouse mobile device user
  12. Now we need to associate the user to the AD Application which is done on System Administration – Setup – Azure Active Directory applications. Here we paste the App ID/ClientID from before and select the user we created. Click Save and you are done.
  13. Install the App from app store and enter these settings:
    1. Azure Active Directory ID: AppID/ClientID from step 3
    2. Azure Active Directory Client Secret: The key from step 10
    3. Azure Active Directory Resource: Your Dynamics 365 URL
    4. Azure Active Directory Tennant: https://login.windows.net/yourAzureADtennant.onmicrosoft.com
    5. Company: Dynamics 365 for Operations Legal Entity
  14. To configure the mobile att you create a JSON file with the connection setting
{
    "ConnectionList": [
        {
            "ActiveDirectoryClientAppId":"11111111-2222-3333-4444-111111111111",
            "ConnectionName": "YourConnection",
            "ActiveDirectoryResource": "https://{[yourdynamicsenvironent].cloudax.dynamics.com/",
            "ActiveDirectoryTenant": "https://login.windows.net/[yourtenantid].onmicrosoft.com",
            "Company": "USMF",
            "IsEditable": true,
            "IsDefaultConnection": true,
            "ConnectionType": "clientsecret"
        }
    ]
}
  1. The JSON file can either be uploaded to the device or converted to a QR code using a service like this.
  2. Unfortunately/Thankfully the client secret cannot be put in the file/QR code and it have to be entered manually by editing the connection on the mobile device.
  3. To login in to the app you will need to have a username and password. Go to Warehouse Management – Setup – Worker – Users and select a user (in my case 24). Reset the password for worker 24
  4. Login to the app using User ID 24 and the new password you just set

Note:
To use the new Warehousing App you will need to enable a feature i D365FO called User settings, icons, and step titles for the new warehouse app which is available from 10.0.17

Links
Install and connect the warehouse app – Supply Chain Management | Dynamics 365 | Microsoft Docs