How to use a unique Line No. when inserting a line

(0) Share

Report

Posted on by Hagru

297

Hello! I have made a codeunit that lets me insert a line into the Output Journal using the Item Journal Line record.

I have managed to insert the values I want and validate them successfully, inserting one line into the table.

However, I am struggling to insert more than one line without deleting the first one. The reason for this is that I get this error:

/The record in table Item Journal Line already exists. Identification fields and values: Journal Template Name='AVGANG',Journal Batch Name='STANDARD',Line No.='0' CorrelationId: fcde2248-cbd5-41b3-9655-e10a926ebed8./

I understand that the Line No. needs to change, but I am fairly new to AL, and don't quite understand how I can get the next available Line No.

AI keeps suggesting that I use the function NextLineNo(), but this function is not defined in my record /Item Journal Line/.

How can I get the next available Line No every time I insert a line?

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Sayli Mandavkar 3 on at

Like (0)

Report

How to use a unique Line No. when inserting a line

You have to set these properties on the page

AutoSplitKey = true;

MultipleNewLines = true;

Hope this helps
Suggested answer

YUN ZHU 85,883 Super User 2025 Season 1 on at

Like (0)

Report

How to use a unique Line No. when inserting a line

The line number of Item Journal Line is achieved through the AutoSplitKey Property.

More details: https://yzhums.com/41714/

You need to find the last one used (Findlast) and then plus 10000.

Hope this helps.

Thanks

ZHU