UFN_REVENUE_NEXTAVAILABLERECEIPTNUMBER

            CREATE function dbo.UFN_REVENUE_NEXTAVAILABLERECEIPTNUMBER()
            returns int
            with execute as caller
            as begin

                declare @NEXT int;
                --select @NEXT = max(RECEIPTNUMBER) + 1 from dbo.REVENUERECEIPT;

                select @next = dbo.UFN_REVENUE_NEXTAVAILBLEUNIQUERECEIPTNUMBER(dbo.UFN_RECEIPTSTACKINFO_GETDEFAULTRECEIPTSTACKID())

                if @NEXT is null
                    set @NEXT = 1;

                return @NEXT;
            end