35 Send Consolidated Balances

This chapter contains these topics:

35.1 Sending Consolidated Balances to the Target Company

Navigation

From Financial Reports (G10), choose Multi-Site Consolidations

From Multi-Site Consolidations (G1021), choose Consolidation File Control

After you have run your integrity reports, you are ready to send your consolidated balances to the target company. Once the target company receives the consolidated balances and generates and processes batch journal entries from this information, you need to update the Multi-Site Transfer Tables.

35.1.1 To Send Consolidated Balances

To send the consolidated balances to the target company, you can create a tape that contains the Multi-Site Transfer tables using the Consolidation File Control program. JD Edwards World also provides a way to plug in your own electronic transmission or tape creation program.

You can run this batch program in proof or final mode. In proof mode, the system prints a report but does not create the tape. The report shows one line for each consolidation batch and the number of records to copy to tape for that batch. The report shows an error if any records in the consolidation that you specify have already been sent to the target company.

In final mode, the system creates the tape. It also prints the report if you set the corresponding processing option.

35.1.3 Data Selection for Multi-Site Consolidation Tape Creation

Set the transmitted file status to EQ *BLANK. The system selects only the records that it has not previously sent.

35.1.4 Data Sequence for Multi-Site Consolidation Tape Creation

Set the user ID to sequence 001, the batch number to sequence 002, and the consolidation name to sequence 003. The user ID is the source system ID.

35.2 Updating the Status of the Multi-Site Transfer Tables

Navigation

From Financial Reports (G10), choose Multi-Site Consolidations

From Multi-Site Consolidations (G1021), choose Consolidation File Control

The system updates the consolidation status as part of two batch processes:

Batch Explanation
Consolidation tape creation (P1055011) At the source, the system copies consolidation records to tape. The system changes the status of the records at the source to 1. The records are created on the tape with a status of 1.
Journalize consolidated balances (P10480) At the target, the system updates the 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.

After the system creates journal entries at the target, the source company must update the corresponding records from transmission status 1 to transmission status 2. If there is a previously processed batch of corresponding records with transmission status 2, the system updates that batch to transmission status 3.

You select the consolidation name, batch, and transmission status. The system updates the Transmission File Status field on each selected record in the Multi-Site Transfer table.

The system first changes the transmission status of the previous batch of corresponding records from 2 (processed) to 3 (previously processed). Then the system changes the transmission status of the selected records from 1 to 2.

The target and source are responsible for communicating with each other when it is necessary to update the transmission status field. If the source company transmits the Multi-Site Transfer tables to the target company using a method other than tape, the source is responsible for updating the status of the records that were sent.