Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Electronic Payment - E...
Business Central forum

Electronic Payment - Export

(0) ShareShare
ReportReport
Posted on by Amanda Mayer 205

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?

Export-Error.JPG

Categories:
Financial Management
  • Amanda Mayer Profile Picture
    Amanda Mayer 205 on at
    RE: Electronic Payment - Export

    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?

  • Tammy Torgerson Profile Picture
    Tammy Torgerson on at
    RE: Electronic Payment - Export

    Hi Amanda,

    Let's see how both the batch and the Payment Journal lines work. Here is my batch:

    PaymentJournal1.png

    And here is the line for my Payment Journal:

    PaymentJournal1.png

    Do you have similar values in the columns for these?

  • Amanda Mayer Profile Picture
    Amanda Mayer 205 on at
    RE: Electronic Payment - Export

    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

  • Verified answer
    Tammy Torgerson Profile Picture
    Tammy Torgerson on at
    RE: Electronic Payment - Export

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans