Using the Compte de Résultat de l'Exercice Dashboard

Note:

This dashboard requires your corporate chart of accounts to be France. To view this dashboard correctly, with all GLAs mapped to their respective reporting categories, you must go to General Ledger Accounts in Accounting and ensure there are local balance sheet and local balance sheet order values defined for all GLAs.

The Compte de Résultat de l'Exercice dashboard enables you to run your profit and loss reports in Financial Statements and view the resulting data within the dashboard. This dashboard uses the Financial Transactions dataset and contains:

  • Prompts: filter by company, currency, year, and period.
  • Drill down: select any row in the Exercice Sélectionné or Exercice Précédent column and click Voire Détails >. To return to the previous view click < Compte de Résultat. This enables you to view an analysis of the individual transactions which sum the total values in that row. This functionality is not available for the rows listed in the "Drill Limitations" section below. If you attempt to drill these rows, a "No Results Found" message is displayed.

To filter the report data:

  1. Use the Enterprise drop-down to select the company you want to see data for.
  2. Use the Devise drop-down to select between home (Locale) or dual (Du Groupe) currency.
  3. Use the Année drop-down to select the year you want to see data for. Whichever year you choose, the previous year is displayed in the next column.
  4. Use the Période drop-down to select a period.
  5. Use the Période d'Ajustement 100 drop-down to select if you want to include or exclude period 100. For a definition of the special periods, see Financial Balances Fields.

Adding GLAs Manually

If you create GLAs manually, you must ensure that your GLA names have a space between the Reporting Code and the GLA name. For example, use "100 Capital", not "100Capital".

Even if your GLAs were loaded automatically using Chart of Accounts Localization, if you want to create a new GLA manually, you must follow the format indicated.

Other suitable examples are:

  • 100 - Capital
  • 100 . Capital

Do not use:

  • 100-Capital
  • 100.Capital

Drill Limitations

The following rows cannot be drilled:

  • BÉNÉFICE OU PERTE
  • Chiffres d'affaires nets
  • RÉSULTAT D'EXPLOITATION
  • RÉSULTAT EXCEPTIONNEL
  • RÉSULTAT FINANCIER
  • RÉSULTATCOURANTAVANTIMPÔTS
  • TOTAL DES CHARGES
  • Total des charges d'exploitation
  • Total des charges exceptionnelles
  • Total des charges financières
  • TOTAL DES PRODUITS
  • Total des produits d'exploitation
  • Total des produits exceptionnels
  • Total des produits financiers