You’re offline. This is a read only version of the page.
Announcements
140
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.
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.
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?
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
#1
André Arnaud de Cal...
294,137
Super User 2025 Season 1
#2
Martin Dráb
232,877
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
