Cube Trial Balance View

In the selection parameters of the browse, enter the cube code, year, and period or period range you want to report on. The Cube Code, the Report Year, and Report Period fields are mandatory.

The retrieved data lists opening balances, period activity (DR/CR), and closing balances in PC for the specified reporting periods and for all accounting dimensions in detail. For example, domain, entity, GL account, sub-account, cost center, project, layer, daybook, currency, intercompany, and SAFs.

If you add Summary = SUM on the amount columns and group by entity or GL, you can start analyzing the financial data. The browse CTA column contains the currency translation adjustment, which is the translation difference caused by applying different exchange rates on the Balance Sheet and Income Statement. The report cube can contain additional rows for results of previous years, CTA, and a rounding difference. As a result of these additions, each entity balanced in base currency is also balanced in presentation currency.

Cube Trial Balance View includes a Show Details option for each of the COA dimensions. If you set Show Details to Yes for a dimension, the codes for that dimension are displayed on separate lines with individual balances for each code. If you set Show Details to No for a dimension, the codes for that dimension are blank and a total balance is displayed for all codes of that dimension.

Example: You set Show GL details to Yes and Show Sub-Account details to No. Each GL account is displayed without sub-account details and balance totals are displayed for each GL account. If you then set Show Sub-Account details to Yes, each GL account and sub-account combination is displayed and balances are displayed for each combination.

You can drill down to the GL Summarized Transaction browse. This browse displays the balances in the source entities (PostingHist table) that contribute to the balance of any row in Cube Trial Balance View.