Payment advice for NACHA (and other ACH) prints as multiple files

(0) Share

Report

Posted on by ZvikaR

168

In the AP module, we use D365FO to generate NACHA files to make electronic payments to our vendors.

We use the "Payment Advice" report generated to serve as a "paper" backup, for the person going into the bank's portal to approve the payments made (as that report contains both payment total and list of invoices paid).

If I try to print payment advice to SCREEN it opens each advice as a separate "report", requiring me to print & close each of them separately before D365 even generates the electronic ACH file.

If I try to print the report as PDF, it requests me a file name, then the resulting file contains only the LAST payment advice (as clearly the system create all payment advices on the same name, each overwriting the previous one)

1. Is there a way to generate a single payment advice containing ALL vendor payment lines?

2. Alternatively, is there a way to create each payment advice as a file with a unique name (so I can have all instead of just the one for the last payment line)?

This is one of those examples where I want to appeal to Microsoft to stop building good-for-no-one AI based accounting solutions, and make the basic product a little bit less backward functionality wise.... sorry for my little rant.

I have the same question (0)

All responses (5)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Zvika,

For no 1:

Can you check what has been setup in the method of payment. Does your method of payment make use of the 'total' option that summarizes all payments of a single vendor into a single payment?

For no 2:

Yes, you can do that. I prepared a blog post with one of our colleagues that demonstrates this. Will be published in the next couple of weeks. In an nutshell, you have to setup a dynamic name in the electronic report configuration that is used for generating the file. If you need to recording beforehand, let me know, can send it to you if urgent.

Best regards,

Ludwig

Was this reply helpful? Yes No
ZvikaR 168 on at

Like (0)

Report

sorry for not being clear,

For (1): yes, the Method of Payment is set to "All" and multiple invoices already are settled by a single payment.

However I have in the journal multiple vendors/multiple payments, but the system opens a separate form / create separate PDF for every payment advice (=every payment made to a vendor, where a single payment may still pay multiple invoices)

For (2) the payment advice is part of the out of the box "Export Format" for generating NACHA files. We are currently not using the Electronic Reporting option.

IS there a NACHA generation out of the box through through electronic reporting?

Was this reply helpful? Yes No
PK Axapta 140 on at

Like (0)

Report

Hi Zvika,

Did you achieve to export NACHA via electronic reporting OTB or did you created the new format for NACHA?, if yes, Did you derived new model from existing or how you achieved this?

Many thanks.

Was this reply helpful? Yes No
ZvikaR 168 on at

Like (0)

Report

we ended up using the "export format" for NACHA, not the electronic reporting feature.

Was this reply helpful? Yes No
Betty GRD on at

Like (0)

Report

hi,

i am interested about the blog you prepared on the payment file ACH setup, can you provide the link?

thanks,

Was this reply helpful? Yes No