Inquiry
Use this function to inquire on the financial data extractions, or to launch the calculation for a given financial data extraction.
For a first inquiry, you must have launched the extraction calculation at least once. It first generates the tables grouped together, then it assigns a version number to each table.
Prerequisite
Screen management
The inquiry is carried out on a single screen. You can zoom into the detail of the amount constituting the line, and then into the entry inquiry: account, nature and dimension inquiry.
You can perform Specific actions on this screen, such as launching the calculation of a financial data extraction or exporting to Excel.
This inquiry is closely related to your presentation styles, but also to the values that can be entered in the table.
You can find the extractions available for inquiry in the selection panel.
Header
Use this tab to enter the table data to be inquired.
In the selection panel, the extractions are sorted by group, table, and version number. You can select the information you need.
Identification
Date/time of generation
| GENDAT |
|
|
| GENTIM |
|
|
Values tab
Use this tab to view the table results.
The first column displays the setup titles. The next columns are the ones defined in the table setup.
At this level, some amounts may be simulated by directly modifying the requested amount. A user style starting with a TDB root can be applied to this type of action to highlight the modification. At any modification, you are asked if you want to recalculate totals.
Example:
TDBBLUE style: ;color:#0000FF;font-weight:normal;font-style:normal, is used to highlight modifications made in blue.
You can justify the recovered amounts by zooming into the details. To do so, from the required field, select Detail from the Actions icon. The Analytical detail screen opens.
Detail inquiry
If a detail storage is requested at extraction setup level, the amounts in each cell can be justified. Use the Analytical detail screen to view the details of a cell.
Formula / Button information
The entered formula explains the setup details for the concerned line/column. Select the Information icon to get an explicit description of the formula.
Extraction detail
Based on the context, select the Actions icon and select Detail from a given detail line to access the following inquiries:
- Account inquiry
- Nature inquiry
- Dimension inquiry
Details / Data sorting
Depending on the storage setup, you can navigate via the Detail section.
By default, the detail is always sorted by site. Depending on the requested storages, the detail can be sorted by:
- Account
- Business partner
- Analytical entity
Details grid
| Line format |
|
Select Line format from the Action icon at the table line start, or select Area format from the Action icon in a table field to open the Print format window. The data in this window sums up the printing style effects. This data can be modified. |
Parameter definition tab
In this tab, the Parameters and Variables tables include the extraction parameters, such as company, site, start and end dates, used currencies, the variables used and their respective value. You cannot modify the data included in these tables.
To relaunch an extraction, select the Calculation button. The Data extraction calculation window opens. It displays the extraction parameters. You can modify them here.
Parameters tab
This tab details the content used to load the fields. You cannot modify this data.
To return to the setup modification, select Financial data extraction setup from the Actions icon in the Extraction code field of the header.
Office documents tab
Use this tab to populate the financial data extraction, with the code and version, using an Office document in Excel, Word or PowerPoint format.
You can set up Document templates in the corresponding function.
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
|
Calculation |
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. Note - informationSee the documentation on the Extraction calculation for more information on the parameters entry.
If the values of extractions have been modified, you can verify the Including the values entered field in order to consider the modified values. In this case, the calculation includes your values in the variables and totals linked to the corresponding cell. If re-zeroing is requested, the entered values are not considered. If you do not use any of the two options, the entered values are kept but not considered in the potential calculation of other fields. |
|
Export |
Use this button to export the extraction to Excel, as a CSV file. By selecting the appropriate checkboxes, you can:
|
|
Graph |
Use this button to print the graphic corresponding to the data. |
Error messages
In addition to the generic error messages, the following message may appear on entry:
Access to this record not possible
You cannot launch the calculation in the following cases:
- The financial data extraction contains more than 20 columns but 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.