ACCOUNTBEGINNINGBALANCE

Overview

The ACCOUNTBEGINNINGBALANCE function calculates the beginning or opening balance of one or more general ledger accounts, for a specific period.

Some organizations refer to this as the Period Beginning Balance or Period Opening Balance for an account.

Syntax

CODE

=ACCOUNTBEGINNINGBALANCE(
    ConnectionName, 
    Ledger, 
    AccountClass, 
    Account, 
    Subaccount, 
    Branch, 
    AsOf, 
    IncludeUnposted, 
    UseMasterFinancialCalendar
)

Arguments

The ACCOUNTBEGINNINGBALANCE function uses the following arguments

Argument	Required/Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`Ledger`	Required	Ledger to use in the calculation.
`AccountClass`	Optional, though required if `Account` is empty	The account class to use for the calculation.
`Account`	Optional, though required if `AccountClass` is empty	The general ledger account(s) to use for the calculation.
`Subaccount`	Optional	The general ledger subaccounts(s) to include.
`Branch`	Optional	The branch(es) to include.
`AsOf`	Required	The financial period, in MM-YYYY format or a reference to a cell containing a date in a valid Excel format
`IncludeUnposted`	Optional	1 - Include posted transactions only (default) 2 - Include Unposted transactions only 3 - Include Posted and Unposted transactions Transactions with a status of "On Hold" are excluded. When Unposted transactions are included, the following two statuses are included: Balanced, Unposted If a document is still in the AR module (e.g., Invoice), the corresponding GL batch has not yet been created, thus the balance for that document will not be reflected.
`UseMasterFinancialCalendar`	Optional	Use Acumatica's Master Financial Calendar instead of the financial calendar defined within the specific tenant associated with the connection being accessed (this can be useful for consolidation reports). Possible values: `TRUE` `FALSE` (default) This feature requires that your ERP license include Multi-Calendar Support and that your ERP be configured for that feature

(see our articles on Filtering Velixo Functions and using arrays or cell ranges as arguments)

Examples

Based on this data:

Example 1

CODE

=ACCOUNTBEGINNINGBALANCE(
    "Demo", 
    "ACTUAL", 
    , 
    $B6,
    ,
    , 
    $G$1
)

Description: Calculates the beginning balance of posted transactions to General Ledger account # 10200 (as noted in cell B6) as of the beginning of Period 1 for the year 2019 (as noted in cell G1).

Result: 43,925,384

Example 2

CODE

=ACCOUNTBEGINNINGBALANCE(
    "Demo", 
    "ACTUAL", 
    , 
    $B9,
    ,
    , 
    C$4, 
    3
)

Description: Calculates the beginning balance of combined posted and unposted transactions to General Ledger account #10800 (as noted in cell B9) for as of January 1, 2019 (as noted in cell C4).

Result: 4,454,986