PeopleSoft Enterprise Payroll for North America 9.1 PeopleBook

Integrating with EnterpriseOne General Ledger

This chapter provides an overview of the interface with EnterpriseOne General Ledger and discusses how to:

Configure the target product and system.
Configure and map business units.
Map cost centers and accounts to the Payroll for North America System.
Retrieve currency exchange rates.
Prepare and post accounting lines to EnterpriseOne General Ledger.

Note. Make sure you work in conjunction with your general ledger staff to use this interface.

Understanding the EnterpriseOne General Ledger Interface

This section discusses:

Prerequisites.
Description of the interface with General Ledger.
Integration Points.

Note. This chapter 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.

Working with Integration Points in Enterprise HRMS

PeopleSoft EnterpriseOne Application Integrations with PeopleSoft Enterprise Applications 8.11 PeopleBook, Integrating PeopleSoft Enterprise Payroll Applications with PeopleSoft EnterpriseOne General Ledger

Prerequisites

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

Set up the integration with the EnterpriseOne database.

See PeopleSoft Enterprise Human Resources PeopleBook: Enterprise Components
Set up the ChartFields and ChartField configuration.

See Setting Up and Working with ChartFields and ChartField Combinations.

Description of the Interface with General Ledger

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

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.

Before using the integration between Payroll for North America and EnterpriseOne General Ledger, configure the Integration Broker nodes and activate the appropriate queues, handlers, and routings for these service operations:

Service Operation	Description
BUS_UNIT_GL_FULLSYNC	Initial load of EnterpriseOne companies into the Enterprise Business Units GL table (BUS_UNIT_TBL_GL). This service operation additionally: Spawns the BUS_UNIT_FS_SYNC service operation. Loads the company code, effective date, effective status, and description into the Controlling Area table (HPYP_CNTRL_AREA.
BUS_UNIT_GL_SYNC	Incremental updates of the Enterprise Business Units GL table. It performs the same additional functions as the corresponding fullsync service operation.
BUS_UNIT_FS_SYNC	Internal Enterprise service operation that is spawned from the subscription to BUS_UNIT_GL_FULLSYNC and BUS_UNIT_GL_SYNC. Imports or updates the company description into the PS/Financials Business Units table (BUS_UNIT_TBL_FS).
COST_CENTER_FULLSYNC	Initial load of EnterpriseOne business units into the Enterprise Cost Center table (HPYP_CC_TBL).
COST_CENTER_SYNC	Incremental updates of the Enterprise Cost Center table.
ACCOUNT_CHARTFIELD_FULLSYNC	Initial load of the EnterpriseOne Account Master table (F0901) to the Enterprise GL Accounts table (GL_ACCOUNTS_TBL).
ACCOUNT_CHARTFIELD_SYNC	Incremental additions to the Enterprise GL Accounts table.
MARKET_RATE_REQ	Enterprise queries EnterpriseOne for currency exchange rate multiplier or divider.
MARKET_RATE_SYNC	EnterpriseOne replies and Enterprise updates the Market Rate Data table (RT_RATE_TBL).
PAYROLL_ACCTG_ TRANSACTION	Enterprise Payroll for North America publishes accounting data to EnterpriseOne.
PAYROLL_TRANSACTION_REPLY	EnterpriseOne notifies Enterprise Payroll for North America of success or error in loading table F0911Z1.

Configuring the Target Product and System

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 an Integration Broker 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 Integration Broker 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	Definition 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 (Set Up HRMS, Common Definitions, GL Integrations, Common GL Objects, Configure Target Product, Configure Target Product).

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 (Set Up HRMS, Common Definitions, GL Integrations, Common GL Objects, Configure Target System, Configure Target System).

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

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

Page Name	Definition 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 (Set Up HRMS, Common Definitions, GL Integrations, Common GL Objects, Configure GL Business Unit, Configure GL Business Unit).

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.
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 (Set Up HRMS, Foundation Tables, Organization, Business Unit, Business Unit Reference).

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

Mapping Cost Centers and Accounts to the Payroll for North America System

To map cost centers, use the Map Departments to Cost Centers component.

This section discusses how to:

Map cost centers to department and setID.
Group expense activities.
Map expense groups to GL accounts.

Pages Used to Map Cost Centers and Accounts to the Payroll for North America System

Page Name	Definition Name	Navigation	Usage
Map Departments to Cost Center	HPIP_DEPT_CC_MAP	Set Up HRMS, Common Definitions, GL Integrations, Common GL Objects, Map Departments to Cost Center, Map Departments to Cost Center	Map departments and setIDs to cost centers for Payroll for North America.
Earnings Expenses	PYGL_ACTIVE_ERNGRP	Set Up HRMS, Product Related, Payroll for North America, GL Interface, GL Activity Grouping, Earnings Expenses	Group earnings codes into expense groups.
Deduction Expenses	PYGL_ACTIVE_DEDGRP	Set Up HRMS, Product Related, Payroll for North America, GL Interface, GL Activity Grouping, Deduction Expenses	Group deduction codes into expense groups.
Tax Expenses	PYGL_ACTIVE_TAXGRP	Set Up HRMS, Product Related, Payroll for North America, GL Interface, GL Activity Grouping, Tax Expenses	Group taxes into expense groups.
Earnings Mapping	PYGL_CO_CF_MAPERN	Set Up HRMS, Product Related, Payroll for North America, GL Interface, ChartField Expense Mapping USA, Earnings Mapping Set Up HRMS, Product Related, Payroll for North America, GL Interface, ChartField Expense Mapping CAN, Earnings Mapping	Specify mapping level and map earnings expense groups to ChartField combinations.
Deductions Mapping	PYGL_CO_CF_MAPDED	Set Up HRMS, Product Related, Payroll for North America, GL Interface, ChartField Expense Mapping USA, Deductions Mapping Set Up HRMS, Product Related, Payroll for North America, GL Interface, ChartField Expense Mapping CAN, Deductions Mapping	Specify mapping level and map deduction expense groups to ChartField combinations.
U.S. Tax Mapping	PYGL_CO_CF_MAPTAX	Set Up HRMS, Product Related, Payroll for North America, GL Interface, ChartField Expense Mapping USA, U.S. Tax Mapping	Specify mapping level and map U.S. tax expense groups to ChartField combinations.
Canadian Tax Mapping	PYGL_CO_CF_MAPCTX	Set Up HRMS, Product Related, Payroll for North America, GL Interface, ChartField Expense Mapping CAN, Canadian Tax Mapping	Specify mapping level and map Canadian tax expense groups to ChartField combinations.

Mapping Cost Centers to Department and SetID

Access the Map Departments to Cost Center page (Set Up HRMS, Common Definitions, GL Integrations, Common GL Objects, Map Departments to Cost Center, Map Departments to Cost Center).

Controlling Area

Select a controlling area when you access the page. 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. You can view controlling areas on the View Controlling Areas page in the Common GL Objects menu.

Cost Center ID

Select a cost center when you access the page. The available values are the EnterpriseOne business units that you imported into the Enterprise Cost Center table. You can view cost centers on the View Cost Centers page in the Common GL Objects menu.

SetID

Select the setID for the department to be mapped. All setIDs are available for selection.

Department

Enter the department to be mapped to the cost center selected when you entered the page.

Grouping Expense Activities

See Grouping Earnings, Deduction, and Tax Expenses.

Mapping Expense Groups to GL Accounts

See Mapping Expense Groups to ChartField Combinations.

Retrieving Currency Exchange Rates

To retrieve currency exchange rates, use the Request Market Rates (HIE1_MKT_RT_RNCTL) component.

This section provides overviews of currency market rates integration and currency rounding and discusses how to request market rates.

Understanding the Currency Market Rates Integration

Currency market rates must be synchronized between Payroll for North America and the EnterpriseOne financial system, which is the master for market rates. Use the same run control page to either schedule the synchronization or manually request it.

Note. Currency cross referencing must be set up in PeopleSoft EnterpriseOne's XPI Cross-Reference database before you use this process to synchronize market rates.

Here is a brief description of the processing:

A Payroll for North America user requests market rates, specifying a currency or range of currencies and a date on the run control page.

Use the page in the Set Up HRMS, Common Definitions, GL Integrations, Common GL Objects, Payroll to E1 General Ledger menu.

The Market Rate Import Application Engine process (HI_MKT_RT) creates the MARKET_RATE_REQ service operation, converts it to a synchronous service operation, and publishes it.
The Integration Server sends back the MARKET_RATE_SYNC response service operation containing the market rates available for the specified currency pairs and date.

Either the multiplier or divisor is populated in the message, based on the calculation method and currency conversion method in the record. The other rate is initialized to 1.0.
The MARKET_RATE_SYNC service operation updates the Enterprise Market Rate Data table (RT_RATE_TBL).

Note. You must set all market rates that you will use in EnterpriseOne and sync up those rates with Enterprise. Processing payroll transactions with currencies for which market rates are set up in Enterprise and not in EnterpriseOne will produce invalid data in EnterpriseOne.

If a query is made to a currency exchange rate that does not exist in EnterpriseOne for the date specified, no data is returned in the reply.

Understanding Currency Rounding

If you are keeping amounts in different currencies on both the detail and sum (balance) level, there is a potential for rounding discrepancies because the system converts single amounts, sums them up for balancing, and then converts the sum. As a result, the converted amount of the sum does not equal the sum of the single conversions. To avoid this, you must select the Balance Accounting Lines check box on the Configure Target Product and Configure Target System pages.

When the Balance Accounting Lines check box is selected:

All amounts are posted in both the payroll and the GL currency.

Primarily, balancing is enforced in the payroll currency.

Note. This is standard processing, whether or not you select the Balance Accounting Lines check box.
If the payroll currency differs from the GL currency, a new accounting line for rounding adjustment is created for each segment that is sent to GL.

This prevents rounding differences that might cause the amounts to be out of balance in the GL currency.
- The accounting line is created once per chunk.
- It is created only if the Balance Accounting Lines check box is selected and the payroll currency differs from the currency of the GL business unit.
- The new accounting line contains the rounding adjustment in the GL currency.
  
  The amount in the payroll currency is 0.
- The system assigns to the new accounting line to the suspense account specified on the Configure GL Business Unit page.
  
  If no suspense account has been specified for the GL business unit, the rounding adjustment entry is not created.
- The description field says Rounding Adjustment Entry.

Configuring GL Business Units

Page Used to Request Market Rates

Page Name	Definition Name	Navigation	Usage
Request Market Rates	HIE1_MKT_RT_RNCTL	Set Up HRMS, Common Definitions, GL Integrations, Payroll to E1General Ledger, Request Market Rates, Request Market Rates	Query market exchange rates from the EnterpriseOne financials system. Either schedule the request or enter an ad hoc request.

Requesting Market Rates

Access the Request Market Rates page (Set Up HRMS, Common Definitions, GL Integrations, Payroll to E1General Ledger, Request Market Rates, Request Market Rates).

Request Date

Enter the current date.

To accommodate requests scheduled through PeopleSoft Process Scheduler, the system always overrides the entered request date with the current system date.

Rate Type

Select the rate type under which the imported values are to be stored in the Enterprise table. Values are established on the Market Rate Data table (RT_TYPE_TBL).

Market Rate Index

Select the market rate index under which the imported values are to be stored in the Enterprise table. Values are established on the Market Rate Index table (RT_INDEX_TBL). The default value is MODEL.

Target System

Select the node that you established for the integration with EnterpriseOne.

From Currency Range

Define the alphabetical range of currencies from which you're requesting the exchange rate.

For example, from GBP – RUR.

For a single from currency, select the same currency in both fields.

To Currency Range

Define the alphabetical range of currencies to which you're requesting the exchange rate.

For a single to currency, select the same currency in both fields. For example, to EUR – EUR.

The system retrieves the market rate for each currency code pair that falls alphabetically in the from and to currency ranges that you specify.

See Also

PeopleSoft Enterprise Human Resources PeopleBook: Enterprise Components

Preparing and Posting Accounting Lines to EnterpriseOne General Ledger

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

Generate Payroll for North America accounting lines.
Post Payroll for North America accounting lines.
View the transaction status.
Reset Payroll for North America accounting transactions.

Understanding GL Interface Processing Steps

After each confirmed payroll run, you:

Calculate and confirm payroll.
Synchronize currency exchange rates if needed.
Run the GL Interface (general ledger interface) PSJob process (PAYGL01), which creates the payroll accounting lines and enters them on the HR Accounting Line table.
4. Run the PNA Posting for GL Application Engine process (HI_NA_POST) to publish the data to EnterpriseOne General Ledger.

EnterpriseOne General Ledger processes the data when it is received.

GL Interface Process Description

You can run the GL Interface Application Engine process (PAYGL01) in one step or two separate steps:

(Optional) Prepare the distribution without generating the HR accounting lines.

Review and update the distribution results in the Review Payroll Distribution component.
(Required) Generate the HR accounting lines.

You can bypass the distribution step and directly create the accounting lines.

Posting for E1 GL Process Description

When you run the PNA Posting for GL process (HI_NA_POST), the system performs the following processing steps:

Consolidates accounting lines if the Consolidate Accounting Lines option is selected as a target system default or as a run parameter override.

See Configuring the Target Product and System.
Determines the cost center:
- Enters the cost center on the accounting line.
- Assigns the default cost center to transactions that do not have the DEPTID chartfield assigned.
Checks debit and credit balances if the balancing option is selected:

If they do not match, creates a suspense entry if a suspense account is defined for the GL business unit or generates an error without posting accounts if the suspense account option is not selected or the account is not defined.

If the foreign total amount nets to zero and domestic total amount does not, it assumes currency rounding and forces the domestic amount to net to zero.

See Understanding Currency Rounding.
Creates and publishes the PAYROLL_ACCTG_TRANSACTION XML service operation.

Note. You must set up the pay run IDs so that GL business units that integrate with EnterpriseOne are not combined in the same pay run ID with GL business units that do not integrate with EnterpriseOne.

See Creating Pay Run IDs.

Pages Used to Prepare and Post Payroll Accounting Lines

Page Name	Definition Name	Navigation	Usage
Non Commitment Accounting Information	RUNCTL_PAYGL01	Payroll for North America, Payroll Distribution, Prepare GL Information, Non-Commit Accounting Info, Non Commitment Accounting Information	Run the GL Interface process (PAYGL01A) to create payroll accounting lines in the HR Accounting Lines table.
Earnings	PAY_NACHK_DIST_ERN	Payroll for North America, Payroll Processing USA, Produce Payroll, Review Payroll Distribution, Earnings Payroll for North America, Payroll Processing CAN, Produce Payroll, Review Payroll Distribution, Earnings	View and update the distribution of payroll earnings.
Net Pay Liability	PAY_NACHK_NET_LIA	Click the Net Pay Liability link on the Earnings, Deductions, or Taxes page.	View and update the distribution of net pay liability and expense.
Deductions	PAY_NACHK_DIST_DED	Payroll for North America, Payroll Processing USA, Produce Payroll, Review Payroll Distribution, Deductions Payroll for North America, Payroll Processing CAN, Produce Payroll, Review Payroll Distribution, Deductions	View and update the distribution of payroll deductions.
Deduction Liability	PAY_NCHK_NET_LIA	Click the Deduction Liability link on the Deductions page.	View and update the distribution of deduction liability and expense.
Taxes	PAY_NACHK_DIST_TAX	Payroll for North America, Payroll Processing USA, Produce Payroll, Review Payroll Distribution, Taxes	(USA) View and update the distribution of payroll taxes.
Taxes (CAN)	PAY_NACHK_DIST_CTX	Payroll for North America, Payroll Processing CAN, Produce Payroll, Review Payroll Distribution, Taxes	(CAN) View and update the distribution of payroll taxes.
Tax Liability	PAY_NCHK_NET_LIA	Click the Tax Liability link on the Taxes page.	Use this page to view and update the distribution of tax liability.
Non-Commit Posting for GL	HPIP_NA_PST_RUN	Payroll for North America, Payroll Distribution, Prepare GL Information, Non-Commit Posting for GL, Non-Commit Posting for GL	Run the PNA Posting for GL process to prepare the accounting lines for posting and post them to EnterpriseOne General Ledger.
View GL Transaction Status	HPIP_PRCS_STAT	Payroll for North America, Payroll Distribution, Prepare GL Information, Review GL Transaction Status, View GL Transaction Status	View the transaction reply indicating the status of the data load into the EnterpriseOne staging table.
Non-Commit Reset Processing	PRCSRUNCNTL_NLC	Payroll for North America, Payroll Distribution, Prepare GL Information, Non-Commit Reset Processing, Non-Commit Reset Processing	Reset the Payroll for North America GL Interface PSJob process (PAYGL01A) before rerunning the process when reposting is necessary due to errors.

Generating Payroll for North America Accounting Lines

See Generating Payroll for North America Accounting Lines.

Posting Payroll for North America Accounting Lines

Access the Non-Commit Posting for GL page (Payroll for North America, Payroll Distribution, Prepare GL Information, Non-Commit Posting for GL, Non-Commit Posting for GL).

Enter the pay run ID that you want to process or specify the parameters to process an individual pay calendar.

Pay Run ID	You can select only from pay run IDs for which the GL Interface process has been run and the Posting for E1 GL process has not been run. If you need to reprocess a pay run ID, you must first run the GL Reset Run Flag process. The pay run ID cannot contain any GL business units that do not integrate with EnterpriseOne general ledger.
Override Indicator	Select to override the balance options set for the target product on the Configure Target System page. The other fields in this group box are available for entry only if Override Indicator is selected.
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.

Note. If two instances of the same payroll posting process run in parallel, such as each company within an organization processing Payroll for North America pay groups at the same time, there can be conflicts on the staging tables. To avoid such conflicts, run the posting process in series rather than in parallel.

Viewing the Transaction Status

Access the View GL Transaction Status page (Payroll for North America, Payroll Distribution, Prepare GL Information, Review GL Transaction Status, View GL Transaction Status).

Return Code

Possible return codes are:

0: Successful load on E1: No further action is required.

1: Account Number Mismatch: The account number of one of the lines of the payroll transaction does not match an account number previously assigned and cross-referenced during the Account initial or incremental load. No insert into the Z1 staging table was attempted.

2: Inserting Error: The insert of the lines of the payroll transaction into the Z1 staging tables failed due to some problem, such as a primary key was omitted. No lines were inserted into the Z1 staging table.

Resetting Payroll for North America Accounting Transactions

See Understanding the GL Reset Run Flag SQR Report Process (GLXRESET).

Controlling Area	Select a controlling area when you access the page. 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. You can view controlling areas on the View Controlling Areas page in the Common GL Objects menu.
Cost Center ID	Select a cost center when you access the page. The available values are the EnterpriseOne business units that you imported into the Enterprise Cost Center table. You can view cost centers on the View Cost Centers page in the Common GL Objects menu.
SetID	Select the setID for the department to be mapped. All setIDs are available for selection.
Department	Enter the department to be mapped to the cost center selected when you entered the page.

Request Date	Enter the current date. To accommodate requests scheduled through PeopleSoft Process Scheduler, the system always overrides the entered request date with the current system date.
Rate Type	Select the rate type under which the imported values are to be stored in the Enterprise table. Values are established on the Market Rate Data table (RT_TYPE_TBL).
Market Rate Index	Select the market rate index under which the imported values are to be stored in the Enterprise table. Values are established on the Market Rate Index table (RT_INDEX_TBL). The default value is MODEL.
Target System	Select the node that you established for the integration with EnterpriseOne.
From Currency Range	Define the alphabetical range of currencies from which you're requesting the exchange rate. For example, from GBP – RUR. For a single from currency, select the same currency in both fields.
To Currency Range	Define the alphabetical range of currencies to which you're requesting the exchange rate. For a single to currency, select the same currency in both fields. For example, to EUR – EUR.