Sage X3 Core Financials - Day 6 - Financial Data Extraction

Question 1

FINANCIAL DATA EXTRACTION:

Answer 1

In this Lesson, you will learn the purpose of Financial Data Extraction and understand how to use the tools available to create any financial report.

THE TOPICS IN THIS LESSON INCLUDE:

• General Overview,
• Financial Data Extraction,
• Financial Extraction Calculation,
• Financial Extraction Inquiry.

Question 2

General Overview: ( )
Path:

Answer 2

The Financial Data Extraction tool allows you to extract Data from the General Ledger, Analytical Dimensions, and Budgets.

• The parameters you define are based on the Fixed Data (eg, Account Characters, Dimensions, etc) and variables (eg. an Amount based on the result of another field)
• Execution of the Data Extraction is in a Single Mode or for a group of Reporting codes.
• There are Standard Reports (USBS and USPL); however, you can build your own report and link it to a Reporting Code or group.

Question 3

Financial Data Extraction: (GESTXS)
Path: Setup > Financials > Accounting Forms > Financial Data Extraction

Answer 3

We use: Financial Data Extraction (GESTXS) Function to define the Report Format as well as formulas for extracting amounts and Quantities.

• For Financial Data Extraction definition, you must enter a Code and Group ID.
  – You can create a New Group by entering a New Group ID or select one already created and then overriding it.
• You can run the Financial Data Extraction for either a Single Extraction Code or a Group of Codes.
• In the Ledgers Section, select the Default General and Analytical Ledgers to use.
  – These are used when defining information to filter the Data available.

SPECIAL FEATURES SECTION:
- If you have created a Specific Report Code to use with the Extraction Code, select the Report Code at the Report Code Field.
Otherwise, the System will use the Default of TXSVAL.

Question 4

Financial Extraction Calculation: (TXSGRP)
Path: Financials > Reporting > Financial Data Extraction > Calculation

Answer 4

We use: Calculation (TXSGRP) Function to perform the Data Extraction and Calculations necessary and create the Table used to view Information in the Inquiry Function.

• You can select to run the Calculation for all Extraction Codes defined for a Group or a Range at the Start and End Fields.
• You can either select to automatically generate the version for the extracted Data by selecting the Automatic version Checkbox or manually enter a version at the New Version Field.
  – You can have an unlimited number of versions created.
  – Once a version is created, you can extract and recalculate the Data for that version by selecting a Specific Version at the Version field in the List Section.
  – When recalculating for an existing version, you can choose to recalculate using the same parameters and values or select new ones.
• The number entered at the Period Shift field is to aid in the entry of preloaded dates in the Start and End fields in the Parameter Definition section.
• The List Section lists the Extraction Codes selected. For each Code, you must define parameters and variable values.
• The Variables Section displays variables and you can enter a value at the Value Column.

Question 5

Financial Extraction Inquiry: (GESTXW)
Path: Financials > Reporting > Financial Data Extraction > Inquiry

Answer 5

We use: Inquiry (GESTXW) Function to view the results of the Calculation performed for an Extraction Code and Version.

– The Extraction Codes and Version created can be selected at the Extraction Code and Version fields or from the Financial Data Extraction option in the Left List.

Question 6

Financial Extraction Inquiry Report: (TXSVAL3)
Path: Reports > Prints/Group > Financials > General Accounting > Financial Extraction Inquiry Report

Answer 6

We use: Financial Extraction Inquiry Report (TXSVAL3) Function to access the Report that was developed to provide a Landscape view of Financial Extraction Information.