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
| Description (field INTIT) |
| field AMTVAL1 |
|
The Detail action menu displays the details of the cell based on the storage options defined in the setup of the Financial data extraction. The amount are displayed taking into account 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 will be displayed between brackets in the column title. Steps: 1. Go to the financial data extraction inquiry, in the Parameters tab. This setup can be applied to any parameter, for example, the company code. |
| field AMTVAL2 |
| field AMTVAL3 |
| field AMTVAL4 |
| field AMTVAL5 |
| field AMTVAL6 |
| field AMTVAL7 |
| field AMTVAL8 |
| field AMTVAL9 |
| field AMTVAL10 |
| field AMTVAL11 |
| field AMTVAL12 |
| field AMTVAL13 |
| field AMTVAL14 |
| field AMTVAL15 |
| field AMTVAL16 |
| field AMTVAL17 |
| field AMTVAL18 |
| field AMTVAL19 |
| field AMTVAL20 |
| 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
| field COL0 |
| field COL1 |
| field COL2 |
| field COL3 |
| field COL4 |
| field COL5 |
| field COL6 |
| field COL7 |
| field COL8 |
| field COL9 |
| field COL10 |
| field COL11 |
| field COL12 |
| field COL13 |
| field COL14 |
| field COL15 |
| field COL16 |
| field COL17 |
| field COL18 |
| field COL19 |
| field COL20 |
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
| Description (field FRM0) |
| field FRM1 |
| field FRM2 |
| field FRM3 |
| field FRM4 |
| field FRM5 |
| field FRM6 |
| field FRM7 |
| field FRM8 |
| field FRM9 |
| field FRM10 |
| field FRM11 |
| field FRM12 |
| field FRM13 |
| field FRM14 |
| field FRM15 |
| field FRM16 |
| field FRM17 |
| field FRM18 |
| field FRM19 |
| field FRM20 |
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
| Description (field FRM0) |
| field FRM1 |
| field FRM2 |
| field FRM3 |
| field FRM4 |
| field FRM5 |
| field FRM6 |
| field FRM7 |
| field FRM8 |
| field FRM9 |
| field FRM10 |
| field FRM11 |
| field FRM12 |
| field FRM13 |
| field FRM14 |
| field FRM15 |
| field FRM16 |
| field FRM17 |
| field FRM18 |
| field FRM19 |
| field FRM20 |
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.
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.