USP_GLFISCALYEAR_PRELOAD

The load procedure used by the edit dataform template "Fiscal Year Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@YEARID	nvarchar(12)	INOUT	Fiscal year
@DESCRIPTION	nvarchar(60)	INOUT	Description
@FISCALPERIODSINYEAR	tinyint	INOUT	Number of periods
@STATUSCODE	tinyint	INOUT	Status
@FISCALYEARPERIODS	xml	INOUT	Periods
@NEXTFISCALYEARID	nvarchar(12)	INOUT	Year ID
@FIRSTSTARTDATE	datetime	INOUT	First start date
@FIRSTENDDATE	datetime	INOUT	First end date

Definition

Copy



CREATE procedure dbo.USP_GLFISCALYEAR_PRELOAD
(
    @YEARID nvarchar(12) = null output,
    @DESCRIPTION nvarchar(60) = null output,
    @FISCALPERIODSINYEAR tinyint = null output,
    @STATUSCODE tinyint = null output,
    @FISCALYEARPERIODS xml = null output,
    @NEXTFISCALYEARID nvarchar(12) = null output,
    @FIRSTSTARTDATE datetime = null output,
    @FIRSTENDDATE datetime = null output
)
    as

    set nocount on;
    Declare @LastDate DateTime

    Select @LastDate=MAX(EndDate) from dbo.GLFiscalPeriod

    if not @LastDate is null
    begin
        set @LastDate=@LastDate+1
        -- set @FISCALYEARPERIODS = '<FISCALYEARPERIODS><ITEM><CLOSED>0</CLOSED><ENDDATE></ENDDATE><ID></ID><SEQUENCE>1</SEQUENCE><STARTDATE>' + CAST(@LastDate as varchar) + '</STARTDATE></ITEM></FISCALYEARPERIODS>'

    end

    /*else

    begin
        set @FISCALYEARPERIODS = '<FISCALYEARPERIODS><ITEM><CLOSED>0</CLOSED><ENDDATE></ENDDATE><ID></ID><SEQUENCE>1</SEQUENCE><STARTDATE>'+cast(getdate() as varchar) +'</STARTDATE></ITEM></FISCALYEARPERIODS>'
    end*/

    set @FIRSTSTARTDATE = @LastDate

    SET @YEARID = ''
    SET @DESCRIPTION = ''
    SET @FISCALPERIODSINYEAR = 12
    SET @STATUSCODE = 1
    SET @NEXTFISCALYEARID = ''
    return 0;