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
Feedback sent
We appreciate your effort and will try to fix the article