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)

Suggested answer

DAnny3211 11,397 on at

Like (2)

Report

hi

look this

https://yzhums.com/4809/

DANiele

Was this reply helpful? Yes No
Suggested answer

NavNab 6 on at

Like (2)

Report

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

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

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

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 95,329 Super User 2025 Season 2 on at

Like (2)

Report

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

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November 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

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates