AccumulationRegisterManager.<Accumulation register name>.Balance

Syntax:

Balance(<PointInTime>, <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, 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.

<Filter> (optional)

Type: Structure.
Structure containing a set of register dimension values for which totals must be filtered. Structure key name must be the same as the register dimension name specified in the designer, and value of an element of structure - sets value selected on given dimension.
If the parameter is not specified filter is not used.

<Dimensions> (optional)

Type: String.
List of dimensions for which balances must be gotten. Line containing dimension names separated by commas.
If you don't specify the parameter or set the empty string, remainders are created for all dimensions.

<Resources> (optional)

Type: String.
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 empty line, remainders are created for all resources.
Default value: Empty string.

Returned value:

Type: ValueTable.
Created values table.

Description:

Obtains accumulation register balances for the set moment of time. You can filter data by dimension values and to obtain remainders for other dimensions. It returns a value table that contains columns with dimensions that are specified in Dimensions parameter; columns with resources specified in <Resources> parameter.

Availability:

Server, thick client, external connection, Mobile application (server).

Note:

Makes sense only for the registers with the register type "Balance" specified in the Configuration Manager.

Example:

Balance  = AccumulationRegisters.Balance;
Filter   = New Structure;
Filter.Insert("Nomenclature",SelNomenclature);
Filter.Insert("Warehouse", Selection);
BalanceTable = Balance.Balance(SelDate,Filter,
               "Nomenclature,Warehouse", "Quantity");


    

1C:Enterprise Developer's Community