News and Announcements icon

Dynamics 365 CommunityForums Business Central forum To change the auto inc...

Business Central forum

Answered

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

(0) Share

Report

Report

Posted on by Aarthi Madhavan

22

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

Categories:

All responses Img

All responses (4)

Answers Img

Answers (2)

Verified answer

Tech-Lucky 794 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;
Verified answer

YUN ZHU 68,842 Super User 2024 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
Aarthi Madhavan 22 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
Suggested answer

NB-26050925-0 8 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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2

Martin Dráb 228,251 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans