How to validate a field in sales line and show error message

(0) Share

Report

Posted on by Community Member

on validating quantity in sales line a error message should be pop if the item is blocked on item card

modify(Quantity)

{

trigger OnAfterValidate()

var

ItemS: Record Item;

SaleslineS: RECORD "Sales Line";

TEXT2: Label 'This item is blocked %1 ';

begin

IF rec.Type = Enum::"Sales Line Type"::Item then

if ItemS.Get(REC."No.") then

if ItemS.Blocked = true then begin

Error(TEXT2, ItemS."No.");

end;

}

how to modify this code

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Nitin Verma 21,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can with also Event subscriber of OnValidate for Sales line.

but see the below code

tableextension 50102 ModifyQty extends "Sales Line" //37

{

fields

{

modify(Quantity)

{

trigger OnAfterValidate()

var

ItemS: Record Item;

TEXT2: Label 'This item is blocked %1 ';

begin

IF Type = Enum::"Sales Line Type"::Item then

if ItemS.Get("No.") then

if ItemS.Blocked then

Error(TEXT2, ItemS."No.");

end;

}

}

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Nitin Verma the above table extended code has no effect is there any solution?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

As soon as you enter the Item No. it automatically validate the Quantity field, is it working my side

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Nitin Verma thanks for the replies

IN CASE: if I block a item in item card ex: 0001 and if I tried to add 0001 item in the sales line. and on validating quantity a error should be shown but mentioned code doesnot give any error . am i missing something??

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

Then please move your code into Page extension

pageextension 50104 MyExtension extends "Sales Order Subform"

{

layout

{

modify(Quantity)

{

trigger OnAfterValidate()

var

ItemS: Record Item;

TEXT2: Label 'This item is blocked %1 ';

begin

IF rec.Type = Enum::"Sales Line Type"::Item then

if ItemS.Get(rec."No.") then

if ItemS.Blocked then

Error(TEXT2, ItemS."No.");

end;

}

// Add changes to page layout here

}

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Nitin Verma Hi, still it is the same . no changes

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

I am getting the error while using the same code, please brief me your steps.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,084 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I don't think this needs to be customized, the standard system has some controls about the Blocked item.

More details: How to block items (Block, Sales Blocked, and Purchasing Blocked)

https://yzhums.com/18968/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Nitin Verma I followed exact same steps. I added the code on page extension for sales line and I blocked a item in the item card and tried to add the same blocked item to the sales line still no any error messages .

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Use the below link for reference for doing the above activity.

https://erpconsultors.com/call-number-field-onvalidate-trigger-via-eventsubscriber/

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No