Sending Chargeback Data to the General Ledger

This topic provides an overview of data export to the general ledger and discusses how to send chargeback data to the general ledger.

Page Used to Send Chargeback Data to the General Ledger

Page Name	Definition Name	Navigation	Usage
Export Accounting Entry to GL (export accounting entry to general ledger)	LM_RUNCTL_GL_INTFC	select Enterprise Learning, then select Financial Details, then select Export Accounting Entry to GL, then select Export Accounting Entry to GL	Export chargeback transactions from a subledger to the general ledger in the financials system.

Understanding Data Export to the General Ledger

When you export transactions to your Financial Management System , the system exports all chargeback transactions in the subledger with a status of pending and then updates the status of each exported transaction to posted. The system does not export transactions with a status of history, updated, or posted. After the system exports the transactions in a subledger group, you must manually enter any corrections to those transactions in the financials system. Enterprise Learning Management provides a report that you can use to review all chargeback transaction updates so that you can accurately make the adjustments in the financials system.

The system does not export revenue transactions to an accounts receivable system. Revenue transactions remain in the subledger group with a subledger status of pending. Enterprise Learning Management provides several reports that you can use to review revenue transactions for a customer organization. These reports enable you to track and manually update these transactions in the accounts receivable system. Or, you can create a process to export revenue transactions to the accounts receivable system.

When you export transactions to the general ledger in the financials system, the system compares the transaction currency with the general ledger business unit base currency. If the currencies don't match, the system converts the currency of the transaction to the general ledger business unit base currency. The system uses the exchange rate that is specified in the Currency Rate Type field on the Install Defaults page to convert the currency. Import exchange rates from the financials system by using enterprise integration points (EIPs).

Export Accounting Entry to GL Page

Use the Export Accounting Entry to GL (export accounting entry to general ledger) page (LM_RUNCTL_GL_INTFC) to export chargeback transactions from a subledger to the general ledger in the financials system.

Navigation

select Enterprise Learning, then select Financial Details, then select Export Accounting Entry to GL, then select Export Accounting Entry to GL

Click Run to run this request. PeopleSoft Process Scheduler runs the Export Accounting Entry to GL process at user-defined intervals.

Note: You do not need to run the Export Accounting Entry to GL process on a daily basis; instead, it should be driven by the business rules of the organization. This might be on a monthly or quarterly basis, depending on the organization. Run this process during off-peak hours as processing might be intensive.

Subledger Group

Select a subledger group.

Journal Template

Select a journal template. The journal template determines how the system formats transaction data in the Enterprise Learning Management Accounting Entry tables. Import journal templates from the financials system by using delivered EIP messages.

See Financial EIPs.

Accounting Date

Enter an accounting date. All journals in a general ledger are associated with an accounting calendar. If you integrate with PeopleSoft Financials, Journal Generator selects the appropriate accounting calendar based on the accounting date that you enter here. If you integrate with a third-party financials system, you must create a process to associate journal entries with an accounting calendar after you export the journal entries to the financials system.