Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Ian Waring]

My management are asking if any other UK or European user of Dynamics 365 for Finance & Operations has the ability – by *any* method – of outputting both bank payment files and remittances as part of the same payment run process. Our SI is using ER for HSBC Series 18 and Lloyds payments, but can’t work out a way to output remittances (other than Excel files provided in the same zip archive as the payment file itself).

We’re wondering if the only way is to direct ER output to a SharePoint directory and then get Microsoft Flow to send remittances out using remit-to purpose email addresses (or to print the remittance locally if no remit-to set). Or to use the old AX output format method. Or if there’s an ISV solution that can do this.

How does everyone else achieve this?

Also asking the Microsoft Dynamics Community btw…

——————————
Ian Waring
Head of Finance Systems & Projects
Jisc
Harwell Didcot
——————————

[Suhas Rao]

Hi Ian,

I was researching the same topic over the past few days and came across this blog post by Ludwig Reinhard. 

https://dynamicsax-fico.com/2019/01/05/some-notes-on-vendor-payment-advices-in-msdyn365fo/

Your idea of using ER with sharepoint online as the destination with Flow taking care of the email transmission seems to be in line with Ludwig’s blog post.

——————————
Suhas Rao
Sr, Functional Lead – D365FO
Sempra Infrastructure
San Diego, CA
——————————
——————————————-

[Ian Waring]

Ludwig to the rescue yet again. That is brilliant – thank you.

——————————
Ian Waring
Head of Finance Systems & Projects
Jisc
Harwell Didcot
——————————
——————————————-