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