Requires Velixo Reports 6.0.376 or higher
Description
The FINANCIALPERIODOFFSET function returns the Acumatica financial period (in MM-YYYY format) that is a specific number of periods before or after the listed period.
Syntax
FINANCIALPERIODOFFSET(Connection, Period, Offset)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. |
Example
=FINANCIALPERIODOFFSET("demo","12-2019",-3)Description
Returns the third Acumatica financial period before period 12-2019.
Result
09-2019
=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:  |