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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

How to make loop to get a field values line by line in "Sales Invoice Subform" ?

(0) ShareShare
ReportReport
Posted on by 95

Hi .

I need validate a Field inside "Sales Invoice Subform" ( Lines ) line by line .

I do this 

SalesLine: Record "Sales Line";
CurrPage.SalesLines.Page.GetRecord(SalesLine);
Message(SalesLine.Description);
The message show "Lampara AMSTERDAM" ( the last record in lines ) 

pastedimage1584030995466v1.png

But i need validate all lines  line by line i try do this : 

SalesLine: Record "Sales Line";
CurrPage.SalesLines.Page.GetRecord(SalesLine);
if SalesLine.FindSet then 
       repeat
          Message(SalesLine.Description);
       until SalesLine.Next = 0;
end;
But show me  a lot of Message all values in table SalesLine but not in Subform Lines( two lines )
i need to show two message "Escritorio Atenas" and "Lampara AMSTERDAM" ( are the records that are inside the lines )
How to make a loop to get the values in Subform Lines and not in all Table ?
Thanks. I need Help please
I have the same question (0)
  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,300 Super User 2026 Season 1 on at

    You don't need to call the GetRecord.

    If you are on the Sales Header page right now, just filter the lines.

    SalesLine.SetRange("Document Type","Document Type");

    SalesLine.SetRange("Document No.","No.");

    if SalesLine.FindSet() then

          repeat

             Message(SalesLine.Description);

          until SalesLine.Next() = 0;

  • Rcordova NW Profile Picture
    95 on at

    Thanks Teddy .

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,055 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans