Understanding the PeopleSoft Enterprise Treasury and JD Edwards EnterpriseOne General Accounting Integration
This chapter provides an overview of PeopleSoft Enterprise Treasury and JD Edwards EnterpriseOne General Accounting integration and discusses how to:
Process PeopleSoft Enterprise bank statements.
Process PeopleSoft Enterprise accounting transactions.
Understanding the PeopleSoft Enterprise Treasury and JD Edwards EnterpriseOne General Accounting Integration
The integration of Oracle's PeopleSoft Enterprise Treasury Management and JD Edwards EnterpriseOne General Accounting systems enables you to use the PeopleSoft Treasury Management system to manage your cash and risk for sound fund management and to meet regulatory requirements while maintaining your accounting information in the JD Edwards EnterpriseOne General Accounting system.
The PeopleSoft Enterprise Treasury Management system provides business processes for cash management activities such as bank transfers, deal transactions, electronic funds transfers (EFTs), and so on. With the integration, bank statements from PeopleSoft Enterprise Treasury Management are transferred to the JD Edwards EnterpriseOne General Accounting. The JD Edwards EnterpriseOne General Accounting system provides an automatic bank account process that is automated from the bank flat file to bank account reconciliation.
For transactions that affect bank accounts, all bank statement data from PeopleSoft Enterprise Treasury Management is mapped from its original bank format to the PSFT bank format. The PSFT bank statements are transferred via the Web Services Gateway to the bank statement staging tables (F09610 and F09611) in the General Accounting system. The Load Bank Statement program uploads the statements to the bank statement tables (F09616 and F09617) and the Process Automatic Bank Statement program processes and reconciles the transactions in the F0911 table.
For GL transactions that affect bank accounts, accounting transactions are created in the Treasury Management system and then transferred via the Web Services Gateway to the F0911Z1 table in the JD Edwards EnterpriseOne General Accounting system. The transactions are created with a document type TM (Treasury Management). From the F0911Z1 table, the Journal Entry Batch Processor program (R09110Z) uploads the transactions to the F0911 table and sends a message to PeopleSoft Enterprise Treasury Management indicating whether the program completed successfully. The Process Automatic Bank Statement program processes and reconciles the accounting transactions against RJE transactions in the F0911 table.
After the transactions are written to the F0911 table, they can be posted to the F0902 table using the General Ledger Post program (R09801). When the accounting transactions are successfully posted, a message is sent to PeopleSoft Enterprise Treasury Management.
Processing PeopleSoft Enterprise Bank Statements
If your bank statements originate in the PeopleSoft Enterprise Treasury Management system and you perform your bank account reconciliations using the JD Edwards EnterpriseOne General Accounting system, you must run an integration flow to transfer the bank statement data from PeopleSoft Enterprise to JD Edwards EnterpriseOne.
When PeopleSoft Enterprise PSFT bank statements are ready to be processed in JD Edwards EnterpriseOne, PeopleSoft Enterprise Treasury Management sends the message BANK_STATEMENT_LOAD to the Web Services Gateway. This is an XML message that contains the bank statements.
Upon receiving the message, the Web Services Gateway automatically runs the integration service flow insert E Treasury to E1 BankStatementStaging.This integration flow transfers data from bank statements in the PSFT format to the JD Edwards EnterpriseOne staging tables. From the staging tables, the process to reconcile bank accounts is the same regardless of whether the bank statements originate in PeopleSoft Enterprise Treasury Management.
See Revising Data in the Staging Tables.
Processing PeopleSoft Enterprise Accounting Transactions
If journal entries for bank statement transactions, such as bank fees, transfers, and interest earned, originate in the PeopleSoft Enterprise Treasury Management system and you perform your bank account reconciliations using the JD Edwards EnterpriseOne General Accounting system, you must convert the journal entries and reconcile them as part of the automatic bank statement process.
This section discusses how to:
Convert accounting transactions to the F0911Z1 table.
Transfer accounting transactions to the F0911 table.
Post accounting transactions to the F0902 table.
Converting Accounting Transactions to the F0911Z1 Table
When PeopleSoft Enterprise accounting transactions are ready to be processed in JD Edwards EnterpriseOne, PeopleSoft Enterprise Treasury Management sends the message SYNC_TR_ACCTG_TXN to the Web Services Gateway. The message contains the accounting transactions.
Upon receiving the message, the Web Services Gateway automatically runs an integration service flow called insert E Treasury to E1 GeneralLedger. This integration flow converts the PeopleSoft Enterprise accounting transactions to a format that maps the PeopleSoft Enterprise accounting fields to the fields in the Batch Journal Entry table (F0911Z1) in JD Edwards EnterpriseOne.
Transferring Accounting Transactions to the F0911 Table
Select Batch Journal Entry Processing (G09311), Journal Entries Batch Processor.
To transfer the accounting transactions from the F0911Z1 table to the F0911 table for automatic bank statement reconciliation, you must run the Journal Entries Batch Processor (R09110Z). When you run this program in final mode, the system processes batches that contain transactions with document type TM. Specifically, the program:
Updates a status flag in the F0911Z1 table for each journal entry to indicate that the accounting transaction processed successfully.
For each accounting transaction that processed successfully, creates a JD Edwards EnterpriseOne document number and GL date for the journal entry.
Submits a status message to the PeopleSoft Enterprise Treasury Management system for accounting transactions that were successfully written to the F0911 table.
After the accounting transactions are successfully processed in the F0911 table, the Automatic Bank Statement program reconciles the accounting transactions against the RJE transactions in the F0911 table. RJE transactions originate from electronic bank statements in the PeopleSoft Enterprise Treasury system.
Posting Accounting Transactions to the F0902 Table
Select Journal Entry, Reports, & Inquiries (G0911), General Ledger Post.
After you transfer PeopleSoft Enterprise accounting transactions to the F0911 table, you must post them as you would any other transactions. When you run the General Ledger Post, the system processes batches that contain transactions with document type TM. Specifically, the program:
Updates a status flag for each batch that posted successfully to the F0902 table.
Submits a status message to the PeopleSoft Enterprise Treasury Management system for accounting transactions that were successfully posted to the F0902 table.
See Setting Processing Options for General Ledger Post (R09801).