Setting up Multi-Book Reporting with Financial Management Analytics

From Spring 2020, Multi-Book Accounting is available from Accounting. This feature enables companies that trade in different countries or economic areas to produce the different sets of financial reports that are necessary to comply with different Accounting Standards, without having to make external adjustments.

Prerequisites

  • You must have enabled Multi-Booking Accounting in your org. See "Setting up Multi-Book Accounting" in the Accounting Help to learn how to do this.
  • Ensure you have assigned the Accounting - Multi Book - Read Access permission set to the integration user. For more information, see Configuring Financial Management Analytics.

Adding Multi-Book Reporting to the Financial Management Analytics Dashboards

Multi-Book Accounting enables you to create different sets of financial statements by applying Accounting Book filters to your reports.

By default, Financial Management Analytics supports Multi-Book Accounting. When you create or reconfigure a Financial Analytics App using version Summer 2020 or later, the necessary fields to support this feature are added to the Financial Balances, Financial Matching, and Financial Transactions datasets.

To use the Accounting Book fields in your dashboards after your app has been built or reconfigured, you must add the Accounting Book filter to your relevant dashboards. To do so:

Navigate to the dashboard you want to use:

  1. Click Edit to enter edit mode.
  2. Click to open the global filters panel.
  3. Click Add Global Filter.
  4. Select the Financial Balances, Financial Matching, or Financial Transactions dataset.
  5. Select "Accounting Book Name".
  6. Click Create. The new filter is now added to the global filters.
  7. Click Preview to view your changes.
  8. Click Save to save the changes to the dashboard.
  9. Click Save to confirm the changes.

You can use the Multi-Book Accounting feature within Financial Management Analytics Spring 2020 version by adding the Accounting Book field to your Financial Balances and Financial Transactions datasets.

To add this field, select Accounting Book from the available additional fields listed under question 10a in the configuration wizard. You must be using the latest release of Accounting to add the Accounting Book field. If you want to add this field to an existing app, then you must reconfigure the app.

If you add this field to these datasets, you must add the Accounting Book field as a filter on any other dashboards or financial statements that use these datasets in order to filter your data correctly. For example, if you add the Accounting Book filter to your CFO dashboards, you must also add it to your Income Statement and Balance Sheet dashboards because these dashboards all use the Financial Balances dataset.

Warning:

We recommend that you do not add the Accounting Book field to your Financial Balances and Financial Transactions datasets using the configuration wizard if you are using the Financial Statements app. You cannot filter by accounting book when using the app. If you add this field to these datasets, incorrect data will be displayed in the financial statements provided by the app.