SP in Incoming Payment
I'd like to block the incoming payment being add by using SAP SP Notifications. Unfortunately the SP cannot block it, wolud you please help to check what's wrong with my SP. Here is my SP:
IF @transaction_type IN ('A','U') AND @object_type = '24' BEGIN IF EXISTS(SELECT T0.U_AcctName FROM DBO.ORCT T0 WHERE (T0.U_AcctName = '' OR T0.U_AcctName = '0') AND T0.DOCENTRY = @list_of_cols_val_tab_del) BEGIN SELECT @Error = 1, @error_message = 'Account name must not be blank' END END
Note. U_AcctName is udf in payment header
Thanks and Regards
Great. If it works then you should mark the thread answered.