Consolidated amounts - SuiteAnalytics report

Hi,

There’s a SuiteAnalytics workbook that was created called “Trial Balance by Period”, using the pivot table “Consol TB by Period.” The issue is that the Amount field doesn’t seem to be showing the correct consolidated amount for the period.

For example, in the SuiteAnalytics workbook, account 101110 – Zako is showing 582,569,001.74. But if I run the standard Trial Balance report under Reports > Financial > Trial Balance, select Consolidated as the subsidiary context, and use February 2024 as the “As of” date, the amount for the same account is R653,920,803.12.

I’ve tried playing around with the filters and adding different amount fields to the workbook, but I can’t seem to get the figures to tie back to the standard Trial Balance.