1. General Accounting Implementation Guide
  2. Two Companies are Out of Balance by the Same Amount in the YTD Column

Two Companies are Out of Balance by the Same Amount in the YTD Column

This error appears on the report if the intercompany settlements were not set up properly, and therefore, were not created for some batches during posting. Ensure that you:

  • Research the automatic accounting instructions (AAIs) that control intercompany settlements and, if necessary, correct them.

  • Restrict the intercompany accounts to automatic journal entries (posting edit code M).

  • Verify that the Intercompany Settlements field in the general accounting constants is set to 1 or 2.

To locate the error:

  • Run the Intercompany Accounts in Balance report to locate any imbalances.

  • Run the Trial Balance by Object report or use the Trial Balance by Object inquiry form to determine the period in which the out-of-balance condition occurs.

To correct the error, create a balancing intercompany journal entry and post with the Intercompany Settlements field set to * in the general accounting constants. If this field is not set to *, the batch creates intercompany settlements, which causes the transaction for each company to net to zero and does not eliminate the out-of-balance condition. When you are finished, you must change this field back to its original setting.