Setting BC Field to Mandatory

(7) Share

Report

Posted on by ME-31032107-0

683

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)

Suggested answer

ME-31032107-0 683 on at

Like (4)

Report

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 95,307 Super User 2025 Season 2 on at

Like (4)

Report

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 683 on at

Like (5)

Report

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 8,576 Super User 2025 Season 2 on at

Like (0)

Report

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