How to import Data Exchange Defenition, into a general journal without Payroll function, or complete data

(3) Share

Report

Posted on by Sven Tweebeeke

Hi,

I created my first Data Exchange Definition to import a csv file into a general journal in Business Central.
File:

However I am struggling on some points:

1. Isn't there a way to have it imported without having the Type set to Payroll Import? Other forum answer gives this as a work around. I cannot find articles how to import Generic Import types

I want to make use of Generic Import as the csv file contains almost 700 lines which are not related to salary

2. When I import it via the Payroll button in the G/L journal, the date imported is always January (file contains 30-09-2022, imported as Posting date 30-01-2022)

3. I was also not able to have imported from the file the Shortcut dimension 1. (Column KP)

Result after import the csv file:

I hope someone can help me on those questions.

Thanks in advance,
Sven Tweebeeke

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

DAnny3211 11,423 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

hi

look this

https://yzhums.com/4809/

DANiele

Was this reply helpful? Yes No
Suggested answer

NavNab 6 on at

Like (2)

Report
Copy link

Link copied!

I'm not sure if there is a standard way to import CSV.

Check this link www.beyondit.gmbh/.../how-to-import-variable-csv-txt-files-with-the-data-exchange-framework-into-any-table

Was this reply helpful? Yes No
Sven Tweebeeke 26 on at

Like (1)

Report
Copy link

Link copied!

Thanks Daniele and NavNab,

I will have made a button function to import the file for Generic Import.

Can you also help on the other questions/struggles I have?

Thanks!

Sven

Was this reply helpful? Yes No
Suggested answer

Sven Tweebeeke 26 on at

Like (1)

Report
Copy link

Link copied!

My conclusion: As there is no standard available, you have to make modifications to define which definition to import and the import button

Was this reply helpful? Yes No
Verified answer

RB-31071919-0 16 on at

Like (2)

Report
Copy link

Link copied!

I was having same issue with dates. and then we got the fix. Make sure the m is capital. In US, it should be M/d/yyyy

this alone fixed the problem, weird solution but it worked

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,968 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, hope the following helps as well.

Dynamics 365 Business Central Blog Series: Import and Export data

https://yzhums.com/63762/

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to import Data Exchange Defenition, into a general journal without Payroll function, or complete data

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the April Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

How to import Data Exchange Defenition, into a general journal without Payroll function, or complete data

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the April Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates