RPA with Dynamics 365 Finance & Supply Chain

-
Image
Are you looking for ways to automate some of your routine accounting functions, like reconciling sub ledgers to the general ledger?   Microsoft has recently created some examples using Power Automate Desktop (think of it like Task Recording on steroids). It can not only automate steps through Dynamics 365, but it can also automate Excel and other applications. In one example from Microsoft they automate the AR to GL reconciliation: Automatic running of the AR aging and the customer/ledger reconciliation reports. Power Automate then extracts data from both reports in Excel and compares the balances. Power Automate then posts a Team message letting you know the subledger is in balance. Power Automate saves the reports with the date in the file name, so there is backup. Microsoft Directions & Example   I working with the example, I needed to make a couple of adjustments to the sample flow that was provided but I was able to get it to work. Here is a video of the flow running in
Post a Comment

Copilot Dynamics 365 Finance & Supply

-

Microsoft has recently released two Copilot applications to work with Dynamics 365 Finance & Supply Chain. These solutions are still in preview, so it should only be uses in sandbox environments to evaluate and learn how they will work with your organization.

Prior to installing it is important to make sure your environment meets the requirements. Dynamics 365 Finance & Supply Chain requires the latest hotfix on Dynamics 365 Finance version 10.0.34 (10.0.1591.107) and version 10.0.35 (10.0.1627.70) and later. In addition, the solutions rely on the Power Platform and Dataverse, so it is important to have the environments connected and user security set appropriately.

For more details on the prerequisites and the installation instructions you can follow the Microsoft installation documents.

Copilot in Microsoft Dynamics 365 Finance

Copilot in Microsoft Dynamics 365 Supply Chain

Let's look at what these two copilots provide to users

Copilot in Microsoft Dynamics 365 Finance

Collection coordinator summary

Copilot in Microsoft Dynamics 365 Finance works with the Credit and Collections module through a new workspace titled Collections coordinator summary.

The new workspace provides a new view into a customer's balance and activity. There is also a tab to quickly see all the open transactions. With Copilot in Microsoft Dynamics 365 Finance installed, AI will automatically generate a summary analysis of the open activity with the customer, and by clicking on the create reminder button, the system will automatically create an email. You will be able to edit the email prior to sending.

Copilot in Microsoft Dynamics 365 Supply Chain

Confirmed purchase order with changes

Copilot in Microsoft Dynamics 365 Supply Chain works with the Purchase and Procurement module through a new workspace, Confirmed purchase order with changes.



The new workspace is used to analyze any purchase orders that have a change to the quantity or the delivery date.  The workspace categorizes the changes as low impact or high impact.  Low impact changes are for purchase orders that have not been pegged to sales or production orders.  High impact changes are for purchase orders that have been pegged to a sales or production order.

Copilot provides a summary generated by AI of the changes in each category, so the user can get a quick overview of the detailed shown in the data.  This summary includes information on how many orders and lines have changed along with information on the items that have changed.


In addition, the workspace will also show any impacted downstream orders, including sales orders and production orders. 


From the workspace, if you are not willing to accept the changes, it is possible to start communication with the vendor through either Team or Email.  If the changes are acceptable, the user can quickly confirm the changed purchase orders.

Summary

As you can see with these two copilot solutions from Microsoft, that AI is starting to become part of the daily operations of the finance and operations teams.  These solutions are still in preview, so there might be more features coming before they are generally available, and I am sure with the current investments from Microsoft that we can expect more AI solutions in the new future.

Comments

Post a Comment

Popular posts from this blog

Using Full Page Apps in Dynamics 365 Finance

-
Image
Have you ever wanted to put a website or a model-driven Power App in one of your existing Dynamics 365 Finance workspaces or forms?  You might already know you can create a new workspace with a website, but did you know you can add the website to an existing workspace? Here is an example of the Vendor invoice entry workspace with the Invoice Capture Power App embedded. Prior to using this feature, you need to turn on "Saved views support for workspaces" in feature management. Once this feature is enabled you can follow the following steps to add the Invoice Capture app or any model-driven Power App or website to an existing workspace. Open the vendor invoice entry workspace From Options - choose Personalize this page From personalize menu - select the 3 dots - and then Add an app Once that is selected (the screen goes gray) - click on the section header where you want to add the app (in my example I put it in Links) On the Add an app menu - choose Website Give it a name (my e
Read more

Creating a date table with a fiscal year in your Power BI data model

-
Image
There are many different articles available on Time Intelligence in Power BI.   Many new users to Power BI do not really understand the importance of having a date table in their data model.   I have spoken on this topic on many different occasions and continue to receive a lot of questions about the topic.   In this article I am going to try and cover a few tips on how to work with dates in your Power BI model. Many new users simply use the Auto Date & Time function of Power BI.   This function automatically creates a hidden date table for each field in the model with a date or date/time data type.   This function is enabled by default and it allows for slicing by Year, Quarter, Month and Day.   The problem with Auto Date and Time is that it only works with a standard calendar (Jan to Dec).   It requires a datetime column in the fact table.   It does not work with multiple fact tables and it does not support time intelligence calculations (YTD, MTD, etc.).   So there must be
Read more

RPA with Dynamics 365 Finance & Supply Chain

-
Image
Are you looking for ways to automate some of your routine accounting functions, like reconciling sub ledgers to the general ledger?   Microsoft has recently created some examples using Power Automate Desktop (think of it like Task Recording on steroids). It can not only automate steps through Dynamics 365, but it can also automate Excel and other applications. In one example from Microsoft they automate the AR to GL reconciliation: Automatic running of the AR aging and the customer/ledger reconciliation reports. Power Automate then extracts data from both reports in Excel and compares the balances. Power Automate then posts a Team message letting you know the subledger is in balance. Power Automate saves the reports with the date in the file name, so there is backup. Microsoft Directions & Example   I working with the example, I needed to make a couple of adjustments to the sample flow that was provided but I was able to get it to work. Here is a video of the flow running in
Read more