Skip to main content

Finance Open Balance

Opening balances are a critical part of financial reporting and analysis. In SEI, to ensure the finance cube includes accurate starting figures for each fiscal period, you must run the GL Opening Balance calculation from the GL Transaction Details data model. This process updates your cubes so that all analysis, dashboards, and reports reflect true opening balances and support reconciling activity across periods.

Benefits of finance open balance​

  • Reconciling fiscal year beginnings: Ensure the starting point for each fiscal year in your finance cube accurately reflects balances from the previous period.
  • Supporting detailed analysis: Enable accurate comparison of current and previous periods, and supports rolling-forward balances for long-term reporting.

Manage X3 Fiancial Cube data sources​

Activate the data sources​

  1. In the navigation panel, click the gear icon to open the Administration section.
  2. On the left panel, click OLAP Manager. This opens the OLAP Manager in a new window.
  3. Select X3 Financial Cube from the list. The Cube Details dialog opens on the right.
  4. In the Options panel, click the Navigation icon to expand the panel.
  5. Select Data Sources.
  6. Select X3 Open Balance (Simulated) to open the Data Source Selection panel to the right.
  7. Check the Active box and click Save.
  8. Select X3 Open Balance (Simulated) LY and repeat the same steps to activate it.

Adjust This Year Transaction data source​

  1. From the X3 Financial Cube data sources page, select X3 This Year Transactions.
  2. In the Options panel, click the Data Source icon to expand the panel.
  3. Select Edit Data Source.
  4. At the bottom of the dialog, in the Where clause, enter:
    WHERE GACCENTRY_0.CAT_0 = 1
  5. If you are using the simulated balance, remove the comment:
    /* AND GACCENTRYD_0.PER_0 > 0 */
  6. Click the Save Data Source icon to apply your changes.
  7. Click the Data Source icon to go back.

Load X3 Financial Cube​

  1. Go back to the Cubes page and select X3 Financial Cube again.
  2. In the Options panel, click the Manage icon.
  3. In the Action dropdown list, select Load All.
  4. Select the environment.
  5. Click Confirm.
  6. Close the OLAP Manager window when complete.

Run the Opening Balance calculation​

  1. In the navigation panel, select Data Models and Views.
  2. Expand the Sage X3 and Finance folders.
  3. Right-click the GL Transaction Details data model and select Execute Info Pages from the context menu.
  4. In the fields labeled From and To, enter the beginning and ending fiscal years for which you want to calculate the opening balance.
  5. Click Calculate Open Balance (SQL Server Only) or Calculate Open Balance (Oracle Only) depending on your server type.