Understanding Julian Date Format for EFT Export

Understanding Julian Date Format for EFT Export 

Electronic Funds Transfer (EFT) is a crucial process for many businesses, enabling the smooth transfer of funds between accounts electronically. Dynamics 365 Business Central offers robust tools for managing EFT, including the ability to customize date formats for transactions. One such format is the Julian date format, often used in financial transactions for its simplicity and unambiguity. This blog will explore how to configure the Julian date format for EFT exports in Business Central, using the provided screenshot for reference.

What is Julian Date Format?

The Julian date format is a continuous count of days since the beginning of the Julian Period used primarily by astronomers. In the context of financial transactions, it typically represents the year and the day of the year, simplifying date representation and reducing potential errors.

For example, January 1, 2024, would be represented as 24001, where "24" represents the year 2024 and "001" is the first day of the year.

Configuring Julian Date Format in Business Central

To configure the Julian date format in Business Central for EFT exports, follow these steps:

1. Navigate to Data Exchange Definitions: Go to the relevant Data Exchange Definition for your EFT export. This can be found under the Data Exchange Definitions section in the application.

2. Edit Line Definitions: Locate the line definitions for your EFT file. we see different line types such as "Detail", "Footer", "Header A", and "Header B". Select the appropriate line where you need to define the Julian date format by changing Data format culture and length