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:
Update the General Ledger fields on the Installation table – Product Specific page.
Set up the integration with the Financials database.
SeePeopleSoft Integration Interfaces
Set up the ChartFields and ChartField configuration.
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 |