Overview

View a list of all of the reports that are set up.

General

Enter the basic parameters for report generation.

Type of transactions

Enter parameters for filtering transactions.

Reversing entry

Enter information for filtering transactions on the basis of reversing.

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

Type of operation

Enter information for filtering transactions by voucher type.

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

Operations/Tax

Enter information for filtering transactions by accounting type.

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

Dimension

Enter information to filter transactions by financial dimensions.

Open

View the template and validate the template cell setup.

Setup

Open the Field setupform to create cells.

Functions

• Copy– Open the Financial reports generator parameters copyingform to copy a cell, all of its settings, and cell operations from any report for any company into the current report.

• Create financial report lines– Open the Create or update FRG linesform to create or update the financial report.

Report code

Enter the report code.

Description

Enter a text description for the report.

Template

Select the document template.

Currency

Select the currency in which the report is created from the following options:

• Base currency– All of the data in the report is presented in the company's default currency.

• Secondary currency– All of the data in the report is presented in the company's secondary currency.

Period

Select the default voucher calculation period.

Data

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

• Transactions

• Budget

• Register

• Constant

• Function query

• Contractor

• Fixed requisite

Budget model

Select the default budget model number.

Note
This field is activated when you select Budgetin the Datafield.

Output to

Select the template type from the following options:

• Microsoft Office Word

• Microsoft Office Excel

File name

Select the template file path.

Note
Any user with rights to access the financial reports generator can generate a report and then save the template in a shared network folder. However, if the template is saved in the user's local folder, the report can only be generated from the user's workstation.

Factor

Enter the value that the report data is divided by.

Fractional part

Enter the number of decimal places entered into the report being generated.

Transaction usage

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

• All– View all transactions.

• Only reversing entry– View reverse transactions.

• Without reversing entry– Hide reverse transactions.

Transaction type

Select the required voucher type.

Note
The voucher type determines which module's transactions are used in generating the report.

Posting layer

Select the correct accounting type from the following options:

• Current

• Operations

• Tax

• Operations minus tax

• Only operations

• Only tax

• Operations plus tax

• Total

• Dual warehouse

Dimension

Select the correct 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.