AccumulationRegisterManager.<Accumulation register name>.Turnovers

Syntax:

Turnovers(<BeginOfPeriod>, <EndOfPeriod>, <Filter>, <Dimensions>, <Resources>)

Parameters:

<BeginOfPeriod> (optional)

Type: Date; PointInTime; Boundary.
The point in time beginning at which turnovers must be gotten. If the parameter is not specified, turnovers will be gotten beginning at the moment the database was created. If Date or PointInTime is transmitted as parameter, turnovers for the specified date or point in time will be included in the resulting value table.

<EndOfPeriod> (optional)

Type: Date; PointInTime; Boundary.
The point in time that defines the end of the period for which turnovers must be gotten. If the parameter is not specified, turnovers will be gotten to the very latest register register record. If Date or PointInTime is transmitted as parameter, turnovers for the specified date or point in time will be included in the resulting value table.

<Filter> (optional)

Type: Structure.
Structure containing a set of register dimension values for which turnovers 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 turnovers must be spread. Line containing dimension names separated by commas. If the parameter is not specified or an empty line is specified, turnovers will be generated for all dimensions.
Default value: Empty string.

<Resources> (optional)

Type: String.
List of resources for which turnovers must be gotten. Line containing resource names separated by commas.
If you don't specify the parameter or set the empty line, turnovers are created for all resources.
Default value: Empty string.

Returned value:

Type: ValueTable.

Description:

Obtains accumulation register turnovers for the set period of time. You can filter by dimensions values. It returns a value table that contains columns with dimensions that are specified in Dimensions parameter; two columns per each resource specified in <Resources> parameter.
Resources column names are formed in the following way: for balances registers: "<ResourceID>Receipt" and "<ResourceID>Expense"; for turnover registers: "<Resource name>".

Availability:

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

Example:

Balance  = AccumulationRegisters.Balance;
Filter   = New Structure();
Filter.Insert("Nomenclature", SelNomenclature);
Filter.Insert("Warehouse", Selection);
TurnoversTable = Balance.Turnovers(BeginDate, EndDate, Filter,
                         "Nomenclature,Warehouse", "Quantity");


    

1C:Enterprise Developer's Community