Understanding the General Ledger Interface

Sending payroll data to General Ledger is one of the final steps in the payroll cycle. When you integrate Payroll for North America and General Ledger, you can automatically post earnings and deductions that are associated with a finalized calendar run to your General Ledger system.

This topic discusses:

  • Prerequisites.

  • Description of the interface with General Ledger.

  • Integration points.

These setup tasks must be completed before you begin the tasks in this topic:

  1. Update the General Ledger fields on the Installation table – Product Specific page.

    See Understanding PeopleSoft Component Interfaces.

  2. Set up the integration with the Financials database.

    SeePeopleSoft Integration Interfaces

  3. Set up the ChartFields and ChartField configuration.

    See Understanding PeopleSoft ChartFields.

With Payroll for North America you can send payroll accounting transactions to General Ledger. The payroll data that is sent to General Ledger includes the following expense and liability account data:

  • Earnings.

  • Deductions.

  • Federal, state/provincial, and local tax and insurance deductions.

  • Net pay and direct deposit data.

Integration Points are interfaces between PeopleSoft applications. They enable the transfer of data from one database to another.

The Payroll for North America and General Ledger interface uses two sets of integration points, one to retrieve ChartField and business unit information from General Ledger and one to publish payroll results to General Ledger.

The Payroll for North America interface with PeopleSoft General Ledger uses the following integration points:

Service Operation

Description

BUS_UNIT_GL_FULLSYNC

Financials database initial full table publish of GL business unit IDs.

BUS_UNIT_GL_SYNC

Financials database ongoing incremental publish of GL business unit IDs.

BUS_UNIT_FS_FULLSYNC

Financials database initial full table publish of GL business unit descriptions.

BUS_UNIT_FS_SYNC

Financials database ongoing incremental publish of GL business unit descriptions.

JOURNAL_GEN_APPL_ID_FULLSYNC

Financials database initial full table publish of PeopleSoft Journal Generator templates.

JOURNAL_GENERATOR_APPL_ID_SYNC

Financials database ongoing incremental publish of PeopleSoft Journal Generator templates.

PAYROLL_ACCTG_TRANSACTION

PeopleSoft HCM database batch publish of HR (payroll) accounting lines.

One service operation for each GL ChartField

See Understanding PeopleSoft ChartFields.