UFN_REVENUE_NEXTAVAILBLEUNIQUERECEIPTNUMBER

CREATE function dbo.UFN_REVENUE_NEXTAVAILBLEUNIQUERECEIPTNUMBER(@RECEIPTSTACKID as uniqueidentifier = null)
returns int
with execute as caller
as begin
        declare @NEXT int;
        If @RECEIPTSTACKID is null
            set @RECEIPTSTACKID = dbo.UFN_RECEIPTSTACKINFO_GETDEFAULTRECEIPTSTACKID()

            select @NEXT = NEXTRECEIPTNUMBER  from RECEIPTSTACKINFO where ID = @RECEIPTSTACKID;

            if @NEXT is null
                set @NEXT = 1;

        return @NEXT;
end