web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to validate field ...

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

Answered

How to validate field value in Sales Invoice Line ? Business Central ( CLOUD )

(0) Share

Report

Report

Posted on by Rcordova NW

95

Hi ,

I need validate a field in Sales Invoice Line .

How can get the value of a field line by line and check that it is not empty ?

Thanks

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Community Member on at

Like (0)

Report

You can add the checking OnAfterModify

Was this reply helpful? Yes No
Rcordova NW 95 on at

Like (0)

Report

But how to make the loop to check line by line specific field?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You can use findset to loop the record and check the field

docs.microsoft.com/.../record-findset-method

Was this reply helpful? Yes No
Rcordova NW 95 on at

Like (0)

Report

SalesLine: Record "Sales Line";

CurrPage.SalesLines.Page.GetRecord(SalesLine);

if SalesLine.FindSet then

repeat

Message(SalesLine.Description);

until SalesLine.Next = 0;

im do this but i have only 2 lines in subform and show a lot of Message , how to take only my 2 lines ?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

add setrange("Document Type",....) and setrange("Document No.",......) to only loop the record you want.

docs.microsoft.com/.../devenv-setcurrentkey-setrange-setfilter-getrangemin-and-getrangemax-methods

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,238

#2

YUN ZHU 773 Super User 2025 Season 2

#3

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans