Enabling trial balances details

To view historical balances in the Detail Trial Balance field, follow these one-time steps to update the debit and credit values. This report only applies to the specified currencies in the Functional and Report 1 fields.

You can view historical balances in the Detail Trial Balance field by performing these one-time steps to update the edit and credit values. This report only applies to the specified currencies in the Functional and Report 1 fields.

  1. Rebuild totals.
    1. Sign in as Administrator.
    2. Select Global Ledger.
    3. On the Utilities tab, select Rebuild Totals.
    4. After the rebuild is complete, repeat the next steps for each year.
  2. Reload and refresh cubes
    1. Sign in to the Administration Console and select the GeneralLedgerTotal cube.
    2. Click the Reload Cube button.
    3. On the Reload And Refresh tab, select a cube and click the Reload Cube button.
    4. Click OK to reload the cube now or click Schedule to schedule a recurring reload.

    See the Financials and Supply Management User and Administration Library (Cloud and On-premises).

    You can use the Trial Balance Detailed view in Financial Reporting Home, which shows total debit and credit transactions in separate columns.

    Go to Dashboards > GL Financial Reporting > Financial Reporting Home > In Core Financial Statements tab, select Summary Trial Balance. In the View options (Standard or Expanded), you can view the Summary - Detailed or Periodical – Detailed reports.