Report functions
Report functions
All overviews in Exact Financials use the same report function. Report functions are almost equal to processing functions. The report function offers a flexible and broad way of selection possibilities. After selection the requested data can be printed, exported, send by e-mail or displayed on the screen. By using report layouts you can configure the displayed information and store it for reuse later on. See [Report Lay-outs].
Tab – Criteria
Selection ranges
Select the desired selection ranges and the "from ... to ..." values within these ranges. For selections on entities you enter the selection ranges by means of a search screen. See [Search screens].
Level to show/Show details/Page break levels
The fields 'Levels to show', 'Show details', 'Page break levels' are available when the concerning entity has numerical values, for example an amount. This way you are able to totalize the amounts on different levels in one overview. The levels equal the sequence of the fields in the sorting order list as defined by you.
Example 1a
Go to [Debtors, Accounts receivable]. Select the sorting order: General ledger account, Journal number, Debtor, Entry number, etc. Level 1 equals to General ledger account, level 2 equals to Journal number, level 3 equals to Debtor and level 4 equals to Entry number.
Now enter the number of levels in the field 'Levels to show' on which level you want to display the totalized amounts.
Example 1b
Now change the number level to 3. In your overview of accounts receivable you wish to see the amounts totalized on respectively year, journal number and debtor. You have the columns Year, journal number and debtor in your report layout.
Indicate in the field 'Show details' if you only want to see classified information in your overview or also the underlying lines (details) resulting in the displayed total amount.
Example 1c
You requested a report with 3 levels: Year, Journal number and Debtor. If you check the option 'Show details', you will see the individual accounts receivable leading to totalization on the different levels. For example you have a total of EUR 1000,- for debtor '1010', then the underlying accounts receivable will be displayed as well when the option is checked. So for instance three account receivable will be displayed for this debtor '1010' with amounts EUR 500,-, EUR 550,- and a credit note of EUR 50,-.
Indicate with the field 'Page break levels' on which level the report have to start with a new page, during printing.
Example 1d
Printing your list with account receivable with sorting order on year, journal number and debtor, you enter the value 2 in the field 'Page break level'. During printing of the report, the printer will continue on a new page when the value of the field journal changes.
Sorting order list
By means of the sorting order list you can arrange the fields. The upper field determines the first sorting order level. The second field determines the second sorting order level, etc. The sorting order level defines the former described totalizing levels. Also the sorting order determines the presentation of the values within the presented list. The list will be sorted ascending on first sorting order level, next on the second, etc.
Tab – Report
If you choose the presentation format 'Screen', the result of your selection will be displayed under tab 'Report'. The number, the sequence and the composition of the displayed columns can be arranged by you.
Tab - Report: Column configuration
You can configure the number, sequence and composition of the column displayed in the tab 'Report' by yourself. Place the cursor in the column field en press the right mouse button.
Default values
If you start this function for the first time, the displayed columns will be equal to the so called default values. Clicking with the right mouse button in the column (header), you will see the default values listed first. You can configure the default values with the left mouse button by indicating if the concerning field should be displayed or not.
Column configuration with option <More...>
Depending on the values you gave as selection criteria, a list with entities will be displayed. You can adjust the columns with the resulting values by yourself by clicking with the right mouse button in the column and with the option 'More...' to select the fields you want to display. After selecting the option 'More...', you can select the fields to be displayed with the buttons 'Hide' or 'Show' , or via enable or disable the checkbox in front of the description of the entity. You can link relative data of the underlying entity as well to the list. For instance in a screen for journal entry, you can select not only the linked creditor code, but the name and address linked to the creditor as well. This option can be recognized by the "+"-sign in front of the selectable entity. By clicking on the "+"-sign the underlying related fields will be shown, which you can mark to show in the list. You can determine the sequence of the list with the buttons 'Upper' and 'Lower'. Your configuration will be saved. When you start this function again with the same user name, you will see the same column configuration as it was used by you the last time.
Restore default values
If you click with the right mouse button on the column header and select the option 'Restore default values', the values as configured by Exact Financials (the default values) will be restored.
Query phrase
If you click with the right mouse button on the column header and select the option 'Query phrase', the query which is executed by the search screen will be shown.
Tab - Report: Report Lay-out Icons
For how to compose your report layouts, see [Report Lay-outs].
List with available report lay-outs
Clicking on this icon button, you will see which lay outs are available. Select with the left mouse button the report lay out you want to use for the display of your information. See [Report Lay-outs].
Save Layout
Click with the left mouse button on this icon the save the actual report lay out. See [Report Lay-outs].
Save as layout
Click with the left mouse button on this icon to save the overview you configured as report lay out. See [Report Lay-outs].
Delete Layout
Click with the left mouse button on this icon to delete the actual report lay out. See [Report Lay-outs].
Tab - Report: Drill down
Clicking with the right mouse button in the displayed report, you will see the entities you can drill down. Click with the left mouse button on the entity in the displayed selection list to open a next tab with the results of the linked entities. You can drill down on all related entities displayed in the overview. Entities which are not included in your report are not presented as option to drill down. The drill down possibility for documents is always available. Double click on the line in which the document data are displayed; the linked document will open. See [Linking documents].
Button bar
Presentation
Select the desired presentation format, by means of the 'Output' button. Depending on the user settings, the following options are available:
- Screen
- Excel
- ASCII
- CSV
- Printer
- Scheduler
- E-Mail
Cancel
The button 'Cancel' activates as soon as the results on the tab 'Report' is displayed on the screen. The button 'Cancel' will return you from the tab 'Report' back to the tab 'Criteria'. Also with this button you will return from a drill down tab to the 'Report' tab.
Exit
Press the 'Exit' button to leave the screen and to return to the main screen.
Favorites
Select the button 'Favorites' to add the menu path of the overview to the list of favorites as presented on the main screen. See [Main screen].
Help
Select the 'Help' button to consult the manual, release notes and frequently asked questions of the concerning entity.
System Manual > Content > Screen handling > Report functions
| Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
General |
Document ID: |
17.993.855 |
| Assortment: |
Exact Financials
|
Date: |
19-05-2018 |
| Release: |
|
Attachment: |
|
| Disclaimer |