FINANCIALPERIODLIST function

Created by Harry Lewis, Modified on Tue, 16 Jul at 9:34 AM by Gabriel Michaud

Applies to

  • GL Module

  • ERP: Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Acumatica



Description

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


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

 


TABLE OF CONTENTS



 

Syntax

FINANCIALPERIODLIST(Connection, StartPeriodInclusive, EndPeriodInclusive, ShouldIncludeAdjustmentPeriods, SortOrder, Company)

 

Parameters

The FINANCIALPERIODLIST function uses the following parameters (see our article on filtering Velixo functions):

 

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 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

CompanyOptionalThe ID of the company whose financial calendar is to be used for determining the results.  This parameter is used when the Multiple Calendar Support feature is enabled within Acumatica. The company financial calendar of the specified company will be used. If left blank, the Master Financial Calendar will be used.

 

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) including any adjustment periods.

 

Result:

 

fin_per_both.png


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 (including adjustment periods).

 

Result:

 

fin_per_endonly.png

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:

 

fin_per_endonly_noadj.png

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:

 

fin_per_startonly.png

 

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:

 

fin_per_columns.png

 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

  

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article