Administering the Integration with EnterpriseOne General Ledger

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

Map cost centers to the Payroll for North America System.
Retrieve currency exchange rates.

Note. The General Ledger interface provides flexible integration between Payroll for North America and General Ledger. Make sure you work in conjunction with your general ledger staff to use this interface.

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

You must also perform the setup tasks in the following menus:

Set Up HRMS, Common Definitions, GL Integrations, Common GL Objects
Set Up HRMS, Common Definitions, Chartfield Configuration.
Set Up HRMS, Product Related, Payroll for North America, GL Interface.

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

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

This section provides an overview of cost center mapping for Payroll for North America integration with EnterpriseOne General Ledger and discusses how to map cost centers to departments and set IDs.

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

Page Name	Object 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.

Mapping Cost Centers to Department and SetID

Access the Map Departments to Cost Center page.

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.

Retrieving Currency Exchange Rates

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

This section provides overviews of the 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 the Enterprise payroll systems 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 message, converts it to a synchronous message, and publishes it.
The Integration Server sends back the MARKET_RATE_SYNC response message 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 Integration Broker subscription to the MARKET_RATE_SYNC message 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 amount in different currencies on both the detail and sum (balance) level, there is a potential rounding issue. The problem arises from the fact that 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 prevent this problem, 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 account that is used is the one that the user specified as the suspense account on the setup for the GL business unit.
  
  If no suspense account has been specified for the GL BU, the rounding adjustment entry does not get created.
- The description field says Rounding Adjustment Entry.

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.