To change the auto increment value while inserting a multi record at the same time.

(0) Share

Report

Posted on by Aarthi Madhavan

In the above image the field S.No. use same no while inserting multi record at the sametime.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Tech-Lucky 1,255 Super User 2025 Season 2 on at

Like (0)

Report

To change the auto increment value while inserting a multi record at the same time.

You can simply write this code on Table's on Insert Trigger and change the Variables accordingly.

trigger OnInsert()

var

CustomTable: Record CustomTable;

begin

CustomTable.Reset();

CustomTable.SetCurrentKey(EntryNo);

if CustomTable.FindLast() then

EntryNo := CustomTable.EntryNo + 1

else

EntryNo := 1;

Was this reply helpful? Yes No
Verified answer

YUN ZHU 89,830 Super User 2025 Season 2 on at

Like (0)

Report

To change the auto increment value while inserting a multi record at the same time.

Hi, is this a custom page?
If you are customizing, you can refer to the Entries table, find the last line, and then add 1 for the entry no in your code.

Or you can try AutoSplitKey Property.

More details: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-autosplitkey-property?wt.mc_id=DX-MVP-5004336

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Aarthi Madhavan 24 on at

Like (0)

Report

To change the auto increment value while inserting a multi record at the same time.

Hi Nitesh Bhoir I already set autoincrement property on S.No. field

Was this reply helpful? Yes No
Suggested answer

NB-26050925-0 12 on at

Like (0)

Report

To change the auto increment value while inserting a multi record at the same time.

You can set autoincrement property on S.No. field and try to insert record.

Was this reply helpful? Yes No