Configuring the Balance Sheet

The balance sheet approach requires the current year net income to be included under Equity in order to balance to zero. This requires creating a shared member representing Net Income after tax under Total Equity in the balance sheet hierarchy (that is, FCCS_BalanceSheet)

For example:

  1. Create a shared member "Net Income" under Total Equity under FCCS_Balance Sheet
  2. If you are working with Hybrid application (see: Converting the Application Model to Hybrid-Optimized (DSO)) and have solve order set for intermediate parents, follow either of the below approaches to correct the issue:
    • Use intermediate parent approach
      • Create an intermediate parent member (for example, "Balance Sheet Parent")
      • Set the solve order 58 for balance sheet parent then refresh database
      • Move the "Net Assets" and "Total Equity" hierarchies under the new parent member (refer to the below screenshot)

        Balance Sheet Parent

    • Remove the solve order set on intermediate parent member
      • Set the solve order for all the members under "Income statement" and "Balance sheet" account as Zero and refresh database.
      • Refresh the smart view adhoc grid to verify the balance sheet total being balanced to zero.

Note:

As a best practice, avoid setting solve order for the members without member formula. For non member formula members, set solve order only if there is a requirement to roll up data in a certain dimension order.