FINANCIALPERIODOFFSET Function
Modified on Tue, 12 Sep 2023 at 07:22 AM
Applies to
- Velixo Classic
- ERP: Acumatica, CEGIC, Haufe x360, JAMIS Prime, MYOB Advanced
Description
The FINANCIALPERIODOFFSET function returns the ERP financial period (in MM-YYYY format and based on the Master Financial Calendar) that is a specific number of periods before or after the listed period.
TABLE OF CONTENTS
Syntax
FINANCIALPERIODOFFSET(Connection, Period, Offset)
Parameters
The FINANCIALPERIODOFFSET function uses the following parameters (see our article on using arrays or cell ranges as parameters):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Period | Required | The starting financial period, in MM-YYYY format |
Offset | Required | The number of financial periods to add or subtract from the starting financial period. |
Examples
Example 1
=FINANCIALPERIODOFFSET("demo","12-2019",-3)
Description
Returns the third Acumatica financial period before period 12-2019.
Result
09-2019
Example 2
=FINANCIALPERIODOFFSET("demo","09-2018",5)
Description
Returns the fifth Acumatica financial period after period 12-2018.
Result
01-2019
This function will include any adjustment periods defined within Acumatica: ![]() |
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