cancel
Showing results for 
Search instead for 
Did you mean: 

mandatory Fields Help

thobenjo1
Explorer
0 Kudos
147

Dear Experts,

I want to make U_BRD AND U_Category in Sales order mandatory in stored procedure, can you please let me know the wuery for this.

View Entire Topic
SonTran
Active Contributor
0 Kudos

Hi,

You can tick Mandatory when add/update an UDF, refer the screenshot

Hope this helps,

Son Tran

thobenjo1
Explorer
0 Kudos

I tried doing this but it will affect all the marketing documents

SonTran
Active Contributor
0 Kudos

Hi,

If this causes any issue on other transactions, so notification is a better solution.

SonTran
Active Contributor
0 Kudos

Try this,

IF :object_type = '17' and (:transaction_type = 'A' or :transaction_type ='U') 

THEN
BEGIN

IF EXISTS (
select T0."DocEntry" from ORDR T0
where T0."DocEntry" = :list_of_cols_val_tab_del
and (ifnull(T0."U_BRD",'')='' or ifnull(T0."U_Category",'')='')
)
THEN
BEGIN
error := 1701;
error_message := N'BRD or Category can not be null, please check again.';
END;
END IF;
END IF;

Hope this helps,

Son Tran