Inquiry
Use this function to:
- inquire the financial data extractions,
- or to launch the calculation for a given financial data extraction.
For a fist inquiry, you must have launched at least once the extraction calculation:
- It first generates the tables grouped together.
- It assigns 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 constituting the line, and then to the entry inquiry (account, nature and dimension inquiry).
Specific actions are authorized on this screen, especially the launching of the calculation of a financial data extraction or an export to Excel.
This inquiry is closely related to the user styles concerningthe presentation, but also the values that can be entered in the table.
The extractions available for inquiry are available in the selection panel.
Header
In this tab, enter the table data to be inquired.
In the selection panel, the extractions are sorted by group, table and version number. You can select this information by picking.
Identification
Spreadsheet (field TXSNAM) |
Code for the financial data extraction entered on a maximum of 10 characters. These extraction codes are unique irrespective of the group of reports. |
field TXSDES |
Version (field VERSION) |
This is the financial data extraction version. This code is created by launching a calculation,
It can serve, for instance, to identify the calculation for each quarter in the extraction. |
field VERDES |
Title of the version entered over a maximum of 30 characters. |
Date/time of generation
field GENDAT |
field GENTIM |
Tab Values
This tab is used to view the table results.
The first column displays the set up titles. The next columns are the ones defined during the table setup.
At this level some amounts may be simulated by directly modifying the requested amount. A user style starting with root 'TDB' can be applied to this type of action to highlight the modification. During any modification, the user is asked whether he/she wants to recalculate totals.
Example:
TDBBLUE style: ;color:#0000FF;font-weight:normal;font-style:normal, is used to highlight modifications made in blue.
It is possible to justify the recovered amounts by zooming on the details: on the required field, click 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. The Analytical detail screen is used to view the details constituting a cell.
Click on the buttons to navigate through the details of other cells (line/column navigation).
Formula / Button Information
The entered formula explains the setup details for the line/column concerned. Click on the Information icon in order to get an explicit description of the formula.
Extraction detail
Based on the context, go to the Actions icon and click on Detail from a given detail line in order to access the following inquiries:
- account inquiry,
- nature inquiry,
- dimension inquiry.
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,
- or analytical entity.
Grid Details
Line format |
Click on Line format from the Action icon at the table line start, or click on Area format from the Action icon in a table field in order to open the Print formatwindow. The data included in this window sums up the printing style effects. This data can be modified. |
Tab Parameter definition
In 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 value. You cannot modify the data included in these tables.
To relaunch an extraction, click the Calculationbutton. The window Data extraction calculation opens. It displays the extraction parameters. You can modify them here.
Grid Parameters
Grid Variables
Variable (field VARNAM) |
Value (field VARVAL) |
Description (field VARDES) |
Tab Parameters
This tab details the content used to load the fields. You cannot modify this data.
To return to the setup modification, click on Financial data extraction setup from the Actions icon in the Extraction code field of the header.
Grid Details
Tab Office documents
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 previously prepared in the corresponding function.
Grid Details
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.
If the values of extractions have been modified, check the Including the values entered box in order to consider the modified values. Note:
In this case, the calculation includes these user values in the variables and totals linked to the corresponding cell If re-zeroing is requested, the entered values are not taken into account. 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. |
Graph |
This button is used to print the graphic corresponding to the data. |
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Access to this record not possibleYou 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 between 1 and 20 columns and you have selected the entry transaction NOLIMIT 99 columns maximum.