Setting Up Business Units for General Ledger Integration

Page Name

Definition Name

Usage

Review GL Business Units - Definition Page

BUS_UNIT_TBL_GL1

View the definition of PeopleSoft General Ledger business units.

Note: If you are using PeopleSoft General Ledger, this page is display 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 Page

BUS_UNIT_TBL_GL2

View the currency options of PeopleSoft General Ledger business units.

Note: PeopleSoft HCM processes do not use the information on this page. This page is display only.

Review Journal Generator Tmpl - Defaults Page (review journal generator template - defaults page)

JRNL_GEN_DEFAULTS

View Journal Generator defaults.

Review Journal Generator Tmpl - Summarization Page (review journal generator template - summarization page)

JRNL_GEN_SUM

View the template's summarization options.

Note: PeopleSoft HCM processes do not use the information on this page.

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

GL/HR Business Unit Mapping Page

BU_GL_HR_LNK

Verify that the General Ledger business unit is associated with the correct HCM business unit.

Associate a journal template with each General Ledger business unit.

See

  • “Defining Your Operational Structure” in your PeopleSoft General Ledger product documentation.

  • PeopleSoft Application Fundamentals for Financials and Supply Chain Management product documentation.

This topic discusses:

  • General ledger business units.

  • Journal templates.

  • Business unit mapping.

General Ledger Business Units

If you're using PeopleSoft General Ledger, set up General Ledger business units in the Financials database using the General Ledger Definition component. PeopleSoft HCM subscribes to the General Ledger business unit data and displays it using the Business Unit GL component. The pages are unavailable for entry in HCM; use them to review the Financials values.

Note: Payroll for North America must post data to at least one PeopleSoft General Ledger business unit so you must set up at least one business unit.

If your organization does not use PeopleSoft General Ledger, you must set up a General Ledger business unit directly in PeopleSoft HCM, using the Business Unit GL component.

Journal Templates

PeopleSoft 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 HCM subscribes to the Journal Generator template data in Financials and displays it using the Review Journal Generator Templ component in PeopleSoft HCM.

If your organization does not use PeopleSoft General Ledger, you must set up a Journal Generator template directly in HCM, using the Journal Generator Templates component. The system requires that a template ID be assigned, but it does not use the template.

Business Unit Mapping

To share information successfully with PeopleSoft General Ledger, confirm that you've correctly associated (or mapped) your PeopleSoft HCM 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.

Use the GL/HR Business Unit Mapping page to:

  • Confirm that a specific PeopleSoft General Ledger business unit is correctly mapped to the appropriate PeopleSoft HCM business unit.

  • Associate a journal template and calendar ID.

  • If you use commitment accounting, also identify the associated calendar ID.

Use the Review GL Business Units - Definition page (BUS_UNIT_TBL_GL1) to view the definition of PeopleSoft General Ledger business units.

Note: If you are using PeopleSoft General Ledger, this page is display 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.

Navigation

Set Up HCM > Product Related > Payroll for North America > GL Interface > Review GL Business Units > Definition

Image: Review GL Business Units - Definition page

This example illustrates the fields and controls on the Review GL Business Units - Definition page.

Review GL Business Units - Definition page

PeopleSoft HCM processes use the information in the Unit and Base Currency fields only.

Field or Control

Definition
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

Field or Control

Definition
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

Field or Control

Definition
For Eliminations Only

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

Use the Review Journal Generator Tmpl - Defaults page (JRNL_GEN_DEFAULTS) to view Journal Generator defaults.

Navigation

Set Up HCM > Product Related > Payroll for North America > GL Interface > Review Journal Generator Tmpl > Defaults

Image: Review Journal Generator Tmpl - Defaults page

This example illustrates the fields and controls on the Review Journal Generator Tmpl - Defaults page.

Review Journal Generator Tmpl - Defaults page

PeopleSoft HCM processes use only the SetID and Template fields.

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

  1. Template ID.

  2. 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:

Field or Control

Definition
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

Field or Control

Definition
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

Field or Control

Definition
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.

Use the GL/HR Business Unit Mapping page (BU_GL_HR_LNK) to verify that the General Ledger business unit is associated with the correct HCM business unit.

Navigation

Set Up HCM > Common Definitions > ChartField Configuration > GL/HR Business Unit Mapping > GL/HR Business Unit Mapping

Image: GL/HR Business Unit Mapping page

This example illustrates the fields and controls on the GL/HR Business Unit Mapping page.

GL/HR Business Unit Mapping page

Associate a journal template with each General Ledger business unit.

Field or Control

Definition
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

If you use commitment accounting, 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 HCM business units and descriptions currently associated with the PeopleSoft General Ledger business unit.

If the PeopleSoft HCM and PeopleSoft General Ledger business units aren't correctly mapped, correctly associate them on the Business Unit Reference page. After mapping PeopleSoft HCM 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.