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
Parameters
Examples
- Example 1
- Example 2

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: