RPA with Dynamics 365 Finance & Supply Chain

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

AP Automation in Dynamics 365 Finance and Supply Chain

As a solution architect, prospects and clients often ask me for ways to improve their Accounts Payable process.  They receive hundreds of invoices every month, and it can take considerable amount of time to enter all of the detail as well as attaching the invoice for reference during the approval process.  This is an area where we have often needed to bring in an ISV solution, but that could cause other issues.  Microsoft has been doing considerable work around automation for AP and they recently released a public preview of their Invoice Capture solution.

I have had the opportunity to set this up in one of my test environments so I could get an idea of what they have to offer.  As we would expect, the Invoice Capture solution is built on the Power Platform.  It uses a model driven Power App along with Power Automate Flows to integrate with Dynamics 365 Finance.  However, since it is a solution, they have done much of the work for you, including creating the standard flows to load the invoice information and a copy of the invoice into D365.

The solution does require some initial setup, so it knows how you receive invoices.  Currently they can come from Office 365 Outlook, OneDrive, SharePoint or Outlook.com.  You can also setup the rules for specific legal entities, vendors, items and procurement categories.  The documentation provided by Microsoft will help you go through the setup.

Here is a link so a short demo of the solution.

Since this solution is in Public Preview, I would expect we will see some continued enhancements prior the general release.  Also there has been no announcement on the pricing for the solution at this time. Hopefully this information will be released soon.


Popular posts from this blog

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

Using Full Page Apps in Dynamics 365 Finance

Showing the last 12 months based on a date slicer