Inquiry
Use this function to query financial data extractions or to launch the calculation for a given financial data extraction.
The first time you run the inquiry, you must have launched at least one extraction calculation:
- To generate the tables grouped together
- To assign a version number to each table
Prerequisite
Refer to documentation Implementation
Screen management
The inquiry is carried out on a single screen from which you can zoom to the detail of the amount on the line, and then to the entry inquiry (account, nature, and dimension inquiry).
You can launch the calculation for a financial data extraction or export to Excel.
This inquiry is closely related to the user styles for the presentation and the values that can be entered in the table.
The extractions available for inquiry are available in the selection panel.
Header
Presentation
On this tab, enter the table data for the inquiry.
In the selection panel, the extractions are sorted by group, table, and version number.
Close
Fields
The following fields are present on this tab :
Identification
|
Enter a code for the financial data extraction. There is a 10-character limit. These extraction codes are unique regardless of the report groups. |
|
|
|
This field displays the financial data extraction version. This code is created when launching a calculation:
It can serve, for example, to identify the calculation for each quarter in the extraction. |
|
Enter the version title, 30-character limit. |
Date/time of generation
|
|
|
|
Close
Tab Values
Presentation
This tab displays the results table.
The first column displays the setup titles. The next columns are those defined during the financial data extraction setup.
At this level some amounts can be simulated by directly modifying the requested amount. You can apply a custom presentation style starting with “TDB” to this type of action to highlight the modification. During any modification, you are asked if you want to recalculate totals.
Example:
To highlight modifications in blue: TDBBLUE style: ;color:#0000FF;font-weight:normal;font-style:normal
Action icon menu
You have the following options:
Click Detail to view Analytical details for the recovered amount. Depending on the context, you can view:
Account inquiry
Nature inquiry
Dimension inquiry
Click Area format to review or make changes to the print format for that field.
Click Significance to get an explicit description of the formula.
Details /Data sorting
Depending on the storage setup, the navigation can be done via the Detail section.
See the documentation on the Financial data extraction setup for further information.
The detail is always sorted by site. Then, according to the requested storages, the detail can be sorted by:
Account
Business partner
Analytical entity
Close
Fields
The following fields are present on this tab :
Grid Details
|
|
|
Click Detail from the Action icon to display the details of the cell based on the storage options defined in the Financial data extraction setup. The amounts are displayed based on the divisor and the number of decimals defined in the setup. The style and print effect are only generated during the print. The title for the column can recall the restitution currency for the amounts. This currency is displayed in brackets in the column title. Steps: 1. Go to the Financial data extraction inquiry, Parameters tab. 2. Identify the line number that corresponds to Print currency settings, for example. 3. Go back to the Financial data extraction setup, to the definition of the column title on the Definition tab. 4. Next to the title displayed, enter: %n% (n represents the line number corresponding to the print currency). This setup can be applied to any parameter such as the company code. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Close
Action icon
Area format
Click Area format from the Action icon in a table field to open the Print format window.
The data included in this window displays the printing style effects. This data can be modified.
Close
Tab Parameters
Presentation
On this tab, the Parameters and Variables tables include the extraction parameters (company, site, start and end dates, used currencies) and the variables used and their respective values. You cannot modify the data included in these tables.
To relaunch an extraction, click Calculation. The window Data extraction calculation opens. It displays the extraction parameters. You can modify them here.
Close
Fields
The following fields are present on this tab :
Grid Parameters
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Grid Variables
|
|
|
|
|
|
Close
Tab Parameters
Presentation
This tab details the content used to load the fields. You cannot modify this data.
To return to the setup modification, click Financial data extraction setup from the Actions icon in the Extraction code field of the header.
Close
Fields
The following fields are present on this tab :
Grid Details
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Close
Tab Office documents
Presentation
Use this tab to populate the financial data extraction (Code+version) by means of an Office document in Excel, Word or PowerPoint format.
Document templates can be prepared in advance.
Close
Fields
The following fields are present on this tab :
Grid Details
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Close
Reports
By default, the following reports are associated with this function :
TXSVAL : Fin data extraction inquiry
This can be changed using a different setup.
Specific Buttons
|
Unlike the Financial Data Extraction Calculation function that can mass extract data, by group of extractions, this button makes it possible to relaunch the calculation of a single extraction. The default parameters are retrieved from the extraction being consulted.
If the values of extractions have been modified, select the Including the values entered check box to consider the modified values.
If re-zeroing is requested, the entered values are not taken into account. If you do not use either option, the entered values are kept but not considered in the potential calculation of other fields. |
|
Click this button to print a graph of the data. |
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Access to this record not possible
You cannot launch the calculation because:
- The financial data extraction contains more than 20 columns and you have selected the Entry transaction LIMIT 20 columns maximum.
- The financial data extraction contains 1 to 20 columns and you have selected the Entry transaction NOLIMIT 99 columns maximum.