Using the JD Edwards EnterpriseOne to PeopleSoft Enterprise General Ledger Integration

This chapter provides overviews of the export of JD Edwards EnterpriseOne General Accounting balances to the PeopleSoft Enterprise system and the structure of the F0902_OUT.txt file and discusses how to:

Export JD Edwards EnterpriseOne General Accounting balances to the PeopleSoft Enterprise system.
Import and map ChartField values in the PeopleSoft Enterprise system.

Understanding the Export of JD Edwards EnterpriseOne General Accounting Balances to the PeopleSoft Enterprise System

This table describes the process for exporting General Ledger balances from the JD Edwards EnterpriseOne system:

Table Conversion Program	Export File Name	Batch Integration Flow	PeopleSoft Enterprise Import Process	Usage
Generate Outbound Account Balances (R89F0902)	F0902_OUT.txt	E1_GLAcctBalances_To_E_GLLEDGER	Flat File Ledger Import utility	Loads account information from the JD Edwards EnterpriseOne Account Balances table (F0902) to the PeopleSoft Enterprise system.

Understanding the Structure of the F0902_OUT.txt File

The F0902_OUT.txt text file is semicolon delimited and it contains this information:

Sequence	Name	Type	Length	Comment
1	Century	Number	2	GBCTRY
2	Fiscal_Year	Number	2	GBFY
3	Account_ID	String	8	GBAID
4	Company	String	5	GBCO
5	Business_Unit	String	12	GBMCU
6	Object_Account	String	6	GBOBJ
7	Subsidiary	String	8	GBSUB
8	Ledger_Type	String	2	GBLT
9	Period_Number	Number	3	Can equal 0 for Beginning Balance (GBAPYC), or can equal 1 for Amount Net Posting 01 (GBAN01), or 2 for Amount Net Posting 02 (GBAN02), and so on.
10	Amount	Number	15	The amount values are determined by the process in relation to the value of the accounting periods, or period_Number, that you specify on the Processing Options page. If the From period equals 0 then the amount is the GBAPYC value, if the period is equal to 1, then it is equal to GBAN01, and so on. If you are posting account balances by currency, summarize all currencies into one record. All subledger/types are summarized to one record. The amount format is: -xxxx.xx
11	Base_Currency	String	3	GBCRCX
12	Target_Ledger	String	10	The specified target ledger.
13	Inter_Company	String	5	The process loads this field with the company of the address book number held in the subledger (SBL) for the intercompany settlement account.

Exporting JD Edwards EnterpriseOne General Accounting Balances to the PeopleSoft Enterprise System

This section discusses how to:

Set data selection for Generate Outbound Account Balances (R89F0902).
Set processing options for Generate Outbound Account Balances (R89F0902).
Run the Generate Outbound Account Balances program in the JD Edwards EnterpriseOne system.
Run the batch integration in the Integration Server for the General Ledger integration.

Setting Data Selection for the Generate Outbound Account Balances Program

You can set up data selection for the Generate Outbound Account Balances program (R89F0902) to select the records to be exported. You access data selection for table conversion programs in the table conversion properties.

Important! Do not use data selection to select multiple fiscal years or specify a date range that spans more than one fiscal year. You must export data for only one fiscal year at a time.

See JD Edwards EnterpriseOne Tools 8.96 Development Tools Guide: Tables and Business Views, "Converting Tables," Running Table Conversions.

Setting Processing Options for Generate Outbound Account Balances (R89F0902)

Set up processing options for the Generate Outbound Account Balances program (R89F0902) to specify the source ledger and target ledger, and other parameters that are required to produce the F0902_OUT.txt file.

1. Source Ledger Type	Specify the ledger type to be used to select data from the JD Edwards EnterpriseOne Account Balances (F0902) table. This value is appended to any report data selection that is set up on the version of the R890902 program that is being run. AA is the default value if the field is left blank.
2. Target Ledger	Specify the target ledger that is used to populate the Ledger field in the PeopleSoft Enterprise general ledger text file. The target ledger must have the same name as the source ledger.
3. From Period Number	Specify the beginning JD Edwards EnterpriseOne period to start exporting. Values are 0 to 14. If you leave this processing option blank or enter an invalid value, the system uses period 0 by default.
4. Thru Period Number (through period number)	Specify the ending JD Edwards EnterpriseOne period for exporting. Values are 0 to 14. If you leave this processing option blank or enter an invalue, the system uses period 14 by default.
5. Adjustment Period for Period 13	Specify the PeopleSoft Enterprise adjustment period to which JD Edwards EnterpriseOne period 13 balances are written. Values are from 901 to 998. If you leave this processing option blank or enter an invalue, the system uses period 998 by default.
6. Adjustment Period for Period 14	Specify the PeopleSoft Enterprise adjustment period to which JD Edwards EnterpriseOne period 14 balances are written. Values are from 901 to 998. If you leave this processing option blank or enter an invalue, the system uses period 998 by default.
7. Income Statement Balance Forward	Leave this field blank when you are using this process to integrate with PeopleSoft Enterprise General Ledger.

Note. If both adjustment period processing options are left blank, existing period 13 and 14 balances are added together by the process and written to adjustment period 998. The process looks at the date pattern of the company to determine whether it is using periods 13 and 14. If it is not, no records are written for GBAN13 and GBAN14.

Running the Generate Outbound Account Balances Program in the JD Edwards EnterpriseOne System

Select G/L Advanced & Technical Operations (G0931), Generate Outbound Account Balances.

You run table conversion programs from the Batch Versions program (P98305) in much the same way that you run other batch programs.

See JD Edwards EnterpriseOne Tools 8.96 Development Tools Guide: Tables and Business Views, "Converting Tables," Running Table Conversions.

Running the Batch Integration in the Integration Server for the General Ledger Integration

Use the Integration Server to invoke the integration package. The package contains a flow service, which loads the F0902_OUT.txt file, performs necessary data transformations, and exports a flat file that can be received by the PeopleSoft Enterprise system. The flat file is named PS_LEDGER_OUT-yyyymmdd-hhmmss.txt, where yyyymmdd is the date and hhmmss is the time.

Note. When you load the E1_GLAcctBalances_To_E_GLLEDGER package in the Integration Server, you might receive a warning message that indicates that more than one flow is registered with the same namespace. You can ignore this warning.

To run the batch integration manually, invoke this service:

Service	Navigation	Comments
convert_E1_GLAcct_To_PSLEDGER_ FileSystem89	PSFT_JD Edwards EnterpriseOne_FMS, E1_GLAcctBalances_To_E_GLLEDGER	Use this service if you are integrating with PeopleSoft Enterprise 8.9.

Note. You can test with or without inputs because this service does not use inputs.

See webMethods Integration Server Administrator's Guide 6.1, "Managing Services,” Working with Services, Testing Services.

Importing and Mapping ChartField Values in the PeopleSoft Enterprise System

This section provides an overview of processing of the PS_LEDGER_OUT-yyyymmdd-hhmmss.txt file in the PeopleSoft Enterprise system and discusses how to:

Import the PS_LEDGER_OUT-yyyymmdd-hhmmss.txt file to the target ledger in the PeopleSoft Enterprise system.
Define ChartField mapping rules in the PeopleSoft Enterprise system.
Create ChartField mapping sets in the PeopleSoft Enterprise system.
Convert the imported ledger to the second (or consolidation) PeopleSoft Enterprise ledger.

Understanding Processing of the PS_LEDGER_OUT-yyyymmdd-hhmmss.txt File in the PeopleSoft Enterprise System

The PeopleSoft Enterprise system uses the flat file import Application Engine process (GL_LED_IMPORT) to import the PS_LEDGER_OUT-yyyymmdd-hhmmss.txt flat file produced in the JD Edwards EnterpriseOne system. The process imports the data to a target ledger in the PeopleSoft Enterprise system named AA or to a target ledger with the same name as the source ledger in the JD Edwards EnterpriseOne system. The source ledger and target ledger must have the same name.

The process imports the file to the target ledger and business unit specified in the flat file that is imported.

After the flat file is imported to the target ledger, use the ChartField mapping utility in the PeopleSoft Enterprise system to map the target ledger ChartField values to the ChartField values of a second reporting (or consolidation) ledger that you must create in the PeopleSoft Enterprise system. The second ledger has ChartField values corresponding to the consolidation (or desired reporting) chart of accounts.

Note. The second (or consolidation) ledger in the PeopleSoft Enterprise system is created with the same business unit as in the target ledger that received the data from the JD Edwards EnterpriseOne system.

Pages Used to Import and Map ChartField Values in the PeopleSoft Enterprise System

Access these pages in the PeopleSoft Enterprise system:

Page Name	Object ID	Navigation	Usage
Flat File Ledger Import Request	LOAD_LED_PNL	General Ledger, Ledgers, Import Ledger from Flat File, Flat File Ledger Import, Flat File Ledger Import Request	Import a flat file ledger. The system uses the information in the flat file to determine the target ledger to which the data is imported.
ChartField Value Mapping	CF_VALUE_MAPPING	General Ledger, Consolidate Financial Data, Load Ledgers, ChartField Value Mapping	Create the ChartField mapping rules. After you have created the initial target ledger and the second (or consolidation) ledger in Enterprise, use this page to map the ChartField values from the target ledger to the values of the second, or consolidation, ledger.
ChartField Mapping Set	CF_MAPPING_SET	General Ledger, Consolidate Financial Data, Load Ledgers, ChartField Mapping Set	Define which ChartFields are associated with mapping. Tie the ChartField mapping rules to the ChartFields whose values are to be converted.
Load Ledgers Request	LED_LOAD_RQST	General Ledger, Consolidate Financial Data, Load Ledgers, Request Ledger Load, Load Ledgers Request	Convert the imported ledger to the second (or consolidation) ledger.

Import the PS_LEDGER_OUT-yyyymmdd-hhmmss.txt File to the Target Ledger in the PeopleSoft Enterprise System

Access the Flat File Ledger Import Request page.

Character Set

Select a Character Set for the flat file being imported. For example, you might specify ISO_8859-6 for Arabic or JIS_X_0208 for Japanese Kanji if the file was prepared in that character set and is imported to a ledger of the same character set.

Validate ChartFields

Select None to prevent ChartField validation. Do not use the ChartField validation process when importing to the target ledger.

Add

Click the Add button to access a browse dialog box and locate the file that is to be uploaded. This can be from a location on your company’s intranet or from your C drive on which you previously stored the flat file. In the browse dialog box, click the Upload button when you have located the file and upload it to the target ledger.

See PeopleSoft General Ledger 8.9 Implementation Guide, “Integrating and Transferring Information Among Applications.”

Defining ChartField Mapping Rules in the PeopleSoft Enterprise System

Access the ChartField Value Mapping page.

Note. In the PeopleSoft Enterprise ChartField mapping environment, the source is the ledger containing the imported data from the JD Edwards EnterpriseOne system. Also, the target is now the second (or consolidation) ledger that you create in the PeopleSoft Enterprise system to receive the newly mapped ChartField values.

Business Unit	Enter the business unit of the target ledger. This is the same business unit received from the JD Edwards EnterpriseOne system.
SetID	Enter a group identifying a set of ChartFields. Create groups corresponding to a setID that identify the set of account values in the target ledger received from the JD Edwards EnterpriseOne system.
Mapped Values	Enter multiple target values for each appropriate ChartField value in the second (or consolidation) ledger and map to them with multiple groups of source values.
Target Values	Enter a ChartField value for the second (or consolidation) ledger to which the source values derived from the target ledger received from the JD Edwards EnterpriseOne system are to be mapped.
Source Values	Enter a ChartField value or group ranges of ChartFields from the target ledger that are to be mapped to the ChartField target value in the second (or consolidation) ledger.

See PeopleSoft General Ledger 8.9 Implementation Guide, “Performing Financial Consolidations,” Mapping Dissimilar Charts of Accounts.

Creating ChartField Mapping Sets in the PeopleSoft Enterprise System

Access the ChartField Mapping Set page.

Source Record

Select Ledger Record.

Source Ledger

Enter the name of the target ledger where the data imported form JD Edwards EnterpriseOne resides.

Target Ledger

Enter the name of the second (or consolidation) ledger that you are mapping to.

See PeopleSoft General Ledger 8.9 Implementation Guide, “Performing Financial Consolidations,” Mapping Dissimilar Charts of Accounts.

Converting the Imported Ledger to the Second (or Consolidation) PeopleSoft Enterprise Ledger

Access the Load Ledgers Request page.

Business Unit

Enter the business unit of the target ledger received from the JD Edwards EnterpriseOne system.

Mapping Set

Enter the mapping set that describes the mapping from the target to the second (or consolidation) ledger.

Fiscal Year

Supply the common fiscal year of the target and second, or consolidation, ledger data.

Accounting Periods

Enter the common periods of the target and second (or consolidation) ledger. For example, 0 to 12 for the beginning balance and the 12 months for a year. You can also enter 0 to 13 for a 13 period year. If you are entering information on a quarterly basis, you could enter 0 through 3 for the first quarter, or 10 through 12 for the fourth quarter.

Include Adjustment Period(s)

Select this check box to include periods from 901 through 997 or if all adjustments are summarized, enter 998 to both boxes.

Perform Incremental Load

This field is not used in this process.

Load Unmapped Values

By default, this check box is selected. If ChartField values are unmapped (either inadvertently or intentionally) and you do not clear this check box, the system enters the unmapped values in the second (or consolidation) ledger in the existing sequence in the ChartField values of the second (or consolidation) ledger.

See PeopleSoft General Ledger 8.9 Implementation Guide, “Performing Financial Consolidations,” Using the Ledger Interface Utility.

Character Set	Select a Character Set for the flat file being imported. For example, you might specify ISO_8859-6 for Arabic or JIS_X_0208 for Japanese Kanji if the file was prepared in that character set and is imported to a ledger of the same character set.
Validate ChartFields	Select None to prevent ChartField validation. Do not use the ChartField validation process when importing to the target ledger.
Add	Click the Add button to access a browse dialog box and locate the file that is to be uploaded. This can be from a location on your company’s intranet or from your C drive on which you previously stored the flat file. In the browse dialog box, click the Upload button when you have located the file and upload it to the target ledger.

Source Record	Select Ledger Record.
Source Ledger	Enter the name of the target ledger where the data imported form JD Edwards EnterpriseOne resides.
Target Ledger	Enter the name of the second (or consolidation) ledger that you are mapping to.

Business Unit	Enter the business unit of the target ledger received from the JD Edwards EnterpriseOne system.
Mapping Set	Enter the mapping set that describes the mapping from the target to the second (or consolidation) ledger.
Fiscal Year	Supply the common fiscal year of the target and second, or consolidation, ledger data.
Accounting Periods	Enter the common periods of the target and second (or consolidation) ledger. For example, 0 to 12 for the beginning balance and the 12 months for a year. You can also enter 0 to 13 for a 13 period year. If you are entering information on a quarterly basis, you could enter 0 through 3 for the first quarter, or 10 through 12 for the fourth quarter.
Include Adjustment Period(s)	Select this check box to include periods from 901 through 997 or if all adjustments are summarized, enter 998 to both boxes.
Perform Incremental Load	This field is not used in this process.
Load Unmapped Values	By default, this check box is selected. If ChartField values are unmapped (either inadvertently or intentionally) and you do not clear this check box, the system enters the unmapped values in the second (or consolidation) ledger in the existing sequence in the ChartField values of the second (or consolidation) ledger.