AccumulationRegister.<Accounting register name>.BalanceAndTurnovers
Syntax
Fields
<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
End of period
Periodicity
Complement method
Condition
Description:
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) |