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

Row number in sales line page

(1) Share

Report

Posted on by Sathiyamoorthy

How to get selected row number in sales line? or selected row number in any list page ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Sort by

soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

Do you want to count the row number? or get the selected row line number?

Was this reply helpful? Yes No
Sathiyamoorthy 16 on at

Like (0)

Report
Copy link

Link copied!

I want the row number 7 as highlighted below

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think you can use "Line No." fields in Sales Line Table.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Sathiyamoorthy 16 on at

Like (0)

Report
Copy link

Link copied!

Line number having 10000,15000, 20000,30000,..........etc, I need line number like 1,2,3,4,5,....etc

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Sathiyamoorthy,

try this :

action("Get seq number") { ApplicationArea = All; trigger OnAction() var SalesLine: Record "Sales Line"; seq: Integer; begin SalesLine.SetRange("Document Type", Rec."Document Type"); SalesLine.SetRange("Document No.", Rec."Document No."); SalesLine.SetRange("Line No.", 0, Rec."Line No."); seq := SalesLine.count(); Message(Format(seq)); end; }

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Gerardo Rentería Ga... 26,091 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

If you want the row numbers to be unique, do not change and are directly related to the row, I would tell you to create a field where you update the row number, and with each insertion you increment it.

As you have indicated, the "line number" is created with large range numbers, because they allow new rows to be created in the middle.

If you want to have visibility of the number of lines in a document, this could help you.

https://yzhums.com/31913/

BR

GR

Was this reply helpful? Yes No
CU29041409-0 35 on at

Like (0)

Report
Copy link

Link copied!

In Microsoft Business Central, you can get the selected row number in a list page by using the GETRECORDID function. This function returns the unique identifier of the selected record in the list. You can then use this identifier to retrieve additional information or perform actions related to the selected record. Here's an example of how you can use GETRECORDID:RecRef.GETTABLEVIEW(Page::"YourPageName").GETRECORDID(); Replace "YourPageName" with the name of the page where you want to get the selected row number. This code will return the record ID of the selected row in the specified page.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,978 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, not sure if you want to get this line number in the code? Hopefully the information below can give you some tips.

Dynamics 365 Business Central: How to get a filter for the selected records on any page (For example, ‘1..3|6’)

https://yzhums.com/27561/

Thanks.
ZHU

Was this reply helpful? Yes No
Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, if your issue has resolved, please mark the helpful answers so that you can help others who have the same question on the community.

Was this reply helpful? Yes No