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

ACH Format Export Error: Company Descriptive Date field must have a value in ACH US HEADER

(1) Share

Report

Posted on by Community Member

Hi,

I'm trying to generate an EFT export file but I've stumbled upon an error that I cannot find a solution for. When I try to click Generate EFT files in export dialog, it gives me the following error:

Company Descriptive Date must have a value in ACH US Header: Data Exch. Entry No.=12. It cannot be zero or empty.

I'd really appreciate any help or assistance in resolving this error!

Best,

Asfandyar

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

Awkward one to debug when not using the debugger. I'd have a look at the data exchange definition process. So what objects are included. I know GB so will make some assumptions here. On the bank account you may have an export object that is stipulated. That will then reference what data from the journal lines gets mapped to other tables. It must be the source data that is missing something.

As an aide with the data exchange definition you can get it to add substitute values or recondition data like a blank to something. Possible worth reviewing if my assumption on the source data pans out to anything.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Josh,

I tried looking for the field in source data that will be populated on the ACH header but of course I couldn't figure out where that field is supposed to be. Also, I couldn't find any answers anywhere on the internet. This is strange.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

So I figured out how to avoid the issue but not the solution to the problem. Vendor card information page, in the Payments tab, I had the field "Partner type" set to "Company". Setting it back to blank solved the issue for me. I still have no idea how to resolve the issue with previous setup, but the issue is gone now so I'm happy for now.

Thanks,

Asfand Yar

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

Thank you for sharing this insight. Glad the issue has been resolved.

Thanks.

Was this reply helpful? Yes No
Microsoft Dynamics ... 193 on at

Like (1)

Report

I am having this same issue and no matter what option I choose on the Partner type on the vendor it fails with the same error with the exception of the entry no. is different every time. I cannot Generate the EFT file.

Any help would be highly appreciated

Was this reply helpful? Yes No
DC-16051621-0 4 on at

Like (1)

Report

I can tell that the codeunit assigns the workdate to this field and there is no other option, but I can't say why it does not do it.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

If you have new ideas for improvements, you can submit them to Microsoft.

Missing a feature? Post or vote for ideas on: aka.ms/BCIdeas

Thanks

ZHU

Was this reply helpful? Yes No