Setting Up General Ledger Interface Tables

This section provides an overview of GL Interface tables and discusses how to:

Use General Ledger business units in HRMS.
Map PeopleSoft HRMS and PeopleSoft General Ledger business units.
View or Create Journal Generator templates.
Configure the target product and system for PeopleSoft EnterpriseOne General Ledger.
Configure General Ledger business units for PeopleSoft EnterpriseOne General Ledger.

Before You Begin

To set up an interface between PeopleSoft Enterprise General Ledger and PeopleSoft Enterprise Human Resources, select the PS/GL Product check box on the Installation Table.

Note. If you are interfacing with PeopleSoft Enterprise Financials 8.4 or higher, set up these tables in Financials and update them using application messaging. The components will be unavailable for entry in HRMS; use them to review the Financials values.

Note. If you are not interfacing with PeopleSoft Financials 8.4 or higher, set up these tables in HRMS.

Using PeopleSoft General Ledger Business Units in PeopleSoft HRMS

To use PeopleSoft General Ledger business units in PeopleSoft HRMS, use the Review GL Business Units component (BUS_UNIT_TBL_GL).

Customers Using PeopleSoft General Ledger

If you’re using PeopleSoft General Ledger, set up General Ledger business units in the general ledger using the General Ledger Definition component. PeopleSoft HRMS subscribes to the General Ledger business unit data and displays it using the Business Unit GL component.

Customers Not Using PeopleSoft General Ledger

Customers not using PeopleSoft General Ledger must set up a General Ledger business unit directly in PeopleSoft HRMS, using the Business Unit GL component.

Note. Payroll companies must post data to at least one PeopleSoft General Ledger business unit so you need to set up at least one business unit.

See Also

PeopleSoft General Ledger PeopleBook, “Defining Your Operational Structure”

Pages Used to View the General Ledger Business Unit Definition

Page Name	Object Name	Navigation	Usage
Review GL Business Units - Definition	BUS_UNIT_TBL_GL1	Set Up HRMS, Product Related, Payroll for North America, GL Interface, Review GL Business Units, Definition	If you are using PeopleSoft General Ledger, this page is display only. Use it to view the definition of PeopleSoft General Ledger business units. PeopleSoft HRMS processes use the information in the Unit and Base Currency fields only. If you are not using PeopleSoft General Ledger, the fields on this page are editable. Use this page to set up GL business units.
Review GL Business Units - Currency Options	BUS_UNIT_TBL_GL2	Set Up HRMS, Product Related, Payroll for North America, GL Interface, Review GL Business Units, Currency Options	View the currency options of PeopleSoft General Ledger business units. PeopleSoft HRMS processes do not use the information on this page. This page is display-only.

Page Name

Object Name

Navigation

Usage

Review GL Business Units - Definition

BUS_UNIT_TBL_GL1

Set Up HRMS, Product Related, Payroll for North America, GL Interface, Review GL Business Units, Definition

If you are using PeopleSoft General Ledger, this page is display only. Use it to view the definition of PeopleSoft General Ledger business units. PeopleSoft HRMS processes use the information in the Unit and Base Currency fields only.

If you are not using PeopleSoft General Ledger, the fields on this page are editable. Use this page to set up GL business units.

Review GL Business Units - Currency Options

BUS_UNIT_TBL_GL2

Set Up HRMS, Product Related, Payroll for North America, GL Interface, Review GL Business Units, Currency Options

View the currency options of PeopleSoft General Ledger business units. PeopleSoft HRMS processes do not use the information on this page. This page is display-only.

Viewing the General Ledger Business Unit Definition

Access the Review GL Business Units - Definition page.

Unit

The PeopleSoft General Ledger business unit you selected to access the page.

Base Currency

The base currency for this PeopleSoft General Ledger business unit. A General Ledger business unit supports one base currency per ledger. This is usually the local currency for the organization, but accounting rules or other circumstances might dictate that it be different.

Options

Enable Document Sequencing	This check box is selected if document sequencing is required for this business unit.
Enable Payables InterUnit VAT (enable Payables interunit value added taxes)	This check box is selected if payables interunit value added taxes (VAT) is required for transactions between related parties.

Consolidations

For Eliminations Only

This check box is selected if this business unit is an eliminations entity for consolidations processing.

Viewing or Creating Journal Generator Templates

To view the journal generator template, use the Review Journal Generator Templ component (JRNLGEN_APPL_ID).

This section provides an overview of journal generator templates and describes how to:

View journal generator templates.
View the templates summarization options.

Understanding the Journal Generator Templates

PeopleSoft Enterprise Journal Generator uses the defaults set up in Journal Generator templates to create journals. Most organizations define templates for each application that distributes to the general ledger. If you’re using PeopleSoft General Ledger, set up and maintain Journal Generator templates in PeopleSoft Financials. PeopleSoft HRMS subscribes to the Journal Generator template data in Financials and displays it using the Review Journal Generator Templ component in PeopleSoft HRMS.

Customers not using PeopleSoft Enterprise General Ledger must set up a Journal Generator template directly in HRMS, using the Journal Generator Templates component. The system requires that a template ID be assigned, but it does not use the template.

Note. You must enter a value in the Last Journal Number Assigned field on the PeopleSoft Financials Installation Table to use the Journal Generator.

See Also

PeopleSoft Application Fundamentals for Financials and Supply Chain Management PeopleBook

Pages Used to View or Create Journal Generator Templates

Page Name	Object Name	Navigation	Usage
Review Journal Generator Templ - Defaults	JRNL_GEN_DEFAULTS	Set Up HRMS, Product Related, Payroll for North America, GL Interface, Review Journal Generator Templ, Defaults	View Journal Generator defaults. PeopleSoft HRMS processes use only the SetID and Template fields.
Review Journal Generator Templ - Summarization	JRNL_GEN_SUM	Set Up HRMS, Product Related, Payroll for North America, GL Interface, Review Journal Generator Templ, Summarization	View the template’s summarization options. PeopleSoft HRMS processes do not use the information on this page.

Viewing Journal Generator Defaults

Access the Review Journal Generator Templ - Defaults page.

If you are not interfacing with PeopleSoft Enterprise Financials, this page is editable. To set up a journal generator template enter a:

Template ID.
SetID.

The setID needs to match the setID of the General Ledger business units you created on the Review GL Business Units component (BUS_UNIT_TBL_GL) for the business unit to use a journal generator template.

The remaining fields are not required, so you can enter dummy information or leave them blank.

If you are using PeopleSoft General Ledger, the system displays data in the following fields:

Accounting Entry In Sync	This check box is selected if a PeopleSoft application that supports the multibook feature has generated in-sync accounting entries for this template.
Reversal Code	The reversal code for this Journal Generator template.

Journal Header Fields

Journal ID Mask	The journal naming convention.
Journal Date	The date journals are created; for example, Accounting Date on Transaction or Process Date.
Alt. Journal Date (alternate journal date)	The journal date used for journals created outside of the open accounting periods range.
Header Descr (header description)	Descriptive information about the journal.
Source	Identifies the originating entity responsible for the journal entries.
Document Type	The default general ledger document type assigned to the journal header.
Reference	The transaction source of the journal.

Journal Line Fields

Reference

Refers each journal line back to a document, person, invoice, date, or any other piece of information helpful for tracking the source of the transaction.

Viewing the Template's Summarization Options

Access the Review Journal Generator Templ - Summarization page.

If you are using PeopleSoft General Ledger, review the primary and alternate summarization options for the template on this page.

Mapping PeopleSoft HRMS and PeopleSoft General Ledger Business Units

To map PeopleSoft HRMS and PeopleSoft General Ledger, use the GL/HR Business Unit Mapping component (BU_GL_HR_LNK).

This section provides an overview of mapping PeopleSoft HRMS and PeopleSoft General Ledger business units and describes how to check General Ledger business unit and HRMS business unit mapping.

Understanding PeopleSoft HRMS and PeopleSoft General Ledger Business Unit Mapping

To share information successfully with PeopleSoft General Ledger, confirm that you've correctly associated (or mapped) your PeopleSoft HRMS business units to General Ledger business units. The system uses this mapping information to determine which General Ledger business unit to use when generating accounting transactions for actuals and encumbrances. General Ledger business units are associated with HRMS business units on the Business Unit Reference page (BUS_UNIT_TBL_HR2).

Use the GL/HR Business Unit Mapping page to check if a specific PeopleSoft General Ledger business unit is correctly mapped to the appropriate PeopleSoft HRMS business unit. Also use the GL/HR Business Unit Mapping page to associate a journal template and calendar ID with each General Ledger business unit.

See Also

Defining Business Units

Page Used to Review Business Unit Mapping

Page Name	Object Name	Navigation	Usage
GL/HR Business Unit Mapping	BU_GL_HR_LNK	Set Up HRMS, Common Definitions, ChartField Configuration, GL/HR Business Unit Mapping, GL/HR Business Unit Mapping	Check if a specific PeopleSoft General Ledger business unit is associated with the correct PeopleSoft Human Resources business unit. Associate a journal template and calendar ID with each PeopleSoft General Ledger business unit.

Page Name

Object Name

Navigation

Usage

GL/HR Business Unit Mapping

BU_GL_HR_LNK

Set Up HRMS, Common Definitions, ChartField Configuration, GL/HR Business Unit Mapping, GL/HR Business Unit Mapping

Check if a specific PeopleSoft General Ledger business unit is associated with the correct PeopleSoft Human Resources business unit.

Associate a journal template and calendar ID with each PeopleSoft General Ledger business unit.

Mapping Business Units

Access the GL/HR Business Unit Mapping page.

Business Unit - GL

The PeopleSoft General Ledger business unit and description.

Journal Template

Select the journal template to associate with this PeopleSoft General Ledger business unit from the list of available options. Journal templates are used during the Actuals and Encumbrances processes (PAYGL02 and PAYGL03).

Calendar ID

Select a calendar ID to associate with this PeopleSoft General Ledger business unit. The system uses calendar IDs to distribute actuals over accounting periods. Review calendars on the Detail Calendar page (DETAIL_CALENDAR1).

See Reviewing Detail Calendars and Budget Periods.

HR Business Units

The HR Business Units scroll area displays the PeopleSoft Human Resources business units and descriptions currently associated with the PeopleSoft General Ledger business unit.

If the PeopleSoft Human Resources and PeopleSoft General Ledger business units aren't correctly mapped, correctly associate them on the Business Unit Reference page. After mapping Human Resources business units to the appropriate General Ledger business units, return to the GL/HR Business Unit Mapping page to associate a journal template and calendar ID with each General Ledger business unit.

Configuring the Target Product and System for PeopleSoft EnterpriseOne General Ledger

This section provides overviews of target product and system configuration and account balancing defaults, lists common elements, and discusses how to:

Configure the target product.
Configure the target system.

Understanding Target Product and System Configuration

This table defines the terminology used in this section:

Target system	A specific GL installation that is represented by a message node. It indicates to what target system the payroll accounting lines are to be sent, which is the database that runs the general ledger application.
Target product	The target general ledger product to which payroll data is to be posted on the specified target system.

Here is a summary of the configuration steps:

Assign processing defaults for a target product on the Configure Target Product page.
Associate the target product with a target system by selecting the target product on the Configure Target System page.

You can update the processing options for the target product on this page.
Associate the target system with the general ledger business unit by selecting the message node (target system) on the Configure GL Business Unit page.

This step associates accounting lines with the target system because each accounting line has the general ledger business unit as a required field.

Understanding Account Balancing Defaults

You specify two default configuration options related to account balancing:

Balance Accounting Lines

Specify whether or not to balance accounts for the business unit before posting them to general ledger.
- Selected:
  
  If you select the balancing option, the posting process calculates whether the debits equal the credits for each business unit.
- Not selected:
  
  If you do not select the balancing option, the system does not perform balancing calculations before posting the accounts.
Book to Suspense Account

If you select the Balance Accounting Lines option, you further specify whether or not to post unbalanced amounts to a suspense account when the credits do not equal debits for a general ledger business unit.
- Selected:
  
  If you select this option, you must specify a suspense account number on the Configure GL Business Unit page. When the debits and credits are not equal, the system creates a new accounting line containing the unbalanced amount and the specified suspense account.
- Not selected:
  
  If you did not select this option and the accounts do not balance, no accounts are posted for the entire run ID and an error message informs you that the amounts for the general ledger business unit do not balance.
  
  Note. If you select this option but do not specify a suspense account for the general ledger business unit, the system will issue an error message and no accounts will be posted if the accounts do not balance.
  
  You select the default processing options for the general ledger system on the Configure Target Product page. You can modify the defaults on the Configure Target System page. You can override the target system processing options on the run control page when you run the process to post the accounting lines.

Common Elements Used in this Section

Consolidate Accounting Lines

If you’re processing accounting lines in Payroll for North America, select this check box if you want the system to consolidate accounting lines before posting. With consolidation, the data is summarized for lines that are identical other than amount and line number.

Accounting lines are automatically consolidated for Global Payroll.

Balance Accounting Lines

Select this check box if you want the system to calculate whether the debits equal the credits for each general ledger business unit.

Book to Suspense Account

This field is available for entry if you select Balance Accounting Lines.

Select Book to Suspense Account to post unbalanced amounts to a suspense account when the credits do not equal debits. If selected, you must specify a suspense account number on the Configure GL Business Unit page.

Pages Used to Configure the Target Product and System

Page Name	Object Name	Navigation	Usage
Configure Target Product	HPIP_CONFIG_PRD	Set Up HRMS, Common Definitions, GL Integrations, Common GL Objects, Configure Target Product, Configure Target Product	Assign processing defaults for the target product.
Configure Target System	HPIP_TGT_SYS_GL	Set Up HRMS, Common Definitions, GL Integrations, Common GL Objects, Configure Target System, Configure Target System	Select the target product for the target and update the processing options for the target product.

Configuring the Target Product

Access the Configure Target Product page.

Maximum Lines Chunking Limit

Set Chunking Limit	Select if you want the system to chunk the data when the number of accounting lines exceeds the maximum of the target product.
Max Number of Accounting Lines (maximum number of accounting lines)	This field is available for entry if you select Set Chunking Limit. Enter the maximum number of accounting lines that the target product can accept.

Configuring the Target System

Access the Configure Target System page.

When you access the page, select the PeopleSoft Integration Broker node that you defined for the integration with EnterpriseOne. The node represents the target system.

Target System Details

The default processing options that you selected on the Configure Target Product page are the default values on this page. You can update the processing options here. You can also override the processing options on the process run control page when you post the accounting lines.

Product	Select EnterpriseOne as the target general ledger product to which payroll data is to be posted on this target system.
Product Release	Select the release number of the product.

Configuring and Mapping Business Units for PeopleSoft EnterpriseOne General Ledger

This section lists a prerequisite and discusses how to:

Configure GL business units.
Map GL business units to HR business units.

Note. In this integration, GL business units are the EnterpriseOne companies that you loaded into the BUS_UNIT_TBL_GL table.

Prerequisite

For each GL business unit (EnterpriseOne company), create a distinct setID that you want to use for the accounts that are received from EnterpriseOne for that company (GL business unit).

Pages Used to Configure and Map Business Units for PeopleSoft EnterpriseOne General Ledger

Page Name	Object Name	Navigation	Usage
Configure GL Business Unit	HPIP_ADMIN_GL	Set Up HRMS, Common Definitions, GL Integrations, Common GL Objects, Configure GL Business Unit, Configure GL Business Unit	Set up additional parameters for the general ledger business unit.
Business Unit Reference	BUS_UNIT_TBL_HR2	Set Up HRMS, Foundation Tables, Organization, Business Unit, Business Unit Reference	Enter the general ledger business unit that corresponds to each of the HR business units.

Configuring GL Business Units

Access the Configure GL Business Unit page.

General Ledger Unit

Each company that you imported from EnterpriseOne is available as a general ledger unit in the search page.

Target System for Posting

Node Name

Select the PeopleSoft Integration Broker node that you defined as the target system for this integration.

Accounts

GL SetID for Accounts (general ledger setID for accounts)	Enter the setID that you want to use for the accounts that are received from EnterpriseOne for this company (GL business unit).
Clearing Account	Enter the account to be used for balancing the account when the data must be sent in chunks due to exceeding the maximum lines (9999) that can be sent per posting. The deltas per chunk are held in this clearing account and must balance when all chunks of the posting are posted.
Suspense Account	Enter the account to be used for posting the delta amount if the debits and credits do not balance for each general ledger business unit. The delta is posted to an additional general ledger line with the suspense account code. Available accounts are only those with account type Expense.
Journal Template	You can select a valid template ID or enter a new value. When you save this page: If the journal template ID did not exist previously, it is generated in the Journal Generator Template table (JRNLGEN_APPL_ID) using the value that you enter here. In the GL Journal Template table (GL_JRNL_TMPLT), the journal template ID is associated with the GL business unit and effective date that you enter on this page.

Default Cost Center

Select the default cost center to be assigned when the accounting line does not contain sufficient data to identify the correct cost center.

Controlling Area	Select the controlling area. Available values are the company codes entered into the Enterprise Controlling Area table when EnterpriseOne companies were imported into the Enterprise Business Unit GL table.
Cost Center ID	Select a cost center. The available values are the EnterpriseOne business units that you imported into the Enterprise Cost Center table.

Mapping GL Business Units to HR Business Units

Access the Business Unit Reference page.

General Ledger Unit

Select the general ledger business unit that corresponds to the HR business unit that you selected when you accessed the page. Available GL business units are from the BUS_UNIT_TBL_GL table.

See Also

Defining Business Units

Unit	The PeopleSoft General Ledger business unit you selected to access the page.
Base Currency	The base currency for this PeopleSoft General Ledger business unit. A General Ledger business unit supports one base currency per ledger. This is usually the local currency for the organization, but accounting rules or other circumstances might dictate that it be different.