New MonthEndEliminationDetail Dataset Exposes Intercompany Elimination Journal Lines in SuiteAnalytics

What changed

A new out-of-the-box SuiteAnalytics dataset, Intercompany Elimination, is now available. It is built on the MonthEndEliminationDetail root record type with no joined records and no custom formula fields.

Fields exposed

• Period
• Source Transaction
• Source Subsidiary
• Destination Subsidiary
• Account
• Source Transaction Amount & Currency
• Source Transaction Base Amount & Base Currency
• Consolidated Exchange Rate
• Elimination Journal
• Elimination Amount & Currency

Default filter

The dataset ships with a single criteria filter: Period equals [FIRST OPEN PERIOD]. Users can change the Period filter to view any period.

Permissions

A user must hold permissions on both the elimination subsidiary and the source subsidiary to see the corresponding lines. Rows are silently excluded when either permission is missing, so reports built on this dataset are inherently subsidiary-scoped.

Real-time caveat for non-AP/AR balance-sheet accounts

Source transaction data for balance-sheet accounts other than Accounts Payable and Accounts Receivable is calculated in real time against current transaction values, not snapshotted at elimination time. If a source transaction is edited after the last elimination run, the amounts in this dataset will reflect the current transaction values while the elimination journal retains the original amounts. This creates a visible mismatch until the elimination process is re-run.

What to do

1. Verify access. Confirm that users who need this dataset hold subsidiary-level permissions for every elimination subsidiary and every source subsidiary they need to see. Without both, rows are filtered out silently.
2. Re-run eliminations after edits. If your workflow modifies source transactions for non-AP/AR balance-sheet accounts between elimination runs, re-run the intercompany elimination process before relying on dataset amounts. AP and AR accounts are unaffected by this timing issue.
3. Build workbooks on the new dataset. The dataset can be cloned and extended via the standard SuiteAnalytics Workbook editor (Defining a Dataset). Because the root record is MonthEndEliminationDetail, you can also query it programmatically with N/query if you need to pull elimination data into SuiteScript automations or integrations.
4. Audit existing saved searches. If you have custom saved searches or scripts that reconstruct elimination detail from journal-entry records, evaluate whether this dataset can replace that logic and reduce maintenance overhead.