Data Exchange Definition Date Issue

Dynamics 365 Business Central Tip: Fixing Incorrect Dates in Bank File Imports

Have you ever imported a bank file into Dynamics 365 Business Central only to find that all your General Journal Lines are populated with the same date, even though the file contains different dates for each transaction? I recently encountered this issue, and after some investigation, I found the culprit: the date format.

The Root Cause: Incorrect Date Format

Business Central expects dates in a specific format when importing files. In my case, the issue arose because the date format in the file was incorrect. Even though the system was reading the data, it wasn’t interpreting the dates correctly, resulting in all transactions being assigned the same date.

The Fix: Set the Correct Date Format

To resolve this, ensure that the date format in your import file matches the expected format in Business Central. Specifically, use: dd/MM/yyyy (e.g., 13/03/2025) instead of dd/mm/yyyy (incorrect lowercase month format)

Key Takeaways

• Always verify the date format in your import files before processing.
• Business Central is case-sensitive when reading date formats.
• If you experience unexpected date behavior, check your Data Exchange Definition settings.

This small adjustment saved me a lot of time, and I hope it helps you too! Have you encountered similar issues? Share your experience in the comments! 🚀