Showing posts from February, 2019

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

Follow up to my Time Intelligence webinar

It was a pleasure to present a webinar on Time Intelligence for Power BI as part of the Best of 2018 Power Summit Webinar Series with Power BI User Group .  Over 100 people joined the webinar.  If you missed it, they are posting the recording on their website .   If you would just like to download the slide deck and files I used during the webinar simply go to this link .