Analyze Balances
This special drilldown extracts detailed GL balance records and presents them in a pre-formatted Excel pivot table. This report is useful for comparing time periods with each other, comparing actual, budget and encumbrance data, comparing currencies and generally for performing any analysis of the underlying general ledger balance records.
To drilldown to the Analyze Balances report using a custom layout you must use the special button for this purpose
The format of the currency and translated flag fields currently limits the effectiveness of performing a comparison between different translated, entered and converted currencies. This may be addressed in a future release.