FINANCIALPERIOD function

Modified on Fri, 15 Sep 2023 at 04:48 PM

Applies to:

  • GL Module

  • ERP:  Acumatica, CEGIC, Haufe x360, JAMIS Prime, MYOB Advanced


Description

The FINANCIALPERIOD function returns the matching financial period for a given year and period number (as defined in the ERP's master financial calendar).



 

TABLE OF CONTENTS

 

Syntax

  FINANCIALPERIOD(Connection, Year, PeriodNumber)

 

Parameters

The FINANCIALPERIOD function uses the following parameters (see our articles on filtering techniques and using arrays or cell ranges as parameters):


Parameter

Required/Optional

Description

Connection

Required

The name of the connection, as specified in the Connection Manager

Year

Required

The year of the financial period.

PeriodNumber

Required

The period number.  A value that is lower or higher than the number of periods in the current year will yield a period that is in a different financial year.

 

Example

The following examples assume a financial year with 12 periods.


Function

Result

=FINANCIALPERIOD("Demo", "2017", 2)

02-2017

=FINANCIALPERIOD("Demo", "2017", 1)

01-2017

=FINANCIALPERIOD("Demo", "2017", 0)

12-2016

=FINANCIALPERIOD("Demo", "2017", -1)

11-2016

=FINANCIALPERIOD("Demo", "2017", 13)

01-2018

=FINANCIALPERIOD("Demo", "2017", 14)

02-2018


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 atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article