Intercompany Accounts in Balance (R097011)

The Intercompany Accounts in Balance integrity report (R097011) uses information from the Account Balances table (F0902) to compare the balances among various intercompany settlement accounts within a single company. These accounts should be in balance. If they are not, the report lists the accounts, their balances, and the amount required to balance each account.

If you have multiple companies with different base currencies, do not use this integrity report to verify that intercompany accounts are in balance. This integrity report does not accommodate different base currencies.

For example, Company 70 has a balance of 50,000.00 euro (EUR) in its intercompany settlement account. Company 71 has a balance of 69,624.00 Canadian dollars (CAD) in its intercompany settlement account. The 50,000.00 EUR balance is equal to the 69,624.00 CAD balance because of the EUR to CAD exchange rate (1.39248). This integrity report establishes that the two companies are out-of-balance because it does not allow for the different base currencies.

Note: To determine whether batches within the company are out of balance, run the Company by Batch Out of Balance integrity report (R09706).

See "Understanding the Company by Batch Out of Balance Report" in the JD Edwards EnterpriseOne Applications General Accounting Implementation Guide.