Understanding the General Ledger Interface

The major tasks involved in the integration of Global Payroll with General Ledger are:

• Setup integration:

  1. Set up integration options and code cross-referencing in the EnterpriseOne XPI soft-coding/ cross-reference database.

  2. Set up integration in the Enterprise Database.

  3. Verify the target product configuration and configure the target system.

• Initial loading, configuring, and mapping of primary data:

  1. Load EnterpriseOne companies into the Enterprise Business Unit GL table.

  2. If required, define SetIDs that will be used for General Ledger accounts.

  3. Configure General Ledger business units: enter the target system, the account SetID, and the journal template.

  4. Map General Ledger business units to HR business units.

  5. Load EnterpriseOne accounts into the Enterprise GL Account table.

  6. Load EnterpriseOne business units into the Enterprise Cost Center table.

  7. Configure General Ledger business units: enter the clearing account, the suspense account, and the default cost center.

  8. Map EnterpriseOne primary data to Enterprise Global Payroll data.

• Incremental synchronization of changes in EnterpriseOne primary data.

  1. Add, change, or delete actions performed on the primary EnterpriseOne tables automatically trigger incremental synchronization integrations.

  2. When EnterpriseOne updates data in Enterprise tables by the incremental integration, Global Payroll users must update data configuration and mapping as needed.

• Routine transactions such as monthly posting of payroll data to general ledger:

  1. Synchronize currency exchange rates if needed.

  2. Global Payroll processes and posts accounting lines to the EnterpriseOne staging table.

  3. In EnterpriseOne, validate transactions and load them into the Account Ledger table (F0911).

  4. If necessary, data errors are corrected in the EnterpriseOne table or the payroll applications reset GL processing, correct errors, reprocess, and repost.

  5. In EnterpriseOne, post journal entries to the Account Balances table (F0902).

This topic covers only the tasks performed in the Enterprise database. The EnterpriseOne documentation discusses setting up the integration on the EnterpriseOne side and loading EnterpriseOne data into the Enterprise database.

See “Setting Up the JD Edwards EnterpriseOne to PeopleSoft General Ledger Integration” in JD Edwards EnterpriseOne 8.12 Application Integrations with Oracle PeopleSoft Applications Implementation Guide.