Intercompany Elimination Dataset in SuiteAnalytics
The Intercompany Elimination dataset provides detailed visibility into intercompany elimination journal entries.
Users must have permissions for both the elimination subsidiary and the source subsidiary to view their corresponding lines in the Intercompany Elimination dataset.
The dataset includes:
-
Period Filtering
By default, the dataset is filtered to display data for the first open accounting period. Use the Period filter to view elimination journal details for any period.
-
Comprehensive Journal Line Coverage
The dataset includes all elimination journal lines created in the selected period, including for Accounts Payable (AP), Accounts Receivable (AR) accounts, and other balance sheet accounts such as Other Asset and Liability.
-
Source Transaction Details
For each elimination journal line, the dataset displays the associated source transactions. Relevant information from each source transaction is included, such as:
-
Transaction amount and currency
-
Transaction base amount and base currency
-
Consolidated exchange rate
-
Source transaction data for balance sheet accounts other than Accounts Payable and Accounts Receivable is calculated in real time. If any source transaction has been modified since the last elimination run, the amounts shown in the dataset may not match the amounts in the elimination journal. To ensure consistency between source transaction amounts and elimination journal amounts, re-run the intercompany elimination process after making changes to source transactions.
The Intercompany Elimination dataset combines fields from one record type and uses one criteria filter. To edit the dataset, see Defining a Dataset.
|
Root Record Type |
Joined Record Type(s) |
Custom Formula Field(s) |
Data Grid |
Criteria Filters |
|
Month |
(none) |
(none) |
The following record fields are included in the dataset:
|
The following criteria is used to filter the dataset: Period equals to [FIRST OPEN PERIOD] |