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:

adjustmentperiod.png
Did this answer your question?