Home Portal

Skip to end of metadata
Go to start of metadata

Once you save the report settings (even unfinished), it will be available on the Financial Reports list. You can return to the unfinished report settings at any time to create the report according to your needs.

After you have defined the basics of your report, you need to specify how to analyze and present the selected information.

  1. Depending on the selected type of report, different options are available to set.
  2. Once you selected the type of report and reported Entities, you cannot change them while editing the report definition.
NameUpdate the report's name.

Localised Name

If you want XTRF™ to display the report's local name when the system's interface language is changed (e.g. to display the English Monthly profit per Project Manager as Dochód miesięczny przypadający na Menadżera Projektu when switched to Polish), click the Add Localised Value button. Use the options in Add Localised Value pop-up window to add the localized name to the list.
CategoryUse this field to assign a category to your report - type in the category of your choice.
PreferredTick the box if you want the report to be available on the top of the selection lists, in the Preferred section.
Report Type

This field is uneditable - it shows what report type has been selected.

 

The following additional fields are available by default in each report type. 

Data TypeThis field is uneditable - it shows what was selected to be reported.

Filter Settings:


In this field you can create filters that will narrow the results of your report to the limits you set.

  1. Click the  button and use the Financial Report pop-up window to create the filters.
  2. Tick the box Show filter on generated report if you want to decide during generating the report, whether the filter should be applied or not.
  3. If you want to remove the filter, click the icon.
Columns

As the report is prepared as a table, in this field you decide what information will be analyzed in the table's columns. Use the drop-down menu that contains some default search lists to find the data you are mostly interested in.

To achieve the best report results, ensure that the data you are searching for are as close to the beginning of the selected list as possible. E.g. if you are looking for a report that will display a Country where the Contact Persons are resided, you may find on the list some interesting options, among them Contact Person, Customer, Accountancy Contact, Address, Province, Country and Contact Person, Address, Country. The better results for Country will be achieved at the second search option.

(Columns) LabelThe label for the columns of the report table is automatically given basing on your choice in the Columns field. However, you may edit it as you prefer.
(Columns) Include MissingTick the box to include in the report the search results that are missing some information, e.g. if you are looking for Provider's Address, Province and Country and the Province was not provided in some entries.
(Columns) Sort Order

You can choose one of the following options:

  • Default ascending (the first column is giving the lowest values);
  • Default descending (the first column is giving the highest values);
  • Sum ascending (the first column is the one with the lowest sum);
  • Sum descending (the first column is the one with the highest sum).

Use the drop-down menu to decide how the data will be sorted.

Rows

As the report is prepared as a table, in this field you decide what information will be analyzed in the table's rows. Use the drop-down menu that contains some default search lists to find the data you are mostly interested in.

To achieve the best search results, ensure that the data you are searching for are as close to the beginning of the selected list as possible. E.g. if you are looking for a report that will display a Country where the Contact Persons are resided, you may find on the list some interesting options, among them Contact Person, Customer, Accountancy Contact, Address, Province, Country and Contact Person, Address, Country. The better results for Country will be achieved at the second search option.

(Rows) LabelThe label for the rows is automatically given basing on your choice in the Rows field. However, you may edit it as you prefer.
(Rows) Include MissingTick the box to include in the report the search results that are missing some information, e.g. if you are looking for Provider's Address, Province and Country and the Province was not provided in some entries.
(Rows) Sort Order

You can choose one of the following options:

  • Default ascending (the first row is giving the lowest values);
  • Default descending (the first row is giving the highest values);
  • Sum ascending (the first row is the one with the lowest sum);
  • Sum descending (the first row is the one with the highest sum).

Use the drop-down menu to decide how the data will be sorted.

 

Depending on the report type and the reported data you may notice that non-standard fields are appearing in the form. Some of them, related to the selected type of report, are listed below. Fields, which are appearing when a specific filter is selected, are not mentioned here.

(Columns) SumTick the box to display additional row which will sum the values in each column.
(Rows) SumTick the box to display additional column which will sum the values in each row.
Convert to Base Currency

This field appears only in Value reports - using it you can ensure that the financial values will be displayed in the currency that was set as system default.

Tick the box to apply the setting.

Data Type BaseThis uneditable field appears only in the Relation reports - it shows what information exactly was selected for the comparison in the first Entity.
Related Data TypeThis uneditable field appears only in the Relation reports - it shows what was selected as related Entity.
Related Data Type BaseThis uneditable field appears only in the Relation reports - it shows what information exactly was selected for the comparison in the second Entity.

(Related Data Type) Filter Settings:


This field appears only in Relation reports and allows you to create filters for the second Entity.

  1. Click the  button and use the Financial Report pop-up window to create the filters.
  2. Tick the box Show filter on generated report if you want to decide during generating the report, whether the filter should be applied or not.
  3. If you want to remove the filter, click the icon.