cancel
Showing results for 
Search instead for 
Did you mean: 

in journal entry row level drop down field How to write store procedure this

Former Member
0 Kudos

hi all,

let me know the process for

in journal entry row level drop down field(u_text)  How to write store procedure this field is mandatory above is the screen shot

and also when we are doing any payments like (outgoing or incoming payments)  when account type should  be onaccount / TDS this field should not activate

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this store procedure for JE row level. For payments create separate discussion.

IF @transaction_type in ('A') AND (@OBJECT_TYPE='30')

BEGIN

If exists (SELECT T0.[TransId] FROM OJDT T0  INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId WHERE T1.[U_TEST] is null and T0.[TransId] =  @list_of_cols_val_tab_del)

Begin

SET @error = 10

SET @error_message = 'Please enter UDF value'

End

End

Thanks & Regards,

Nagarajan

Answers (0)