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... Mandatory fields AL

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

Answered

Mandatory fields AL

(0) Share

Report

Report

Posted on by Romryan

Dear All,

How can I have the location field mandatory on the Purchase Order line after/when I open a purchase order?.

Which page trigger is the best suited for this?.

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Anita75 1,165 on at

Like (0)

Report

Not sure why you need a trigger on open page ..I'd validate when a user enters a line say when Qty/price entered using OnAfterCalcLineAmount as below code unit:

begin

if PurchaseLine.Type = PurchaseLine.Type::Item then begin

If (PurchaseLine."Location Code" = '') then begin

if PurchaseLine.FindFirst() then

error('Must have location code');

end;

end;

end;

Was this reply helpful? Yes No
Verified answer

Jack Davies 120 on at

Like (0)

Report

Add a page extension...

pageextension xxxxx "My PO Subform" extends "Purchase Order Subform"

{

layout

{

modify("Location Code") { ShowMandatory = true; }

}

}

This will show the location as being mandatory on the lines (the red * will be displayed in the empty field)

Was this reply helpful? Yes No
Neil Phelan 161 on at

Like (0)

Report

Jack just following up on this old thread.

While I can show the field as mandatory it doesn't stop the user from not entering a value in the field. Is there any way to force the users to enter a value before the record can be saved?

Was this reply helpful? Yes No
Jack Davies 120 on at

Like (0)

Report

You would need the OnQueryClosePageEvent...

That would give you results similar to the this ... https://drive.google.com/file/d/1D_I8ImbYItqWCbD0IlzEeqbMYztoBKQe/view?usp=sharing (this is a "programming without code" solution that is available for BC v18+)

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,606

#2

YUN ZHU 931 Super User 2025 Season 2

#3

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans