Type of transactions

Set up parameters for filtering transactions.

Note
This tab is available only when you select Transactionsin the Line typefield.

Operations/Tax

Set up account types for the transactions to be reported.

Note
This tab is available only when you select Transactionsin the Line typefield.

Type of operation

Set up transaction types for filtering by voucher type.

Note
This tab is available only when you select Transactionsin the Line typefield.

Dimension

Enter information to filter transactions by financial dimensions.

Budget

Set up parameters for filtering budget-related transactions.

Note
This tab is available only when you select Budgetin the Line typefield.

Tax registers

Enter information for filtering tax-related transactions.

Note
This tab is available only when you select Registerin the Line typefield.

Constant

Set up the constant value to be used in calculations for filtering transactions.

Note
This tab is available only when you select Constantin the Line typefield.

Query

Set up the period of calculation for the query.

Note
This tab is available only when you select Function queryin the Line typefield.

Contractor

Enter information for filtering transactions for the contractorline type.

Note
This tab is available only when you select Contractorin the Line typefield.

Requisite

Set up the fixed requisite for filtering the transactions.

Note
This tab is available only when you select Fixed Requisitein the Line typefield.

Account interval

Set up the range of ledger accounts and offset accounts for which the cell operation values will be calculated during reporting.

Note
This button is activated when you select Intervalin the Account intervalor Offset intervalfield.

Edit the query

Open the Query wizardto create and set up query parameters to calculate values for cell operations for the Function querydata type.

Note
This button is activated when you select Function queryin the Line typefield.

Up

Move the selected line one position up.

Down

Move the selected line one position down.

Operator

Select the function to be applied to the calculated value from the following options:

• +

• -

• *

• /

Line type

Select the default data source for the report from the following options:

• Transactions

• Budget

• Register

• Constant

• Function query

• Contractor

• Fixed requisite

Type of operation

Select the type of operation from the following options:

• Balance– The ledger account transaction amount on a specific date.

• Credit balance– The credit ledger account transaction amount on a specific date.

• Debit balance– The debit ledger account transaction amount on a specific date.

• Turnover– The transaction amount for the ledger for the period.

• Credit activity– The credit transaction amount for the ledger for the period.

• Debit activity– The debit transaction amount for the ledger for the period.

• Turnover in correspondence– The transaction amount for the ledger in correspondence with other ledger accounts for the period.

• Turnover in correspondence Debit– The debit transaction amount for the ledger in correspondence with other ledger accounts for the period.

• Turnover in correspondence Credit– The credit transaction total for the ledger in correspondence with other ledger accounts for the period.

• Active balance (debit)– Depending on the line type selected, the following lines are calculated:

  • The balance for the ledger account across all combinations of financial dimensions. The calculated debit balances for dimensions are added; for example, the Transactionline type.

  • The active balance for the ledger account by customers, contracts, or documents; for example, the Contractorline type.

• Passive balance (credit)– Depending on the line type selected, the following lines are calculated:

  • Balance for the ledger account across all combinations of financial dimensions. The calculated debit balances for dimensions are added; for example, the Transactionline type.

  • The passive balance for ledger account by counteragents, contracts, or documents; for example, the Contractorline type.

    Note
    Active balance (debit)and Passive balance (credit)operations types are calculated differently, depending on the line type that is selected.

Balance type

Select the balance type from the following options:

• Incoming– The balance on the starting date of the period.

• Outgoing– The balance on the ending date of the period.

  Note
  This field is activated if you select Balance, Credit balance, Debit balance, Active balance (debit), or Passive balance (credit)in the Type of operationfield.

Period

Select the default voucher calculation period.

Account interval

Select to calculate the cell for one ledger account or for several ledger accounts from the following options:

• Account

• Interval

Account

Select the ledger account that the cell operation calculation will be performed for.

Note
This field is activated if you select Accountin the Account Intervalfield.

Offset interval

Select to calculate the cell for one offset account or for several offset accounts from the following options:

• Account

• Interval

Note
This field is activated when you select Turnover in correspondence, Turnover in correspondence Credit, or Turnover in correspondence Debitin the Type of operationfield.

Offset account

Select the offset account that the cell operation calculation will be performed for.

Note
This field is activated when you select Accountin the Offset intervalfield.

Transaction usage

Select the type of transactions to be taken into account when creating the report from the following options:

• All– View all transactions.

• Only reversing entry– View only reversed transactions.

• Without reversing entry– Hide reversed transactions.

Posting layer

Select the accounting type for the transactions from the following options:

• Current

• Operations

• Tax

• Operations minus tax

• Only operations

• Only tax

• Operations plus tax

• Total

• Dual warehouse

Note
This field is available on the Operations/Taxtab when you select the Transactionsin the Line typefield.

Transaction type

Select the required voucher type.

Note
This field is available on the Type of operationtab when you select the Transactionsin the Line typefield. The voucher type determines which module that the transactions will be used from when generating the report.

Dimension

Select a dimension type from the following options:

• Department

• Cost center

• Purpose

From

Select the starting code for the dimension range, whose transactions should be included in the report.

To

Select the ending code for the dimension range, whose transactions should be included in the report.

Budget model

Select the default budget model number for the report.

Register code

Select the tax calculation register code.

Register field

Select the register field name.

Data

Enter the constant value to be used in the calculation.

SQL statement

The textual representation of the query as an SQL statement.

Balance detail

Select the level of detail to use for calculating the active-passive balance, from the following options:

• Document

• Agreement

• Contractor

Fixed requisite

Select the requisite for the cell report.