UFN_INSTALLMENT_CURRENTYEAR

Returns bit for Installments and current year or out of current year.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@FISCALYEARID	uniqueidentifier	IN
@CHECKFORIN	tinyint	IN

Definition

Copy



CREATE function dbo.UFN_INSTALLMENT_CURRENTYEAR(@REVENUEID uniqueidentifier,@FISCALYEARID uniqueidentifier,@CHECKFORIN tinyint)
returns bit
with execute as caller
as begin
    declare @retval bit = 0

    if @CHECKFORIN = 1 
        begin
            if exists(select * from dbo.INSTALLMENT join dbo.INSTALLMENTSPLIT on INSTALLMENT.ID = INSTALLMENTSPLIT.INSTALLMENTID where INSTALLMENT.REVENUEID = @REVENUEID and INSTALLMENT.DATE between (select min(startdate) from GLFISCALPERIOD where GLFISCALYEARID =@FISCALYEARID) and (select max(ENDDATE) from GLFISCALPERIOD where GLFISCALYEARID = @FISCALYEARID))
                set @retval = 1
        end                
    if @CHECKFORIN = 0
        begin
            if exists(select * from dbo.INSTALLMENT join dbo.INSTALLMENTSPLIT on INSTALLMENT.ID = INSTALLMENTSPLIT.INSTALLMENTID where INSTALLMENT.REVENUEID = @REVENUEID and INSTALLMENT.DATE not between (select min(startdate) from GLFISCALPERIOD where GLFISCALYEARID =@FISCALYEARID) and (select max(ENDDATE) from GLFISCALPERIOD where GLFISCALYEARID = @FISCALYEARID))
                set @retval = 1
        end
    return @retval

end