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.