Problem with Stored Procedure

[Former Member]

Hi

I want to put restriction in Delivery Document using SBO_SP_TransactionNotification, for that I am using the following query

if @transaction_type='A' and @object_type='15'

BEGIN

IF EXISTS (select * from ODLN T1 INNER JOIN DLN1 T0 ON T1.DocEntry=T0.DocEntry where (T0.[U_LOTNO] > T0.Quantity) and T1.[DocNum]=@list_of_cols_val_tab_del)

SET @error=10

SET @error_message='Quantity should not exceed Available Quantity'

END

Please correct me, where Iam doing wrong

Thanks & Regards

Chakrapani

[Former Member · Accepted solution]

Try to change

T1.DocNum=@list_of_cols_val_tab_del

for

T1.DocEntry=@list_of_cols_val_tab_del