Export EFT files error

(0) Share

Report

Posted on by Steve Simon

348

The "Use for Electronic Payments check box" must be selected on the vendor or customer bank account card. This is the error i get in the fact box while trying to export a Payment Journal for a vendor.

I followed Chris Bulson's article from April 28th, 2017. (https://blogs.msdn.microsoft.com/dyn365finsupport/2017/04/28/using-eft-in-dynamics-365-for-financials/)

I didn't set up the Bank Data Conversion Service, since I didn't think a monthly subscription in Euros would solve my US banking. Chris' article said it wasn't necessary.

I did check the "Use for Electronic Payments" check box on the Vendor Banking Screen, so i don't understand why that is the error i get.

Step 6 in the documentation from April 26th, 2018, says,

"In the Payment Journal window, choose the Generate EFT File action.

In the Generate EFT File window, all payments set up for EFT that you have exported from the payment journal for a specified bank account but not yet generated are listed on the Lines Fast Tab. Choose the Generate EFT File action to export one file for all the EFT payments."

However, their is no option on the menu ribbon for "Generate EFT File" Action. On the Home tab, there is an "Export" option, which says it will export a file with payments. However, I get the error "Use for Electronic Payments check box must be selected on the vendor or customer bank account card".

Any ideas?

Sincerely,

Steve Simon

PDG Consultants, Inc.

Categories:

Financial Management

I have the same question (0)

All responses (21)

Answers (0)

Soren Groes-Petersen on at

Like (0)

Report

Hi Steve - Look for the Generate EFT File action on the Navigate tab.

I have reported that it must be moved to the Actions tab.

Soren, Business Central writer

Was this reply helpful? Yes No
Steve Simon 348 on at

Like (0)

Report

Yes you are right the "Generate EFT File" action is now on the Navigate tab. Today I received the new Business Central interface.

However, I still receive the error above: The "Use for Electronic Payments check box" must be selected on the vendor or customer bank account card." I did check this box. Please see a copy of the Vendor's Bank Account screen, with that box checked. I attach a picture.

What did i do wrong?

Regards,

Steve Simon

PDG

Was this reply helpful? Yes No
Theresa Nistler 551 on at

Like (0)

Report

Hi Steve,

Can you email me directly? Tnistler@microsoft.com. I would like a screen shot of the bank account transfer section you are using for this payment as well.

Regards,

Theresa Nistler

Was this reply helpful? Yes No
Joel P Rodencal 60 on at

Like (0)

Report

I am having the same issue now as well working in Cronos USA and I was able to generate an EFT file yesterday, but now I go back in and trying to generate an EFT file for the same 2 vendors for new invoices and I am getting the error stating that the "use for electronic payment" needs to be marked on the vendor bank card. They are already marked, so why I am getting this error again?

Was there any resolution to this issue?

Was this reply helpful? Yes No
Steve Simon 348 on at

Like (0)

Report

Joel,

I never resolved this issue. A Microsoft employee, monitoring the Community Forum, helped me, first by indicating my mistake in setting a currency for the Bank Account Card. I had created the code "USD" and put that into the Bank Account Card. Then i created a few hundred transactions paying against that code. Turns out that that field should have been blank. I tried to deleted that code from the Bank Account, but the system wouldn't let me, because of the relationships to transaction records. The support tech then asked for assistance for a NAV developer to help delete that entry in the Bank Account. That made things worse, because all the transactions had the code.

I still can't export a file of EFT's. I will probably have to call a NAV consultant to dig me out of this.

Sorry, I can't help you.

Regards,

Steve Simon

PDG Consultants, Inc.

Was this reply helpful? Yes No
Joel P Rodencal 60 on at

Like (0)

Report

Steve,

Thanks for the quick reply and some insight. I haven't changed anything on my bank account or my vendor, all of my currency fields are still blank as well, both for the original AP invoice as well as the payment that I'm trying to export right now.

I even created a new bank account for the vendor and set that one as the default with the checkbox marked for "use eft" and I still get the same error.

Seems really odd that everything worked just fine yesterday when I went through this process.

Luckily for me I'm in the demo company so nothing hurt so far, but planning on going live with a customer real soon.

Hoping Microsoft can provide some additional insight!!

Thanks

Joel

Was this reply helpful? Yes No
Steve Simon 348 on at

Like (0)

Report

I'd like to see how you set up your Bank Account Card, particularly the Payment Export Format. Is it "US EFT CCD"?

Do you have a paid subscription to D365 Business Central? I know it is $40/month, but it is worth it so you can make mistakes in private, without letting your customer's know. Anyway I would be happy to know how things turn out for you.

Was this reply helpful? Yes No
Joel P Rodencal 60 on at

Like (0)

Report

I'm a partner so I've got access to a sandbox environment so this is all on my test environment right now :)

Here is my bank import/export setup, I just created one called TEST at this point, could have used the one that was already setup, but I didn't.

And then here is my transfer section on by bank account card and my currency code is blank on my bank account.

Was this reply helpful? Yes No
Joel P Rodencal 60 on at

Like (0)

Report

sorry my first pic changed. Here is my import export setup.

Was this reply helpful? Yes No
Steve Simon 348 on at

Like (0)

Report

Thanks, Joel. Please let me know when you figure it out.

Sincerely,

Steve Simon

Was this reply helpful? Yes No