Skip to Content
0
Former Member
Jun 27, 2009 at 11:16 AM

Problem with Stored Procedure

10 Views

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