AccountingRegisterManager.<Accounting register name>.Balance

Syntax:

Balance(<PointInTime>, <ExtraDimensionTypes>, <Filter>, <Dimensions>, <Resources>)

Parameters:

<PointInTime> (optional)

Type: Date; PointInTime; Boundary.
The point in time beginning at which balances must be gotten. If the parameter is not specified or set to Undefined, current balances will be gotten (as of the last register register record date). If Date is passed as a parameter, balances will be gotten as of the beginning of the day; if PointInTime is passed, balances will ignore register register records that occurred at that point in time.

<ExtraDimensionTypes> (optional)

Type: ChartOfCharacteristicTypesRef.; Array; FixedArray.
Reference or reference array transmitted or fixed array of values to extra dimension types. You can use extra dimensions types to specify what values of extra dimensions will be available by names "ExtDimensions1", "ExtDimensions2" etc. Besides, balances will be calculated only by accounts that have predefined types of extra dimensions. If no extra dimension types are specified, extra dimension values are addressed by order or index, as they are defined on the respective account.
The parameter does not exist unless extra dimensions were specified for the chart of accounts during configuration.

<Filter> (optional)

Type: Structure.
Structure containing a set of register dimension values for which totals must be filtered. Allowable key names: Account, ExtDimension<Number>, <Dimension name>.
If the parameter is not specified filter is not used.

<Dimensions> (optional)

Type: String; Undefined.
List of dimensions for which balances must be gotten. Line containing dimension names separated by commas. Allowable dimension names: Account, ExtDimension<Number>, <Dimension name>.
If you don't specify the parameter or set the Undefined, remainders are created for all dimensions.
Default value: Undefined.

<Resources> (optional)

Type: String; Undefined.
List of resources for which balances must be gotten. Line containing resource names separated by commas.
If you don't specify the parameter or set the Undefined, remainders are created for all resources.
Default value: Undefined.

Returned value:

Type: ValueTable.
The table contains the "BalanceDr" and "BalanceCr" fields.

Description:

Obtains balances by accounting register at specified moment. Balances are gotten in section of specified dimensions and by specified resource. Dimensions include account and extra dimension, depending on the account. If the parameter <ExtraDimensionTypes> is not specified, extra dimensions are addressed by index in the order as extra dimension types are defined on the respective account. If the parameter <ExtraDimensionTypes> is specified, balances will be calculated only for accounts for which the specified extra dimension types are defined, and extra dimension values will be addressed as specified by the parameter <ExtraDimensionTypes>.

Availability:

Server, thick client, external connection.

Note:

<ExtraDimensionTypes> parameter doesn't exist unless extra dimensions were specified for the chart of accounts during configuration.

Example:

Reg = AccountingRegisters.SelfSupporting;
Filter = New Structure("ExtDimension1,Organization,Account",
        Ref,CurOrganization,RegistrationAccountBA);
RecordSelection = Reg.Balance(DataDate,ExtDimensionTypeBM,Filter);

    

1C:Enterprise Developer's Community