Consolidate ALL ARM is not working when I added a new Company/Branch

It sounds like the issue is related to how the new company/branch (Canada reporting ledger) is being included in the consolidated report. Here are a few steps to troubleshoot and resolve the issue:

1. Verify the Reporting Unit Set

• Go to Finance → Ledger → Unit Set Maintenance.
• Ensure the new company/branch is included in the Consolidation Unit Set.
• Check that it has the correct parent-child hierarchy (if applicable).

2. Check the Consolidation Ledger Configuration

• Navigate to Finance → Ledgers and verify that:
  • The new Canada reporting ledger is included in the Consolidated Ledger.
  • The currency settings match the rest of the consolidation.
  • The correct Branch/Company mapping is in place.

3. Review the Row Set & Column Set (Report Definitions)

• Open the Consolidated Balance Sheet Report Definition in Report Designer.
• Ensure that the Row Set and Column Set reference all expected branches and ledgers.
• If the new entity has a different currency, check that the Currency Conversion settings are correct.

4. Verify Access Rights & Visibility

• If the report is blank or not working for the new company/branch:
  • Check User Roles and Permissions (Users & Security).
  • Make sure the reporting ledger and consolidation data are visible to your role.

5. Run the Trial Balance by Unit

• Run the Trial Balance at the unit level for each branch, including the new one.
• If the new branch does not appear, it may not be correctly linked to the unit set.

6. Check Eliminations and Adjustments

• If eliminations are configured, ensure that the new branch is accounted for correctly.
• Run a test report without eliminations to see if the data is appearing.

If the issue persists, let me know if you're receiving any specific errors or unexpected behavior when running the Consolidated (ALL) report!