Small and medium business | Business Central, N...

Generate EFT - no roll back on error

(0) Share

Report

Posted on by Juliem

415

Hi,

One of our client setup the eft export process with ACH. The payment journal lines where created and exported. The next day, the user went to run the Generate EFT File process. The process failed on line #3. The issue is that the first 2 lines where flagged as transmitted even if they were not as the file was not generated at all. It looks like the process is not doing a roll back on error. They are running Dynamics NAV 2018

Any idea?

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

If you do not get further traction from the community, feel free to raise it to Microsoft support via your partner or CSP.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Juliem,

Since you did not Generate EFT File, you VOID the Export. Then start over. Before I do I am wondering why the first 2 lines show transmitted and included in your Payment Journal and Export. If they are to be there, I would have your Partner tell you when the records Transmission Date and File name was. This way you can check with Bank to see if transmitted and paid.

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I suggest you can recheck your settings.

More details: https://www.sauravdhyani.com/2019/09/nav-2018-business-central-export.html#more

https://docs.microsoft.com/en-us/dynamics-nav-app/localfunctionality/australia/electronic-funds-transfer-eft-

In addition, if there is an error on the screen, you can debug it to see what caused it.

https://docs.microsoft.com/en-us/dynamics-nav/debugging

https://docs.microsoft.com/en-us/dynamics-nav/walkthrough--debugging-the-microsoft-dynamics-nav-windows-client

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Juliem 415 on at

Like (0)

Report
Copy link

Link copied!

Sorry for the late reply.

Here is what I could find by debugging the process.

Codeunit 10320, ProcessDetails

The data get transfered to the Data Exch. Line Def and there is a COMMIT after the insert

Then the Codeunit 10327 is called, PrepareEFTDetails, and this function calls UpdateEFTExport from Codeunit 10098 where the Transmitted field gets set to true.

Same with 2nd line

Then I have an error on the 3rd line, but since there is a COMMIT before, the first 2 lines are still flagged as transmitted

The user corrects the error and click on Generate EFT Files again, and the first 2 lines don't appear in the worksheet, since they were flagged as transmitted

Was this reply helpful? Yes No