Understanding Records Created by the Refresh Consolidation Program

Refreshing consolidations creates records that are based on your setup. The records include this information:

  • Prior year-end net (APYN), prior year-end cumulative (APYC), and monthly posting information.

  • All accounts with consolidated balances.

  • Header and nonposting title accounts for reports, such as Assets.

    Important:

    You must choose a fictitious company for the consolidation. Refreshing consolidations adds records to the F0006, F0901, and F0902 tables for an entire company. If you choose an actual company for the consolidation, the system creates consolidated records for that company. Separating valid records from those created by the consolidation program is very difficult.

    After you create a consolidation, you can make adjusting entries directly to the fictitious accounts using the Journal Entry program (P0911). You must also make eliminating entries to handle intercompany settlements. When you delete a prior consolidation, adjusting entries are deleted along with consolidated balances.