Calculation Part of Financial Data Extraction

By | April 19, 2012

We have already set up an FDE in X3 we will proceed a step further i.e. to be acquainted about the Calculation part of the FDE. The below article will help you in getting an idea regarding the FDE Calculation.

FDE Calculation

Function Path:   Financials > Reporting > Financial Data Extraction > Calculation
As the name suggest this functionality will let us calculate or update the calculation of a group of tables. The parameters are entered through a single screen based on selected Report Group.

The screen is divided into five sections:

    • Selection section
    • Generation section
    • List section
    • Parameter section
    • Variables section

  1. Selection section:
    Report group: It is Field for the selection of the financial data extractions to be calculated. The selection can take place for a group, or several groups. In this case, it is necessary to leave the Report group field blank.
  2. Generation section: This section is based on versioning of the FDE Calculations.
    “Automatic Version” – Auto versioning of calculations is possible through this check box if checked or manual version entry can also be done by entering value in “New Version”.
    It is possible to recalculate FDE’s while keeping all the original parameters and to apply a shift only in terms of months. With this it is possible to automate the process of printing the monthly financial data extractions by avoiding entry of parameters.
  3. List section: The Table column presents all the tables making up the group as well as the version number to be generated if the information concerning said number has been modified manual or automatic version number.
    Simply, it shows all (or selected Extraction codes) of selected Report Group. The extraction codes are shown under column “Grid”. 
  4. Parameters section: For each Extraction code in the list, the user needs to put in list of required parameters. 
  5. Variables section:
    The values replaced by the variables can be entered in this last section. If the variable is controlled by a data type, a check will be performed on its existence. 

Batch Task Feature

The FDE Calculation function can be executed in batch mode, but no dedicated standard task is delivered to execute it. For that purpose, new Batch Task needs to be created by navigating Usage > Batch server > Task Management
No print or inquiry is linked to FDE Calculation function. For that purpose, the FDE inquiry function is used.
This blog will be further continued with the illustration of how an FDE can be used for inquiry of the financial statements.

About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at We will be glad to assist you.