Use this function to:

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

    SEEREFERTTO 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.

    SEEINFO This inquiry is closelyrelated 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

    Presentation

    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.

    Close

     

    Fields

    The following fields are present on this tab :

    Identification

    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,

    • by entering a free code (10 character maximum),
    • or by creating it via the sequence number counter TBD and leaving the zone blank.

    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

     

    Close

     

    Tab Values

    Presentation

    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.

    SEEREFERTTO See the documentation on theFinancial 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.

    Close

     

    Fields

    The following fields are present on this tab :

    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.
    2. Identify the line number that corresponds to the setup "Print currency", for instance.
    3. Go back to the Financial data extraction setup, on the definition of the column title in 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, 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

     

    Close

     

    Action icon

    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.

     

    Close

     

    Tab Parameter definition

    Presentation

    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.

     

    Fields

    The following fields are present on this tab :

    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

    Presentation

    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.

    Close

     

    Fields

    The following fields are present on this tab :

    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

     

    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 previously prepared in the corresponding function.

    Close

     

    Fields

    The following fields are present on this tab :

    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

     

    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.

    SEEREFERTTO See the documentation on the Extraction calculation for further information on the parameters entry.

    If the values of extractions have been modified, check the Including the values entered box in order to consider the modified values.

    SEEINFO 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.

    This button is used to export the extraction to Excel, in the form of a csv file.
    By checking the appropriate boxes, it is possible to:

    • export the column or line titles,
    • export those values entered by the user,
    • choose the location of the destination file (the #@c:\temp syntax means that the file is located in the temp directory of the C:\ local disk),
    • activate Excel.

    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 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 more than 20 columns but you have selected the entry transaction NOLIMIT 99 columns maximum.

    Tables used

    SEEREFERTTO Refer to documentation Implementation