web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / To change the auto inc...
Small and medium business | Business Central, N...
Answered

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

(0) ShareShare
ReportReport
Posted on by Aarthi Madhavan 24
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)
  • Suggested answer
    NB-26050925-0 Profile Picture
    NB-26050925-0 12 on at
    You can set autoincrement property on S.No. field and try to insert record.
  • Aarthi Madhavan Profile Picture
    Aarthi Madhavan 24 on at
    Hi Nitesh Bhoir I already set autoincrement  property on S.No. field
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 102,054 Super User 2026 Season 1 on at
    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.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Verified answer
    Tech-Lucky Profile Picture
    Tech-Lucky 1,288 Moderator on at
    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;

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,687 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,041 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 974 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans