The record in table Gen. Journal Line already exists

(7) Share

Report

Posted on by JE-20081519-0

3,898

Hi:

An end user is getting the following error: The record in table Gen. Journal Line already exists.

A screenshot is pasted below.

No such entries exist.

So, why is this message appearing?

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

Mohana Yadav 61,214 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Could you please click on the Share Details in the screenshot and copy paste here?

What is user trying to do?

Was this reply helpful? Yes No
JE-20081519-0 3,898 on at

Like (2)

Report
Copy link

Link copied!

@Mohana Yadav

She's trying to import into the G/L journals.

If requesting support, please provide the following details to help troubleshooting:

Error message:

The record in table Gen. Journal Line already exists. Identification fields and values: Journal Template Name='PAYMENT',Journal Batch Name='PAYROLL',Line No.='10000'

Internal session ID:

a8e3a448-decd-49dd-b9ae-6d169afa0079

Application Insights session ID:

b8edafd1-36b1-47b5-aa8d-7b18df87759d

Client activity id:

c9386b63-5bad-482b-88a0-bf24a8307e63

Time stamp on error:

2025-08-19T16:42:24.9425274Z

User telemetry id:

99519f3f-312e-4d0f-9b71-9642a46c749c

AL call stack:

"IWX IEPT Imp. Exp. XMLPort"(XmlPort 23067855).doAfterImportRecord line 25 - Import Export PowerTool by Insight Works version 1.0.8845.1

"IWX IEPT Imp. Exp. XMLPort"(XmlPort 23067855)."Integer - OnBeforeInsertRecord"(Trigger) line 10 - Import Export PowerTool by Insight Works version 1.0.8845.1

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,212 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, This is a customization issue, which appears to be provided by Insight Works. Please contact them to resolve the issue, or uninstall their extension.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

KP - Solution Archi... 658 on at

Like (4)

Report
Copy link

Link copied!

Hello,

Please delete the already existing lines in this journal and then try to import it again

Let me know if this helped you.

Thanks,

KP

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 9,156 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hello John,

Can you try to clear out lines in that batch before re-importing. Hope this might solve your problem or else you can contact your partner to debug the same and resolve the issue.

Hope this answer will help you!

Regards,
Mansi Soni

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,214 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Looks like the solution you are trying to use is expecting the batch to be empty so please delete all entries in Journal Template Name='PAYMENT', Journal Batch Name='PAYROLL'

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Ahmad Subhani 662 on at

Like (2)

Report
Copy link

Link copied!

Hi,

The primary key of the General Journal line table is a combination of fields:

1- Journal Template Name

2- journal Batch Name

3- Line No.

If all 3 are the same as an existing line then the system will say "Record Already Exists"

Mark the Answer as Verified if this is Helpful.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,173 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Delete all entries in Gen. Journal Line where Journal Template Name = 'PAYMENT' and Journal Batch Name = 'PAYROLL'. This clears the duplicate line and resolves the error.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No