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

80 Send Intercompany Settlements

This chapter contains these topics:

After you complete the required setup for the source company, you can create journal entries for intercompany settlements across environments. No special processing is required until after you post the entries.

80.1 Overview

After you create and post intercompany settlements for other environments, you are ready to send them to the target environments.

80.1.1 Before You Begin

80.2 Creating a Table of Cross-Environment Data

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 Cross-Environment Extraction

To send intercompany settlements to other environments, you must first create a data table that contains the intercompany settlement transactions for the target company. You create this data table by running the Cross-Environment Extraction program.

Cross-Environment Extraction is a batch program. Using processing options, you can:

  • Specify a range of dates for the extraction

  • Save audit trail information

  • Run the program in either proof or final mode. Both modes produce a report.

The extraction program does the following:

  • Selects target company accounts by using a logical join table (F1011) over the Business Unit Master (F0006) and Account Master (F0901) tables

  • Reviews posted transactions in the Account Ledger table (F0911) for each selected account

  • Creates a corresponding transaction in the Journal Entry Transactions - Batch Input table (F0911Z1) for each transaction that was not previously processed by the program

The extraction program updates the fields in both the Account Ledger and Journal Entry Transactions - Batch Input tables to contain the values indicated:

Value Description
Cross-Environment Status field (ALTT) Contains code 1 to indicate that the transaction has been processed through extraction.
Explanation 2 field (EXR) Contains the key to the Account Ledger table (document, document type, company, G/L date, journal entry line number, and ledger type), if you set the corresponding processing option. If you use this field for this purpose, you cannot also use it for other information.
Reference 1 field (R1) Contains a unique reconciliation value for each transaction. The values are defined in Next Numbers (System 09, I/C Extraction) after the value for the R3 field is determined.
Reference 2 field (R2) Contains the source system ID from the Company Constants table (F0010) of the source environment. This is defined in the Source System Alias field on Company Numbers and Names.
Reference 3 field (R3) Contains the batch ID for the extraction. This ID is the same for every transaction in the batch and is defined in Next Numbers (System 09, I/C Extraction).

In addition, the extraction program updates fields in only the Journal Entry Transactions - Batch Input table to contain the values indicated:

Value Description
Subledger Contains either a blank or a concatenation of the source system ID and the source company number. The source system ID is defined in the Source System Alias field on Company Numbers and Names.
Subledger Type Contains either a blank or an X. The system updates the field with X if the subledger type was A, so that the target environment will not try to validate the Subledger field.
Business Unit Contains the target name, if defined in the Target Business Unit field on Business Units by Company.
Key Company, G/L Company Contains the target name, if defined in the Target Company field on Company Numbers and Names.
Document Type Always contains JE.
Batch Number, G/L Posted Code, Account ID, Document Number Contains blank for batch processing in the target environment.
Batch Type Always contains G.

80.3 Reviewing the Cross-Environment Data Online

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 Cross-Environment Review

To protect the integrity of intercompany settlements across environments, all changes to the journal entries must occur in the source environment. Therefore, someone in the source environment should ensure that the data is correct before sending it.

After you run the extraction program, review the extracted data online for each target company. If you find errors, you can delete the information in the target data table, correct the journal entries, and rerun the extraction. When you delete the data, the system does the following:

  • Deletes all data in the Journal Entry Transactions - Batch Input table for the selected target company. You cannot selectively delete data within a company.

  • Changes the Cross-Environment Status field to blank in the Account Ledger table for records that correspond to the records that were deleted from the Journal Entry Transactions - Batch Input table.

To review the cross-environment data online

On Cross-Environment Review

Figure 80-1 Cross-Environment Review screen

Description of Figure 80-1 follows
Description of "Figure 80-1 Cross-Environment Review screen"

  1. Use the Extraction Detail option to select the data for a target company.

  2. On Cross-Environment Extraction, review the data.

  3. To delete the data from the target data table, use the Delete action.

80.4 Copying the Cross-Environment Data 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 Cross-Environment Tape

To copy the cross-environment data to tape, run the Cross-Environment Tape program.

Cross-Environment Tape is a batch program that does the following:

  • Creates one tape for each target environment in the same run or creates a tape for only the specified target environments

  • Updates the Cross-Environment Status field (ALTT) to 2 to indicate that the program has written the transaction

  • Prints a report that lists each company and the number of records on the tape