Skip to Content
0
Former Member
Nov 28, 2011 at 06:20 AM

QUERY

37 Views

Dear Experts,

Following transaction notification query is of GRPO for excess qty than purchase order.

IF @Object_type = N'20' and @transaction_type = N'A'

BEGIN

declare @line int

SELECT @line = (LineNum + 1)

From PDN1

Where PDN1.DocEntry = @list_of_cols_val_tab_del

and (Quantity > BaseOpnQty)

Order by LineNum

If (not ISNULL(@line, 0) = 0)

begin

Set @error = 10

Set @error_message = N'Line quantity ' + CONVERT(nvarchar(4), @line) + N' is more then ordered !'

end

END

Because of this query, if user put excess qty than purchase order while preparing GRPO system give red alert message that qty is excess than purchase order.

I want this query for delivery also. Please make require changes in query for delivery & send me.

Regards,

Akshata