You’re offline. This is a read only version of the page.
Announcements
207
Hello!
I am trying to export an electronic payment file in D365 for Financials and I'm getting the error below. The number referenced in the error is the G/L Account number for the Bank Account that I have selected in the Payment Journal. The Bank account has Export Format (US), Export File Name, Transit No, and Payment Export Format (BANKDATACONVSERVCT) all setup.
Why is the error referencing the G/L account when I have the Bank Account defined on the payment journal? Am I missing some other setup?
Okay, I figured it out. Inside the payment journal I had the correct option for Bank Account, but the batch itself did not.
I was able to export the file, but as I look at it, it doesn't look like an ACH file that I'm used to. What is the format being used for BANKDATACONVSERVCT? And if it is not that format, is there a default one setup already?
Hi Amanda,
Let's see how both the batch and the Payment Journal lines work. Here is my batch:
And here is the line for my Payment Journal:
Do you have similar values in the columns for these?
Tammy,
I have confirmed that the Bal. Account No. is setup as a Bank Account (not G/L) and that I've checked the box for Allow Payment Export and still receive the error. I've deleted the lines and re-ran suggest vendor payments and still have the error.
I can see where the journal in the test company PMT REG works, but I tried creating my own, which is where I'm having the issue. The error indicates that I don't have the Bal Account No. correct, yet I do.
Thanks,
Amanda
Hi Amanda,
I was stepping through this process, and did encounter the same error. In my case, it was due to the Batch for my Payment Journal having a Ba. Account Type of G/L Account and Bal. Account No. of 10100. The batch should instead reference a Bank Account and appropriate Bank Account Number.
While you are there in the fields for the Batch, you will also need to mark the checkbox to "Allow Payment Export".
Hope these help!
#1
André Arnaud de Cal...
293,289
Super User 2025 Season 1
#2
Martin Dráb
232,068
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
