Posts

Find pending workflow instances for a certain user

, , ,
Find pending workflow instances

Persons who need to approve workflows or take other actions might not always be available due to vacation or illness. There is an option for workflow delegation in Microsoft Dynamics 365 Finance and Operations, but that is not a guarantee that all workflow instances are directed to the delegated user. Already assigned workflow instances will not be automatically delegated. When the user will return to work, the workflow instances are also not assigned back in the standard application. A system administrator can re-assign the pending workflows, but this is a tedious job. Due to a high volume of pending workflows and not having the user on the list page, you might think you need to loop through all pending workflow messages check the details one by one. In this post, you will get a guide on how to quickly find pending workflow instances for a particular user.

Read more
/7 Comments/by

Extensible Data Security examples – Secure by project responsible

, , ,
secure by project responsible

Recently, I was speaking about eXtensible Data Security (XDS) at a meetup session for the Pakistan Microsoft Dynamics 365 and Power Platform Community. I did a similar session several years ago and created three examples back then as part of the demonstrations of what would be possible to achieve with this framework for record-based security. For this recent session, based on a question on the Dynamics Community forum, I created a new example for restricting access to the projects and related information for a person who is one of the responsible persons. In this post, I will provide some more background information on the functional and technical details.

Read more
/10 Comments/by

Slow or fast? Performance considerations for the while select statement

, ,
while select statement

During my career, I have had to deal many times with performance issues. There are many different causes for this. It can be related to hardware, software, configuration and more. In this post, I will explain two scenarios where a while select statement caused performance issues and how to mitigate them.

Read more
/0 Comments/by

Feature trial: Inventory transactions archive

,
Inventory transactions archive

In March 2021, Microsoft released a preview for the archival of inventory transactions. The feature is useful for customers having a lot of inventory transactions. To prevent having performance issues when querying inventory transactions or using them in calculations for summary, Microsoft now made the option to archive inventory transactions. I spent some time reading the documentation and trying out the solution. In this post, I will share my findings related to testing the feature and what exactly is happening under the hood.

Read more
/2 Comments/by

Advanced search to find records in Microsoft Dynamics 365 Finance and Operations

Advanced search

In several cases, you are looking for a specific record, but the search criteria are not on the list page. When the details are in a related table, you can use the advanced search and sort option to join the tables as a business user and search for a specific record. This video shows an example of how you can achieve this and also use the Saved Views functionality to re-use a certain search query.

Read more
/0 Comments/by