This chapter contains these topics:
Keeping track of intercompany settlements that are transmitted between a source environment and a target environment is essential for reconciliation of the intercompany journal entries.
The target company updates the Intercompany Reconciliation table and copies it to tape. The source company runs the reconciliation reports using this table.
The General Accounting system tracks the status of data through each environment using a Cross-Environment Status field (ALTT) in the Account Ledger table (F0911). This field contains a value that indicates the current status of each target data record.
The source environment updates the following status codes in the Account Ledger table:
Blank - the source environment has not run the extraction program (or the record is not a target record)
1 - a target record that the source environment has processed through the extraction program
2 - a target record that the source environment has processed through the tape creation program
The target environment updates the following status codes:
3 - a record that the target environment has processed through the Initial Receiving Facility program in detailed mode. This record exists as an unprocessed record in the Journal Entry Transactions - Batch Input table (F0911Z1).
4 - a record in the target Account Ledger and Journal Entry Transactions - Batch Input tables that has been processed through the Journal Entry Batch Processing program.
5 - a record in the target Account Ledger table that has been processed through the General Ledger Post program.
From G/L Advanced & Technical Operations (G0931), choose Intercompany Settlements
From Intercompany Settlements Processing (G09318), choose Cross-Environment Settlements
From Cross-Environment Processing (G09320), choose Reconciliation File Update
The source environment needs to reconcile source system data with the data that the target environment received and processed. The Intercompany Reconciliation table (F09492) contains data that the system uses to update the Cross-Environment Status field in the corresponding records in the source environment. Contents of this table include:
Target system records that were generated at a source environment
For each record, the current cross-environment status
A reconciliation number that the system assigned
The identifier for the source environment
An identifier for the batch run
Source and target mapping information for reports
Someone in the target environment receives intercompany settlements from a source environment by running the Initial Receiving Facility program in either detailed or summary mode. Both modes update the Cross-Environment Status field to 3. The mode determines whether the program creates the Intercompany Reconciliation table or whether you must run a separate program, as follows:
Detailed mode includes running the table creation program.
Summary mode creates the table if the corresponding processing option is set. If the processing option is not set, someone in the target company must also run the batch Reconciliation File Update program as a separate step to create the table.
The target environment can send the table to the source environment after any of the following updates:
Initial receiving
Batch processing
Posting
From G/L Advanced & Technical Operations (G0931), choose Intercompany Settlements
From Intercompany Settlements Processing (G09318), choose Cross-Environment Settlements
From Cross-Environment Processing (G09320), choose Reconciliation Tape Creation
After you create or update the reconciliation table, you send it to the source environment for use in reconciling intercompany settlements. To copy the reconciliation table to tape, run the Reconciliation Tape program. This batch program does the following:
Creates one tape for each source environment in the same run or creates a tape for only the specified source environments
Prints a report that lists each company and the number of records on the created tape
See Also:
Source environments need to reconcile all intercompany settlements, including those that are transmitted to other environments. To do this, a source environment must receive a tape containing the Intercompany Reconciliation table that was created by the target environment.
Complete the following tasks:
Run the automatic reconciliation
Print the Status Report
From G/L Advanced & Technical Operations (G0931), choose Intercompany Settlements
From Intercompany Settlements Processing (G09318), choose Cross-Environment Settlements
From Cross-Environment Processing (G09320), choose Automatic Reconciliation
The source environment uses the Intercompany Reconciliation table that was received from the target environment to run the automatic reconciliation. This batch process does the following:
Matches the records in the Intercompany Reconciliation table to the records in the Account Ledger table (F0911) based on the following fields:
Reference 1 (the unique reconciliation value for the transaction)
Reference 2 (the source system ID)
Reference 3 (the batch ID for the extraction)
Identifies differences in dates and amounts between the records that were received from the target and the matching records in the Account Ledger table.
Updates the Cross-Environment Status field in the Account Ledger table. The status of each record is updated to the status of the matching target record.
Marks as reconciled the records in the Account Ledger table that have the same dates and amounts as the matching target records.
Prints a report. This report lists the following:
Reconciled records
Records in the Intercompany Reconciliation table that do not match records in the Account Ledger table
Records in the Intercompany Reconciliation table with different dates or amounts from the matching records in the Account Ledger table
From G/L Advanced & Technical Operations (G0931), choose Intercompany Settlements
From Intercompany Settlements Processing (G09318), choose Cross-Environment Settlements
From Cross-Environment Processing (G09320), choose Status Report
Run this report to list the status of all target information in your environment.