Using the PeopleSoft Enterprise Payroll to JD Edwards EnterpriseOne General Ledger Integration

This chapter provides an overview of the posting of accounting lines and discusses how to:

Retrieve currency exchange rates.
Prepare and post accounting lines from PeopleSoft Enterprise payroll applications to JD Edwards EnterpriseOne General Ledger.
Process PeopleSoft Enterprise payroll data in JD Edwards EnterpriseOne General Ledger.

Understanding the Posting of Accounting Lines

After you process payroll in the PeopleSoft Enterprise payroll application, you can create the accounting lines and post them as journal entries to JD Edwards EnterpriseOne General Ledger. A journal entry typically consists of header and line data.

You must first synchronize the market exchange rates between the financials system and the payroll system if your data involves multiple currencies.

The posting framework posts summary GL transactions grouped by GL business unit (Business_Unit_GL). As part of the posting, an Application Engine process prepares the data, creates the message, and publishes to the node that is specified for the GL business unit.

The Integration Server loads the data into the JD Edwards EnterpriseOne Journal Entry Transactions - Batch File table (F0911Z1). The Integration Server sends a reply message stating whether the transactions sent by the PeopleSoft Enterprise system were successfully posted and loaded into the F0911Z1 table.

After the data has been loaded into the F0911Z1 table, you run a batch process to validate the data and to insert the records into the Account Ledger table (F0911). You then post the transactions from the F0911 table to the Account Balances table (F0902) just as you would post any other transactions.

If the payroll transactions contain errors in the data, you can:

Manually correct errors in the F0911Z1 table before loading transactions to the F0911 table.
Purge the F0911Z1 table before loading transactions to the F0911 table, then reset and rerun the PeopleSoft Enterprise Payroll for North America or PeopleSoft Enterprise Global Payroll process to post the transactions to JD Edwards EnterpriseOne General Ledger.

See Handling Data Errors in Batch Posting.

Retrieving Currency Exchange Rates

Currency market rates must be synchronized between the PeopleSoft Enterprise payroll systems and the JD Edwards EnterpriseOne financial system, which is the master for market rates.

This task is documented in the PeopleSoft Enterprise Payroll for North America 8.9 Implementation Guide and in the PeopleSoft Enterprise Global Payroll 8.9 Implementation Guide.

See PeopleSoft Enterprise Payroll for North America 8.9 Implementation Guide, “Administering the Integration with JD Edwards EnterpriseOne General Ledger,” Retrieving Currency Exchange Rates.

See PeopleSoft Enterprise Global Payroll 8.9 Implementation Guide, “Integrating with JD Edwards EnterpriseOne General Ledger,” Retrieving Currency Exchange Rates.

Preparing and Posting Accounting Lines from PeopleSoft Enterprise Payroll Applications to JD Edwards EnterpriseOne General Ledger

The process of preparing and posting accounting lines is documented in the PeopleSoft Enterprise Global Payroll 8.9 Implementation Guide.

See PeopleSoft Enterprise Global Payroll 8.9 Implementation Guide, “Integrating with JD Edwards EnterpriseOne General Ledger,” Preparing and Posting Accounting Lines from PeopleSoft Enterprise Global Payroll to General Ledger.

Processing PeopleSoft Enterprise Payroll Data in JD Edwards EnterpriseOne General Ledger

This section provides an overview of the JD Edwards EnterpriseOne General Ledger process for PeopleSoft Enterprise payroll transactions and discusses how to:

Locate payroll batch transactions in the JD Edwards EnterpriseOne system.
Review and revise payroll batch transactions in the JD Edwards EnterpriseOne system.
Set processing options for Journal Entries Batch Processor (R09110Z).
Run the Journal Entries Batch Processor (R09110Z).
Process PeopleSoft Enterprise payroll batch transactions in the JD Edwards EnterpriseOne system.
Post JD Edwards EnterpriseOne journal entries.

Understanding the JD Edwards EnterpriseOne General Ledger Process for PeopleSoft Enterprise Payroll Transactions

When you post accounting lines from PeopleSoft Enterprise Payroll for North America or PeopleSoft Enterprise Global Payroll, the PeopleSoft Enterprise system publishes a message with the payroll information needed to create journal entries in JD Edwards EnterpriseOne General Ledger. These journal entries are in summary rather than detail form.

The Integration Server transforms the message data and inserts the transaction information in the Journal Entry Transactions - Batch File table (F0911Z1). If any errors occur during the table insert, the process is canceled and no data is uploaded to the F0911Z1 table. If the insert is successful, the Integration Server returns a reply status message to the PeopleSoft Enterprise system.

After payroll transaction data has been successfully inserted in the F0911Z1 table, you run the Journal Entries Batch Processor program (R09110Z) to validate and load the transactions into the Account Ledger table (F0911). You then run the General Ledger Post program (R09801) to post the transactions from the F0911 table to the Account Balances table (F0902).

Forms Used to Process PeopleSoft Enterprise Payroll Data in JD Edwards EnterpriseOne General Ledger

Form Name	FormID	Navigation	Usage
Work With Store & Forward Journal Entries	W0911Z1B	Batch Journal Entry Processing (G09311), Journal Entry Revisions	Locate and review records in the Journal Entry Transactions - Batch File table (F0911Z1).
Store & Forward Journal Entry Revisions	W0911Z1A	Locate a record and click Select on the Work With Store & Forward Journal Entries form.	Review and revise detail information for records in the F0911Z1 table.
Work With Journal Entries	W0911I	Journal Entry, Reports, & Inquiries (G0911), Journal Entry	Add, change, delete, or review records in the F0911 table.

Locating Payroll Batch Transactions in the JD Edwards EnterpriseOne System

Access the Work With Store & Forward Journal Entries form.

Batch Number

Enter a unique number in the JD Edwards EnterpriseOne system that consists of the prefix HCM followed by a unique number generated by Next Numbers for system 00, line 6.

Transaction Number

Enter the process instance from the PeopleSoft Enterprise system.

SP (successfully processed)

This field is set to 0 when the transactions are inserted in the Journal Entry Transactions - Batch File table (F0911Z1), indicating that the transactions have not been written to the Account Ledger table (F0911).

User ID

Enter the JD Edwards EnterpriseOne user ID from the Family, Financials, PPI, User ID integration option. This should identify the user who is responsible for performing the import of PeopleSoft Enterprise payroll data into the F0911Z1 table.

Reviewing and Revising Payroll Batch Transactions in the JD Edwards EnterpriseOne System

Access the Store & Forward Journal Entry Revisions form.

Doc Type (document type)

Enter the document type from the Family, Financials, PPI, Document Type integration option. The default document type for payroll transactions is TJ.

Ledger Type

For transactions that originate in PeopleSoft Enterprise payroll, the ledger type is always AA.

Explanation

Enter the Journal Line Description from the PeopleSoft Enterprise system.

Account Number

The account number is retrieved from the Canonical Key value for the glaaccount key cross-reference, based on the PeopleSoft Enterprise account number of the transaction.

Setting Processing Options for Journal Entries Batch Processor (R09110Z)

Processing options enable you to specify the default processing for programs and reports.

Version

1. Journal Entry Version

Specify a version of Journal Entry MBF Processing Options program (P0900049). If you leave this processing option blank, version ZJDE0001 is used.

2. Post Version

Specify a version of the General Ledger Post Report program (R09801) to use to automatically post the journal entries to the Account Balances table (F0902). If you leave this processing option blank, the post is not submitted.

If you leave this processing option blank, you can post the journal entries later using the General Ledger Post Report program (R09801).

Process

1. Process Mode

Specify whether to leave this processing option blank to process the batch in proof mode. If you leave this processing option blank, no tables are updated. Enter 1 to process the batch in final mode and update the Account Ledger table (F0911).

2. Out of Balance

Specify whether to allow GL transactions that are out of balance to process. (Amounts do not net to zero.) Enter 1 to allow GL transactions that are out of balance to be processed. Leave this processing option blank to prevent transactions that are out of balance from being processed.

3. Purge

Specify whether to automatically purge processed transactions from the batch file. Enter 1 to automatically purge processed transactions from the Journal Entry Transactions - Batch File table (F0911Z1). Leave this processing option blank to flag the transactions as processed; these transactions are not purged from the F0911Z1 table.

If you leave this processing option blank, you can purge the transactions later using the Purge Batch Journal Entries program (R0911Z1P).

Messages

1. Warning Message	Specify whether to suppress the creation of warning messages in the work center. Enter 1 to suppress warning messages. Leave this processing option blank to enable warning messages.
2. Electronic Message	Specify a user to receive electronic messages. If you leave this processing option blank, the user who entered the transactions receives the message in the work center.

Edits

1. Batch Approval

Specify the status to apply to batches created during process. Specify 1 to set the status on all batches created to a status of approved. Leave this processing option blank to set the batch status according to the general accounting constants.

Running the Journal Entries Batch Processor (R09110Z)

From the G/L Advanced and Technical Operations menu (G09311), select Batch Journal Entry Processing.

You run the Journal Batch Entries Processor to validate records in the F0911Z1 table. If there are no errors, the system inserts the records from the F0911Z1 table into the Account Ledger table (F0911). The system also creates a record for the batch in the Batch Control Records table (F0011).

Processing PeopleSoft Enterprise Payroll Batch Transactions in the JD Edwards EnterpriseOne System

Select Batch Journal Entry Processing (G09311), Journal Entries Batch Processor.

You should run the Journal Entries Batch Processor program (R09110Z) in proof mode to validate the data that was inserted in the Journal Entry Transactions - Batch File table (F0911Z1). Correct any errors in the F0911Z1 table, and then run the Journal Entries Batch Processor program in final mode.

Use data selection based on a range of batch numbers and the transaction number to process the transactions that originated in the PeopleSoft Enterprise payroll system.

See Uploading Batch Journal Entry.

Posting JD Edwards EnterpriseOne Journal Entries

Select Journal Entry, Reports, & Inquiries (G0911), General Ledger Post.

If you did not set the processing options on the Journal Entries Batch Processor program (R09110Z) to post journal entries to the Account Balances table (F0902), run the General Ledger Post program (R09801) to post the journal entries.

See Posting Journal Entries.

Batch Number	Enter a unique number in the JD Edwards EnterpriseOne system that consists of the prefix HCM followed by a unique number generated by Next Numbers for system 00, line 6.
Transaction Number	Enter the process instance from the PeopleSoft Enterprise system.
SP (successfully processed)	This field is set to 0 when the transactions are inserted in the Journal Entry Transactions - Batch File table (F0911Z1), indicating that the transactions have not been written to the Account Ledger table (F0911).
User ID	Enter the JD Edwards EnterpriseOne user ID from the Family, Financials, PPI, User ID integration option. This should identify the user who is responsible for performing the import of PeopleSoft Enterprise payroll data into the F0911Z1 table.

Doc Type (document type)	Enter the document type from the Family, Financials, PPI, Document Type integration option. The default document type for payroll transactions is TJ.
Ledger Type	For transactions that originate in PeopleSoft Enterprise payroll, the ledger type is always AA.
Explanation	Enter the Journal Line Description from the PeopleSoft Enterprise system.
Account Number	The account number is retrieved from the Canonical Key value for the glaaccount key cross-reference, based on the PeopleSoft Enterprise account number of the transaction.