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

Transaction Code must have a value in EFT Export Workset

(0) Share

Report

Posted on by SunTzu

I am receiving the following error when trying to export a payment batch:

"Transaction Code must have a value in EFT Export Workset: Journal Template Name=PAYMENT, Journal Batch Name=EFT, Line No.=10000, Sequence No.=1. It cannot be zero or empty."

I have tried searching in BC, the help and our good friend Google but nothing has indicated where I should be looking to resolve this.

I don't see this field in the payment journal so is this error representing something else?

Alternatively, where do I find this field so a value can be populated?

Thank you for your assistance.

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

What localization and version are you running. And what steps have you already completed?

In NA localization, you have to Export File, then go to Generate EFT File and press button for Generate EFT file.

Was this reply helpful? Yes No
SunTzu 5 on at

Like (0)

Report

Thank you Kim.

I should have been more descriptive of the situation.

I receive the error when I attempt to export the file.

I am in the North American version.

In that, from the 'Payment Journals' I select 'Generate EFT File' and then when I press the button for Generate EFT file I receive the error message.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

Did you do the step Bank/Export?

This step creates the data in the Generate EFT File....

Do you see data in the Generate EFT File screen?

Was this reply helpful? Yes No
SunTzu 5 on at

Like (0)

Report

Thank you Kim,

I did do the export step and I do see data in the Generate EFT File screen.

My suspicion is that the stated error is not the real error.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

Did you use the standard EFT data exchange or did you modify? There is a transaction type in the data exchange definitiion.

Was this reply helpful? Yes No
SunTzu 5 on at

Like (0)

Report

I have not made any modifications.

I am looking the data exchange definition and I don't see a default value for the transaction code. This suggests the code is set somewhere else. But where?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello,

Here is my EFT Default US. The setups are above and showing the Transaction Code is noted.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
SunTzu 5 on at

Like (0)

Report

Thank you Steven,

I went through the set up I have and compared it to what you posted. I have even placed a value in the constant field but still produce the error.

Is there a logging function that will show what it is actually complaining about?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, If you think there is no problem with the settings, but you still cannot find the error, it is recommended to contact the developer to debug.

some information about settings:

https://www.youtube.com/watch?v=--rZjNyc09o

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

And the following may not be the same as your question, but hopefully gives you some hints.

https://yzhums.com/8319/

Hope this also helps.

Thanks.

ZHU

Was this reply helpful? Yes No
SunTzu 5 on at

Like (0)

Report

Thank you Zhu.

In terms of contacting the developer, how do I contact Microsoft?

I don't think the issue is in the set up as I have been through it and it appears to match what is shown in the video and documentation that have been recommended.

There must be a way to see a error log in Business Central. I am thinking the error log will give more information about the real cause of this error.

Was this reply helpful? Yes No