Small and medium business | Business Central, N...

Importing a CSV Journal Entries file from another software

(1) Share

Report

Posted on by CB-25091721-0

Hello,

I am trying to set up a configuration table to import a CSV file of General Journal Entries from a different software.

It actually contains multiple entries but has extra columns and rows that are not needed. See the attachment.

I would want the Date, GL Accounts, amounts and to parse the account number from it being included with the name and hit the customer card,

Loan tables have not yet been created for each customer, but I am just testing things in the Sandbox environment.

I started configuring one like this:

With these fields:

I think I read that I can map columns in that one to what it should in BC, but is that correct?

Will it ignore the added TRANS rows and how would I get it to automatically parse the account number from the account number / name?

Some days there will be 5 entries. Some days there can be 50.

Any tips, help, recommendations, omissions or things I need to take out would be greatly appreciated.

By the way the Chart of Accounts is created using the same GL names.

Thanks,

Cedric

2024.09.24 AMS fo...

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report

Importing a CSV Journal Entries file from another software

Or you can consider customization or power auomate.

Dynamics 365 Business Central: How to import data from CSV (comma-separated values) file

https://yzhums.com/38802/

How to import data from a csv file to Business Central with Power Automate (No customization) – csv to JSON

https://yzhums.com/47113/

Thanks.

ZHU
Suggested answer

Valentin Castravet 24,910 Super User 2024 Season 2 on at

Like (1)

Report

Importing a CSV Journal Entries file from another software

Configuration packages allow for basic column mapping, where one value is mapped to another. However, in your case, this means it likely won't be able to parse both the account number and name.

Instead, if you were using data exchange definitions you can use transformation rules for parsing and that should work. The problem is that out of the box, data exchange definition can only be used to import into the general journal (this blog post explains how to set it up) and bank statements.

Additionally, it’s typically not possible to ignore the TRANS rows. For these kinds of requirements, it’s best to have a developer create a custom import for you (for example, an xmlport), which is usually a straightforward task that shouldn't take more than a few hours.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/