Understanding the Consolidation Console Program

Whether you are sending a consolidation to a target company or receiving a consolidation from a source company, you need to monitor the consolidation's status. The Consolidation Console program (P10610) enables you to:

  • Monitor the transmission status of the consolidation.

  • Monitor integrity reports.

  • Send consolidated balances to the target company.

  • Delete previously processed consolidations.

Both the source company and the target company need to track the consolidations that have been sent from source to target and the consolidations that have been processed at the target. The system maintains the status of each consolidation name and batch in the F1001, F1002, and F1003 tables. These tables exist at both the source and target sites.

Review the possible statuses in the Transmission File Status field:

  • Blank: Not transmitted.

  • P: Pending.

    The system is in the process of transmitting.

  • 1:

    In the source table: Transmitted

    In the target table: Received.

  • 2:

    Processed.

  • 3:

    Previously processed.

This table lists the updates that the system makes to the consolidation status during these processes:

Process

Updates to Status

MSC Data Transmission (R10610)

At the source, the system copies consolidation records to the target. The system changes the transmission status of the records at the source to 1. The records are created at the target with a status of 1.

Journalize Consolidated Balances (R10480)

At the target, the system updates the transmission status of the consolidation records to 2 when it creates journal entries. It also updates previously processed records with a status of 2 to 3 at the target site.

The target is responsible for communicating with the source after the target runs the batch process to create journal entries at the target. The source must manually update the corresponding records from transmission status 1 to transmission status 2. If a previously processed batch of corresponding records has a transmission status 2, the system updates that batch to transmission status 3.

The Consolidation Console program also identifies the integrity reports that you are required to run at the source and target sites, based on the processing options that you set. The program indicates whether integrity reports have been run, and whether the integrity reports passed or failed. This information appears in the Integrity Status fields in the detail area.

Review the possible values in the Integrity Status field:

  • Blank:

    Integrity not run.

  • 0:

    Integrity not run.

  • 1:

    Integrity passed.

  • 2:

    Integrity failed.

  • 9:

    Override; transmit regardless of integrity status.

When you are ready to send the consolidated balances to the target company, the Consolidation Console program enables you to send the information.

The system holds the consolidated account balances in the F1001, F1002, and F1003 tables until you delete them. Whether you are at a source or target site, you should delete these records periodically.