Skip to Content
0
Jan 20, 2012 at 07:48 AM

Problem in StoredProcedure [dbo].[SBO_SP_TransactionNotification]

32 Views

Hi All,

I have written following query, I want to set

Delivery Quantity should be Equal or Less than Sales Order Quantity.

but it does'nt work pls reply...

IF (@transaction_type in ('A','U')) AND (@Object_type = '15')

BEGIN

IF (Select Sum(Quantity) from RDR1 where docentry=@list_of_cols_val_tab_del) >=

(Select Sum(DLN1.Quantity) from DLN1 Inner Join RDR1

ON RDR1.DOCENTRY=DLN1.BASEENTRY and RDR1.OBJTYPE=DLN1.BASETYPE

And RDR1.ItemCode=DLN1.ItemCode

Where DLN1.docentry= @list_of_cols_val_tab_del)

BEGIN

SELECT @Error = 24

SELECT @error_message = 'Delivery Quantity should be Equal or Less than Sales Order Quantity.'

END

END

Regards,

Babu Terve

Attachments

pastedImage_0.png (701.7 kB)
pastedImage_1.png (431.0 kB)