Setting Up Multicurrency Tables

The pages that define the currency codes, rate types, and exchange rates that are used for currency conversion are common to all financial, manufacturing, and distribution applications. Set up the currency tables once for use by all applications.

To set up your multicurrency tables, use the following components:

  • Currency Code (CURRENCY_CD_TABLE).

  • Accounting Entry Template (ACCOUNTINGENTRY).

  • Accounting Entry Definition (JRNLGEN_DEFN).

This section discusses how to assign gain or loss ChartFields. It also discusses how to specify a journal template.

Pages Used to Set Up Multicurrency Tables

Page Name Definition Name Usage

Currency Code Page

CURRENCY_CD_TABLE

Add or update a currency code, and confirm that the currencies that you use in your business are already defined.

PeopleSoft Payables uses currency codes in reporting and displays them on pages throughout the system to identify the currency of vouchers, payment, and base currency amounts. PeopleSoft populates this table with many of the common currencies in use, using the International Standards Organization (ISO) code as the identifier. The system also uses currency codes to determine precision for rounding.

If you change the number of decimal places for a currency code definition—for example, three decimal places instead of two decimal places—you must also restart the Application Server to see this change on the voucher component.

See Accounting Entry Template Page

Accounting Entry Template Page

ACCTG_TEMPLATE_AP

Define or modify an accounting entry template.

Accounting Entry Definition Page

JRNL_GEN_ACCTG_DEF

Identify the system source that distributes data to your general ledger and the record and field names for the Accounting Entry table.

Accounting Entry Template Page

Use the Accounting Entry Template page (ACCTG_TEMPLATE_AP) to define or modify an accounting entry template.

Navigation:

Set Up Financials/Supply Chain, and then Common Definitions, and then Accounting Entry Templates, and then Templates, and then Accounting Entry Template

Assign ChartFields for realized gain, realized loss, unrealized gain, and unrealized loss to each PeopleSoft Payables business unit.

Unique account numbers enable the PS/AP Revaluation Application Engine process (AP_REVALUE) to post gains and losses to separate accounts.

Note:

Because you associate each supplier with a different accounting template, each supplier can have a different set of accounts for posting gains and losses.

To access the Currency Code page, use the navigation: Set Up Financials/Supply Chain, and then Common Definitions, and then Currency, and then Set up Currency Code

Accounting Entry Definition Page

Use the Accounting Entry Definition page (JRNL_GEN_ACCTG_DEF) to identify the system source that distributes data to your general ledger and the record and field names for the Accounting Entry table.

Navigation:

General Ledger, and then Journals, and then Subsystem Journals, and then Accounting Entry Definition

Specify the journal template to use when transferring revaluation information to general ledger for each PeopleSoft Payables business unit.