AccountingRegisterManager.<Accounting register name>.Turnovers

Syntax:

Turnovers(<BeginOfPeriod>, <EndOfPeriod>, <ExtraDimensionTypes>, <TypesOfExtraDimension>, <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.

<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, turnovers 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.

<TypesOfExtraDimension> (optional)

Type: ChartOfCharacteristicTypesRef.; Array; FixedArray.
Reference or reference array transmitted or fixed array of values to extra dimension types. Types of correspondent extra dimensions are used to specify what values of correspondent extra dimensions will be available by names "BalancedExtDimension1", "BalancedExtDimension2" etc. Besides, turnovers will be calculated only by correspondent accounts that have predefined types of correspondent extra dimensions. If types of correspondent extra dimensions are not specified correspondent extra dimensions values are addressed by order (index) in which they are defined at a corresponding account.
Important: This is meaningful only for an accounting register with correspondent support. For a register without correspondence, the parameter does not exist.
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>, BalancedAccount, BalancedExtDimension<Number>, <Dimension name>Balanced (nonbalanced dimensions only).
If the parameter is not specified filter is not used.

<Dimensions> (optional)

Type: String; Undefined.
List of dimensions for which turnovers must be gotten. Line containing dimension names separated by commas. Allowable dimension names: Account, ExtDimension<Number>, <Dimension name>, BalancedAccount, BalancedExtDimension<Number>, <Dimension name>Balanced.
If the parameter is not specified or an Undefined is specified, turnovers will be generated for all dimensions.
Default value: Undefined.

<Resources> (optional)

Type: String; Undefined.
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 Undefined, turnovers are created for all resources.
Default value: Undefined.

Returned value:

Type: ValueTable.
The table contains the "TurnoverDr" and "TurnoverCr" fields.

Description:

Obtains turnovers by accounting register at specified moment. Turnovers are gotten in section of specified dimensions and by specified resources. Dimensions include account, extra dimension, dimensions, corr. acct., balanced extra dimension, corr. dimensions.

Availability:

Server, thick client, external connection.

Note:

"Extra dimension types" and "Types of extra dimension" parameters don't exist unless extra dimensions were specified for the chart of accounts during configuration.

    

1C:Enterprise Developer's Community