VALIDATION IN BUSSINESS CENTRAL

(0) Share

Report

Posted on by Pragya752

208

I want to apply validation on an existing field such that if i keep it empty and save it or send for approval it should throw validation error.Why this code is not working in my table extention.

modify("Free Text")

{

trigger OnBeforeValidate()

begin

if (rec."Free Text" = '') then

Error('Narration field is blank on Purchase Order. Kindly fill the same to sent PO for approval');

end;

}

All responses (14)

Answers (1)

Verified answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report
RE: VALIDATION IN BUSSINESS CENTRAL

Hi Pragya,

I don't know what your enum values are. But here, I have created a custom enum with a default value of blank.

enum 50152 InvoiceCategory { Extensible = true; value(0; MyValue1) { Caption = ''; } value(1; MyValue2) { Caption = 'Value 2'; } value(3; MyValue3) { Caption = 'Value 3'; } }

To validate your "Invoice Category" field with the "Free Text" field, add this code

if (PurchaseHeader."Free Text" = '') then Error('Narration field is blank on Purchase Order. Kindly fill the same to sent PO for approval'); if (PurchaseHeader."Invoice Category" = InvoiceCategory::MyValue1) then Error('Narration field is blank on Purchase Order. Kindly fill the same to sent PO for approval');

Regards
Suggested answer

Pragya752 208 on at

Like (0)

Report

RE: VALIDATION IN BUSSINESS CENTRAL

I used this.I wanted to make aone more field mandatory which is an Enum.Can i add that here as well like this ?

codeunit 90125 TestCodeUnit

{

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Approvals Mgmt.", 'OnBeforeCheckPurchaseApprovalPossible', '', false, false)]

local procedure OnBeforeCheckPurchaseApprovalPossible(PurchaseHeader: Record "Purchase Header"; var Result: Boolean; var IsHandled: Boolean);

begin

if (PurchaseHeader."Free Text" = '') then

Error('Narration field is blank on Purchase Order. Kindly fill the same to sent PO for approval');

if(PurchaseHeader."Invoice Category".AsInteger() = 0 ) then

Error('Narration field is blank on Purchase Order. Kindly fill the same to sent PO for approval');

end;

}
Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report
RE: VALIDATION IN BUSSINESS CENTRAL

Hi Pragya752,

Try this code. It will work for you in runtime 9.0
codeunit 50156 TestCodeUnit { [EventSubscriber(ObjectType::Codeunit, Codeunit::"Approvals Mgmt.", 'OnBeforeCheckPurchaseApprovalPossible', '', false, false)] local procedure OnBeforeCheckPurchaseApprovalPossible(PurchaseHeader: Record "Purchase Header"; var Result: Boolean; var IsHandled: Boolean); begin if (PurchaseHeader."Free Text" = '') then Error('Narration field is blank on Purchase Order. Kindly fill the same to sent PO for approval'); end; }

Regards
Pragya752 208 on at

Like (0)

Report

RE: VALIDATION IN BUSSINESS CENTRAL

I want this field to be mandatory before it sending for approval
Pragya752 208 on at

Like (0)

Report

RE: VALIDATION IN BUSSINESS CENTRAL

Support for using Identifiers instead of Literals in event subscribers.' is not available in runtime version '9.0'. The supported runtime versions are: '11.0' or greater this error is coming.
Pragya752 208 on at

Like (0)

Report

RE: VALIDATION IN BUSSINESS CENTRAL

let me try this
Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (1)

Report
RE: VALIDATION IN BUSSINESS CENTRAL

just adding some additional information here.

you can try using the OnBeforeCheckPurchaseApprovalPossible event,

codeunit 52452 TestCodeUnit { [EventSubscriber(ObjectType::Codeunit, Codeunit::"Approvals Mgmt.", OnBeforeCheckPurchaseApprovalPossible, '', false, false)] local procedure OnBeforeCheckPurchaseApprovalPossible(var PurchaseHeader: Record "Purchase Header"; var Result: Boolean; var IsHandled: Boolean); begin if (PurchaseHeader."Free Text" = '') then Error('Narration field is blank on Purchase Order. Kindly fill the same to sent PO for approval'); end; }

It runs before the purchase order is sent for approval, so you can use it to add your validation check and prevent the order from being sent if the field is empty.

Regards.
Suggested answer

Mohana Yadav 59,127 Super User 2024 Season 2 on at

Like (1)

Report

RE: VALIDATION IN BUSSINESS CENTRAL

yes, if you write code in above event then whenever you click on 'send approval request' the system will check if the field is entered or not.

if not then show error
Pragya752 208 on at

Like (0)

Report

RE: VALIDATION IN BUSSINESS CENTRAL

This field should be mandatory before sending the Sales Invoice under Approval Workflow.How can i make this field mandatory
Suggested answer

Mohana Yadav 59,127 Super User 2024 Season 2 on at

Like (0)

Report

RE: VALIDATION IN BUSSINESS CENTRAL

Please add your verification in OnAfterCheckSalesApprovalPossible event