Last week, on the 23rd of October I had the pleasure to speak in three sessions at the Dynamics 365 User Group Sweden in Stockholm at the Micrsoft Office.
I had a great day, even if it started of with a presentation mishap which I managed to correct in time together with one of my fantastic colleagues. The lasting result was only an overdose of adrenalin 🙂
Here are the links to the presentations: D365UG Fall 2024
A wee k or so ago, one of my colleagues contacted me from one of our customers. She was setting up VAT reporting for Germany and in the instructions it says that in order to set it up you will need to import a data package from the LCS Shared Asset Library. When she goes to the Shared Asset Library in LCS it is completely empty.
It turns out that this customer is in the EU LCS tenant and Microsoft has not populated the Shared Asset Library in EU. To get to the files there is a fairlysimple solution:
I had an issue today at a customer… We were not able to open the Charge code form in one of our environments.
When we tried to open the form we also got a couple more error messages. tThe first saying that we could not read Retail Headquarter Parameters which lead us to try that form and we got an error which looks like: Parameter record does not exist.
Turns out that this was a bug introduced in 10.0.37 and which will be fixed in 10.0.38 related to the feature called Enable proper tax calculation for returns with partial quantity. When this feature is enabled the system is not able to create a line in the parameter table for Retail Headquarters due to a default value is not allowed.
The workaround is to disable the feature temporarily, initiate the creation of Retail parameters in the affected companies and then re-enable the feature.
Good luck
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
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:
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
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
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.
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
{
"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"
}
]
}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