Can I write a stored procedure that will require the E-Mail field in the contact person tab without

[Y-Yusuf]

Can I write a stored procedure that will require the E-Mail field in the contact person tab without? When I enter a contact person, the stored procedure I wrote works, but if nothing is entered in that field and I add a business partner, the stored procedure does not work.

[SonTran]

It is convenient for supporting if you share your store procedure

[Y-Yusuf]

IF @transaction_type IN (N'A','U') AND (@Object_type = '2') begin if exists(select T0."CardCode" from OCRD T0 INNER JOIN OCPR T1 ON T0.[CardCode] = T1.[CardCode] where T1.[E_MailL] is null and T0."CardCode" = @List_of_cols_val_tab_del ) begin SET @error = -77 SET @error_message = 'It is mandatory to enter your e-mail address.' end end

[SonTran · Accepted solution]

Hi,

Try to replace

INNER JOIN OCPR T1 ON T0.[CardCode] = T1.[CardCode]

by

LEFT JOIN OCPR T1 ON T0.[CardCode] = T1.[CardCode]

Hope this helps,

SonTran

[Y-Yusuf · Accepted solution]

Hi, it worked. Thank you, regards.

[Y-Yusuf]

Hi, this stored procedure

IF @transaction_type IN (N'A','U') AND
(@Object_type = '2')
begin
if exists(select T0."CardCode" from OCRD T0
INNER JOIN OCPR T1 ON T0.[CardCode] = T1.[CardCode]
where
T1.[E_MailL] is null and T0."CardCode" = @List_of_cols_val_tab_del )
begin
SET @error = -77
SET @error_message = 'It is mandatory to enter your e-mail address..'
end
end