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