Velixo recommends the use of Microsoft 365 for this feature. Experimentally, Excel 2010 or higher may be used. See the Prerequisites for additional information.

Description

The FINANCIALPERIODLIST function returns an expanded list of financial periods defined in the system, optionally bounded by the specified period boundaries.

Syntax

FINANCIALPERIODLIST(Connection, StartPeriodInclusive, EndPeriodInclusive, SortOrder)

Parameters

The FINANCIALPERIODLIST function uses the following parameters (see our article on including multiple parameter values):

Parameter	Required/Optional	Description
Connection	Required	The name of the connection, as specified in the Connection Manager
StartPeriodInclusive	Optional (may be used without EndPeriodInclusive)	The STARTING financial period, inclusive, in the MM-YYYY format
EndPeriodInclusive	Optional (may be used without StartPeriodInclusive)	The ENDING financial period, inclusive, in the MM-YYYY format.
ShouldInclude AdjustmentPeriods	Optional (default = TRUE)	TRUE / FALSE value indicating whether or not the defined adjustment periods should be included in the displayed list.
SortOrder	Optional (default = 1)	The order in which the financial periods will be listed: 1 = Ascending 2 = Descending

Examples

Example #1: Both period parameters included:

  =FINANCIALPERIODLIST("Demo", "01-2020", "12-2020", 1)

Description: Displays the Financial Periods (in ascending order) between the first and twelfth periods of the 2012 financial year (inclusive)

Result:

Example #2: No starting period

  =FINANCIALPERIODLIST("Demo", , "02-2018")

Description: Displays a list starting with the first financial period defined in the system and ending with the second financial period of 2018

Result:

Note: The adjustment period 13-2017 is included.

Example #3: Exclude adjusting period

  =FINANCIALPERIODLIST("Demo", , "02-2018", FALSE)

Description: Displays a list starting with the first financial period defined in the system and ending with the second financial period of 2018 and excluding the adjusting period.

Result:

Note: The adjustment period 13-2017 is *not* included

Example #4: No ending period

  =FINANCIALPERIODLIST("Demo", "10-2019")

Description: Displays a list starting with the tenth period of 2019 and ending with the last financial period defined in the system.

Result:

Example #5: List periods across columns

  =TRANSPOSE(FINANCIALPERIODLIST("Demo", "01-2018", "12-2018", FALSE))

Description: Use the Excel TRANSPOSE function to display the Financial Periods 01 through 12 of year 2018 across columns

Result:

Example #6: No periods included

  =FINANCIALPERIODLIST("Demo")

Description: Displays all Financial Periods defined in the system

Result: All financial periods defined in the system will be displayed

Applies to

GL Module