Small and medium business | Business Central, N...

Answered

How to set Sr no automatic.

(0) Share

Report

Posted on by Nilam Bhor

153

Hii guys,

For example: Here ,My column is sr.no,and this sr.no is a primary key .I write this logic,but I am getting output in sr no start with 0.

I want sr .no starts with 1.

Is there is any way to do this.

All responses (4)

Answers (0)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can set field property as per below,

AutoIncrement=true;

learn.microsoft.com/.../devenv-autoincrement-property
Suggested answer

Nilam Bhor 153 on at

Like (0)

Report
Copy link

Link copied!

No. Actually I want write a logic for sr no gets automatic.

We don't want autoincrement property.

My result is come, but it starts with 0.

I want number starts with 1.

Suggested answer

Nitin Verma

21,812 Moderator on at

Like (0)

Report

Copy link

Link copied!

Try below code

trigger OnInsert()
var
YourTable: Record YourTable;
begin
"Entry No." := 1;
YourTable.Reset();
YourTable.SetRange("Entry No.");
if YourTable.FindLast() then
"Entry No." := YourTable."Entry No." + 1;
end;;

Nilam Bhor 153 on at

Like (1)

Report
Copy link

Link copied!

Thank you .It works.

Join the conversation

Community site session details

How to set Sr no automatic.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

How to set Sr no automatic.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates