Setting BC Field to Mandatory

(7) Share

Report

Posted on by ME-31032107-0

760

On the Sales Order page, I have configured the "External Reference No." field as Mandatory, and have also created the following trigger to not let the user close the page unless a value is entered:

trigger OnQueryClosePage(CloseAction: Action): Boolean

begin
Rec.TestField("External Document No.");
end;

My question is, I have also changed the field Caption to be "Customer Purchase Order No.", and want the message to indicate that Caption instead of what appears below.

Can this be accomplished somehow?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

ME-31032107-0 760 on at

Like
a
(4)

Report
Copy link

Link copied!

I wound up doing it this way, but not sure if there is a better method.

trigger OnQueryClosePage(CloseAction: Action): Boolean

var
OrderNo: Text;
ErrorMsg: Label 'Customer Purchase Order No. is required for Sales Order \ %1.';
begin
OrderNo := Rec."No.";
if Rec."External Document No." = '' then begin
Error(ErrorMsg, OrderNo)
end;
end;

Was this reply helpful? Yes No
Verified answer

YUN ZHU 102,049 Super User 2026 Season 1 on at

Like
a
(4)

Report
Copy link

Link copied!

You just need to update the caption of the table first. The error message of this method is to take the caption of the table field.

For example,

In addition, this is a standard feature and does not require customization.

Dynamics 365 Business Central: Set External Document No./Vendor Invoice No. as mandatory (Ext. Doc. No. Mandatory)

https://yzhums.com/58222/

Thanks.

ZHU

Was this reply helpful? Yes No
ME-31032107-0 760 on at

Like
a
(5)

Report
Copy link

Link copied!

YUN ZHU,

Thanks for the tip on the tableextension Caption (hard to believe I missed that), and the Sales & Receivables setup. While the S&R setup screen option does set the field as Mandatory, it does not prevent the user from exiting the screen w/out entering a value. So, I need the additional code to prevent that.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 9,191 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Instead of TESTFIELD you can write this -

IF "External Reference No." = ' ' then

Error('%1 is required.', FieldCaption("External Reference No."));

Was this reply helpful? Yes No