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.
I just want to understand why there’s such a difference. Is there a specific filter, field, or setup that needs to be used in SuiteAnalytics to get it to match the standard Trial Balance? Or is it simply not possible to customise a SuiteAnalytics workbook to replicate the exact figures from the standard Trial Balance report?
SuiteAnalytics workbook:
Trial Balance report: