Finance | Project Operations, Human Resources, ...

Automated Payment Advice Email for Vendor Payments

(0) Share

Report

Posted on by raoraheel

Hello All,

We currently use NACHA(US) file export method for processing certain vendors' payment where payment method is ACH. I have been given a requirement to somehow automate payment advice notification to vendors after payment has been generated. Currently accounts payable is manually printing/sending each advice document to each vendor.

I found this link utilizing Electronic Reporting however im not sure how to make it work for our existing process which is not currently using ER. I was able to test the power automate part and need some guidance on how I can either transfer NACHA file format to ER or use the existing file export process to accomplish this.

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

Your feedback is appreciated!

Thanks,

Raheel

All responses (6)

Answers (0)

raoraheel 85 on at

Like (0)

Report

RE: Automated Payment Advice Email for Vendor Payments

That's great suggestion, Juan. For this requirement, I'll first try with ER as it will help me get familiar with ER for any future reporting needs. I will then try out your solution as well!
raoraheel 85 on at

Like (0)

Report

RE: Automated Payment Advice Email for Vendor Payments

Hi Mihaela, giving this a try. Will keep you posted. Thanks
Suggested answer

MhaU on at

Like (0)

Report

RE: Automated Payment Advice Email for Vendor Payments

Dear Raheel,

Thank you for posting this issue to our community.

From electronic reporting you can create an export format for NACHA starting from existing model Payment model and create a new format.

If you need to familiarize yourself with this topic, please go through our documentation:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/general-electronic-reporting

Import one Credit Transfer configuration, then place your cursor on the Payment model, click Create configuration and choose to create new format and pick the data definition CustomerCreditTransferInitiation since this is a vendor payment,

Next you open in designer and start building the text format. If you wish to see how a format looks like, import BACS for UK and open it in designer. Perhaps it would be easier to create your configuration based on the BACS. In order to derive BACS, place your cursor on the BACS configuration, select create configuration and choose derive.

For the payment advice, if you need to modify the template then import it into the format, please see steps below:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/modify-electronic-reporting-format-reapply-excel-template

Once you are done with designing the configuration, you can set destination for the payment advice to be sent via email:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/electronic-reporting-destinations

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-destination-type-email

Let us know if you need any other information and I will be more than happy to assist further.
Juanse 660 on at

Like (1)

Report

RE: Automated Payment Advice Email for Vendor Payments

Hello,

For the power automate, there is this business events that can be used with power automate. "VendorPaymentPostedBusinessEvent" Problem with this one is that the details that will come out of it might not be enough. It will probably require some customization to fix the Json schema that it provides. I think once you get that done, using this business events can be a viable option for automating this. That is if ER is not an option.

Regards,
raoraheel 85 on at

Like (0)

Report

RE: Automated Payment Advice Email for Vendor Payments

Hi Ludwig,

We have a payment method setup as ACH that uses NACHA (US) export format.

We create a journal, click generate payment and select the export format like this.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Automated Payment Advice Email for Vendor Payments

Hello Raheel,

What you need is a method of payment that points to an electronic reporting output format.

Is this setup and used when you generate the payments?

Can you possibly share some screenshots that illustrate the setup made and how you process the payments?

Many thanks and best regards,

Ludwig