web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

EFT File Structure - Sudden change in date format

(1) ShareShare
ReportReport
Posted on by 38
Our EFT bank file that was sent to the bank yesterday was rejected.  After some time on the phone with BMO (Bank of Montreal), it was discovered that the date format was not correct.  It should be in the Julian Calendar format.  We sent an EFT file to the bank on Thursday, July 25th and it was accurate and suddenly, it changed the format of the date next day.
 
Has anyone faced this before?
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    102,417 Super User 2026 Season 1 on at
    Hi, did the user who exported the file change the Region or Language?
     
    Thanks.
    ZHU
  • SharonLeggatt Profile Picture
    7 on at
    Same issue for my clients banking with ATB and RBC.  Language nor Regional settings were not changed.  They run their weekly eft payment cycle and now all of a sudden the bank rejects their files.   They have been on business central for 1.5 years all good until this past EFT payment run.  It appears one of the last Microsoft updates broke the Julian date format?
  • Suggested answer
    Jun Wang Profile Picture
    8,220 Moderator on at
    you could take a look at the data exchange format for the bank. It maybe that someone changed the date format from Julian date to another format. Change it back as needed. 
     
    check the lines on the header, details, footer sections. There should be lines for date, then change the data format to Julian. Below is an example of where to find the spot to change. You could also ask a correct data exchange definition from your partner and import into your BC. 
     
  • Verified answer
    Valentin Castravet Profile Picture
    32,800 Super User 2026 Season 1 on at
    The latest Business Central update changed the Julian date calculations in the code so that's why everyone is having issues with it. As far as I know a user's region/language settings doesn't affect these EFT/ACH dates. A quick fix would be for a developer to restore in the code how the calculation is done. 
     
  • Verified answer
    pramit9393 Profile Picture
    38 on at
    Thank you all. The developers ended up fixing it. It was an issue caused due to a recent update/hotfix.
  • Suggested answer
    Valentin Castravet Profile Picture
    32,800 Super User 2026 Season 1 on at
    Great, thanks for the feedback!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 695 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 422 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans