Eliminations by Company Report
This guide provides instructions for creating an eliminations by company report, by copying the consolidated trial balance standard report.
Below is an example of the output from the report:
To create this report, make a copy of the consolidated trial balance report (standard composite report), and add the repeating column feature to all three columns (by company, elims, and total). Screen shots of the repeating column feature are shown below:
Configuration Catalog Specifics
Refer to the Configuration Catalog Guide for additional information.
| Out of the Box? | Yes, you can choose to modify the reports to better fit your use case as discussed above or they can be used as is with no further modification. | |
| Technology | Composite and Matrix Reports | |
| Functional Area | Financial Accounting | |
| Customer Central Package | RPT Consolidations | |
| WD Version | Tested on 2020R2 | |
| Complexity | Low to Medium | |
| How do I get this? | Details on getting content into tenant here | |
| Prerequisites (also called out in the Configuration Package Description) | Account Set: Standard Account Translation Rule Set called: Standard Fiscal Schedule ID: YE_DEC Ledger Type: Actuals Account Set ID: Standard Currency Rate Type ID: Current | |
The customer central package listed above ties to the name of the Configuration Catalog package where the corresponding report is located. Once loaded into your tenant, you can find the reports in the table using a Report Tag that matches the Customer Central name. For more reports within the package, see RPT Consolidations.
| Custom Report | Data Source and Data Source Filter | Prerequisites |
| Consolidated Trial Balance - Eliminations by Company | Journal Lines for Financial Reporting Journal Lines for Company and Reporting Time Period | Reports: Financial Accounting |
| Sub Report - Consolidated Trial Balance - Eliminations by Company - Journal Lines Translated Summary | Journal Lines for Financial Reporting Journal Lines for Company and Reporting Time Period | Reports: Financial Accounting |
| Sub Report - Consolidated Trial Balance - Eliminations by Company - Journal Line Eliminations | Journal Lines for Financial Reporting Journal Lines for Company and Reporting Time Period | Reports: Financial Accounting |
| Sub Report - Consolidated Trial Balance - Eliminations by Company - Journal Lines Translated | Journal Lines for Financial Reporting Journal Lines for Company and Reporting Time Period | Reports: Financial Accounting |
Consolidated Trial Balance Eliminations by Company
- Filename
- Consolidated_Trial_Balance_-_Eliminations_by_Company_0.pdf
- Size
- 151 KB
- Format
- application/pdf
Sub Report Consolidated Trial Balance Eliminations by Company Journal Lines Translated Summary
- Filename
- Sub_Report_-_Consolidated_Trial_Balance_-_Eliminations_by_Company_-_Journal_Lines_Translated_Summary_0.pdf
- Size
- 100 KB
- Format
- application/pdf
Sub Report Consolidated Trial Balance Eliminations by Company Journal Line Eliminations
- Filename
- Sub_Report_-_Consolidated_Trial_Balance_-_Eliminations_by_Company_-_Journal_Line_Eliminations_0.pdf
- Size
- 100 KB
- Format
- application/pdf
Sub Report Consolidated Trial Balance Eliminations by Company Journal Lines Translated
- Filename
- Sub_Report_-_Consolidated_Trial_Balance_-_Eliminations_by_Company_-_Journal_Lines_Translated_0.pdf
- Size
- 100 KB
- Format
- application/pdf