in journal entry row level drop down field How to write store procedure this
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
Nagarajan K replied
Try this store procedure for JE row level. For payments create separate discussion.
IF @transaction_type in ('A') AND (@OBJECT_TYPE='30')
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)
SET @error = 10
SET @error_message = 'Please enter UDF value'
Thanks & Regards,