Skip Headers
JD Edwards World General Accounting I Guide
Release A9.3.x

E21540-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

82 Reconcile Intercompany Settlements

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.

82.1 How Does the System Keep Track of Records?

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.

82.2 Creating the Intercompany Reconciliation Table

Navigation

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

82.3 Copying the Reconciliation Table to Tape

Navigation

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

82.4 Running the Reconciliation Reports

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

82.4.1 Running the Automatic Reconciliation

Navigation

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

82.4.3 Printing the Status Report

Navigation

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.