AccumulationRegister.<Accounting register name>.BalanceAndTurnovers

Syntax

AccumulationRegister.<Accounting register name>.BalanceAndTurnovers

Fields

<Common attribute name>
<Dimension name>
<Resource name>ClosingBalance
<Resource name>Expense
<Resource name>OpeningBalance
<Resource name>Receipt
<Resource name>Turnover
DayPeriod
HalfYearPeriod
HourPeriod
LineNumber
MinutePeriod
MonthPeriod
Period
QuarterPeriod
Recorder
SecondPeriod
TenDaysPeriod
WeekPeriod
YearPeriod

Parameters

Beginning of period
End of period
Periodicity
Complement method
Condition

Description:

Used for obtaining turnovers and balances for a period by accumulation register. Data represent resource totals.
Only active records are used when computing totals.
The selection query outputs the periods for which balances equal zero but were turnovers even if turnovers were not requested in the given query.
Table exists for balance registers only.
Aggregation is made by dimensions, specified in query.

Example:

// Receive all balances and turnovers from the balances register
SELECT * FROM AccumulationRegister.NomenclatureRegistration.BalanceAndTurnovers()

// Receive balances and turnovers
// for specified warehouse and period
SELECT * FROM AccumulationRegister.NomenclatureRegistration.BalanceAndTurnovers(&StartPeriod, 
    &EndPeriod, , Warehouse = &StorageParameter)


    

1C:Enterprise Developer's Community