Configuration Package - Journal Upload

(5) Share

Report

Posted on by SL_GP_BC_123

1,106

I have the following configuration package setup for Journal Lines. Below are the available columns:

Field ID	Field Name	Include Field	Validate Field	Processing Order
1	Journal Template Name	TRUE	TRUE	1
51	Journal Batch Name	TRUE	TRUE	2
2	Line No.	TRUE	TRUE	3
3	Account Type	TRUE	TRUE	4
4	Account No.	TRUE	TRUE	5
5	Posting Date	TRUE	TRUE	6
6	Document Type	TRUE	TRUE	7
7	Document No.	TRUE	TRUE	8
8	Description	TRUE	TRUE	9
14	Debit Amount	TRUE	TRUE	14
15	Credit Amount	TRUE	TRUE	15
24	Shortcut Dimension 1 Code	TRUE	TRUE	24
25	Shortcut Dimension 2 Code	TRUE	TRUE	25
26	Salespers./Purch. Code	TRUE	TRUE	26

Below is a sample of the data, columns arranged in the same order as the configuration package. The package template was created via an export of the data and the columns are in the same order as above. The last two data columns are truncated for this post, but they do exist in the upload and include some data. The dimension values are legitimate and are not restricted in any manner. When uploading the data does not appear to align appropriately. Is there a step or trick I may be missing? Please advise. Look forward to a response.

Journal Template Name	Journal Batch Name	Line No.	Account Type	Account No.	Posting Date	Document Type	Document No.	Description	Debit Amount	Credit Amount	Shortcut Dimension 1 Code	Shortcut Dimension 2 Code	Salespers./Purch. Code
GENERAL	DEFAULT	10001	G/L Account	60500	2022-10-31		JE10001	Salaries Expense	1000	0
GENERAL	DEFAULT	10002	G/L Account	61300	2022-10-31		JE10001	Utilities Expense	0	350.25
GENERAL	DEFAULT	10003	G/L Account	60500	2022-10-31		JE10001	Processing Fees	0	649.75
GENERAL	DEFAULT	10004	G/L Account	61300	2022-10-31		JE10001	Utilities Expense	200	0	ADM
GENERAL	DEFAULT	10005	G/L Account	60500	2022-10-31		JE10001	Processing Fees	0	200
GENERAL	DEFAULT	10006	G/L Account	60700	2022-10-31		JE10001	Salaries Expense	1000	0	ADM	EAST
GENERAL	DEFAULT	10007	G/L Account	61300	2022-10-31		JE10001	Utilities Expense	0	350.25

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Valentin Castravet 32,157 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Typically that’s all you need to do: export the configuration package to get the template, don’t change it at all (don’t reorder any columns), and then upload that same template with your data.

Can you clarify what you mean by “the data does not align properly”? Do you mean the values end up in the wrong fields in BC? If so, that almost always means the column order in the Excel file was changed from the original template.

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

What is the error message?
Generally, after you select the fields, you can export the template. This way, the columns are completely consistent.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,808 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

Your journal import misaligns because config packages only work if you paste data into the BC-exported Excel without changing any columns at all.
If the order, hidden columns, or structure changed even slightly, BC shifts values into the wrong fields.

Fix:

Re-export the Gen. Journal Line table.

Paste your data into that sheet exactly as-is.

Import again.

https://learn.microsoft.com/en-us/dynamics365/business-central/across-import-data-configuration-packages#import-data-from-configuration-packages

Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Aman Kakkar 2,977 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi,

I completely agree with the responses shared above.

Here's a clear approach that has worked well in similar cases:

In your configuration package, select the table and use the “Export to Excel” option to generate the file with the exact structure expected by the system.

Do not alter the column headers or structure in any way.

Simply paste or enter your data into the exported Excel file, ensuring it aligns exactly with the field order and formatting.

Once your data is filled in, import that same file back into the configuration package and apply it.

This method ensures your data respects both field order and data type expectations.

Do mark it as verified if this helps.

Aman K

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,947 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Technically you simply have to export the data and fill it back with the appropriate value that system can respect, nothing complex. Now if its not working as expected that means data mapping is not falling in place. Do you have any error on within configuration package screen?

Was this reply helpful? Yes No
SL_GP_BC_123 1,106 on at

Like (1)

Report
Copy link

Link copied!

@Valentin Castravet I was able to get it to work. Just had to export and generate a new template. I must have messed up a column name somewhere.

Appreciate the feedback.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,157 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Great!

Was this reply helpful? Yes No