Intercompany Transactions in Odoo 19:
Invoices, Payments & Consolidation

# Navigate to: Settings > Users & Companies > Users
# For each user involved in intercompany workflows:

1. Open the user record
2. Under "Allowed Companies", add BOTH entities
   - Example: "Acme Holdings Ltd" + "Acme Retail Inc"
3. Set "Default Company" to their primary entity
4. Ensure they have "Billing" or "Invoicing" access
   in BOTH companies

# Critical: The intercompany bot user (if configured)
# must have access to ALL companies in the group.

# When creating a new company, assign the same chart template:
# Settings > Companies > Create
# Under "Accounting" tab:
#   Chart of Accounts Package: select the SAME template
#   as your parent company

# For existing companies that need alignment:
# Option A: Re-install the chart (WARNING: destructive)
# Option B: Manually map accounts (safer)

# Verify account alignment across companies:
from odoo import api, SUPERUSER_ID

env = api.Environment(cr, SUPERUSER_ID, {})
companies = env["res.company"].search([])

for company in companies:
    accounts = env["account.account"].with_company(company).search([])
    print(f"\n{{company.name}}: {{len(accounts)}} accounts")
    for acc in accounts.filtered(lambda a: a.account_type == "income"):
        print(f"  {{acc.code}} - {{acc.name}}")

from odoo import fields, models


class AccountAccount(models.Model):
    _inherit = "account.account"

    x_group_account_code = fields.Char(
        string="Group Account Code",
        help="Maps this local account to the group-level "
             "chart for consolidated reporting.",
        index=True,
    )
    x_group_account_name = fields.Char(
        string="Group Account Name",
    )


# Usage in consolidation reports:
# SELECT x_group_account_code, SUM(balance)
# FROM account_move_line
# JOIN account_account ON ...
# GROUP BY x_group_account_code

# Method 1: Native multi-company report view
# Accounting > Reporting > Profit and Loss
# In the report header, click the company selector
# Select ALL companies in your group
# Odoo merges the data into a single report

# Method 2: Custom SQL view for consolidated reporting
# Useful when you need group-level account mapping

CREATE OR REPLACE VIEW consolidated_trial_balance AS
SELECT
    COALESCE(aa.x_group_account_code, aa.code) AS group_code,
    COALESCE(aa.x_group_account_name, aa.name) AS group_name,
    SUM(aml.debit) AS total_debit,
    SUM(aml.credit) AS total_credit,
    SUM(aml.balance) AS net_balance,
    rc.name AS company_name
FROM account_move_line aml
JOIN account_account aa ON aa.id = aml.account_id
JOIN account_move am ON am.id = aml.move_id
JOIN res_company rc ON rc.id = aml.company_id
WHERE am.state = 'posted'
  AND aml.date BETWEEN '2026-01-01' AND '2026-03-31'
GROUP BY
    COALESCE(aa.x_group_account_code, aa.code),
    COALESCE(aa.x_group_account_name, aa.name),
    rc.name
ORDER BY group_code;

-- Find intercompany balance mismatches
WITH ic_balances AS (
    SELECT
        rc.name AS source_company,
        rp.name AS counterparty,
        aa.account_type,
        SUM(aml.balance) AS balance
    FROM account_move_line aml
    JOIN account_account aa ON aa.id = aml.account_id
    JOIN account_move am ON am.id = aml.move_id
    JOIN res_company rc ON rc.id = aml.company_id
    JOIN res_partner rp ON rp.id = aml.partner_id
    WHERE am.state = 'posted'
      AND aa.code LIKE '1311%' OR aa.code LIKE '2311%'
      AND rp.company_id IS NOT NULL  -- intercompany partner
    GROUP BY rc.name, rp.name, aa.account_type
)
SELECT
    a.source_company,
    a.counterparty,
    a.balance AS "A owes/owed",
    b.balance AS "B owes/owed",
    a.balance + COALESCE(b.balance, 0) AS discrepancy
FROM ic_balances a
LEFT JOIN ic_balances b
    ON a.source_company = b.counterparty
    AND a.counterparty = b.source_company
WHERE ABS(a.balance + COALESCE(b.balance, 0)) > 0.01
ORDER BY ABS(a.balance + COALESCE(b.balance, 0)) DESC;