Setting Up the PeopleSoft Payables Revaluation Process

To set up your PeopleSoft Payables revaluation process, use the following components:

  • Accounting Entry Template (ACCOUNTINGENTRY).

  • Journal Generator Template (JRNLGEN_APPL_ID).

  • Procurement Control (BUS_UNIT_INTFC2).

  • Payables Definition (BUS_UNIT_TBL_AP).

This section provides an overview of the PS/AP Revaluation process and lists prerequisites.

Page Name

Definition Name

Usage

Journal Generator Template - Defaults Page

JRNL_GEN_DEFAULTS

Select a reversal code.

Procurement Control - GL Templates Page

BUS_UNIT_INTFC6

Attach PeopleSoft Payables journal generator templates to PeopleSoft General Ledger business units.

Payables Definition - Definition Page

BUS_UNIT_TBL_AP1

Select a revaluation posting option.

The PS/AP Revaluation process finds all unpaid, posted vouchers for the specified business units as of the specified date whose transaction currency is not the same as the base currency of the general ledger business unit. For each unpaid voucher, it uses the specified exchange rate and calculates a revaluation amount. The accounting entry consists of an unrealized gain or loss entry with a matching offset on the payables account.

Specify account numbers on the accounting entry template for unrealized gain and loss.

Use the Journal Generator Template - Defaults page (JRNL_GEN_DEFAULTS) to select a reversal code.

Navigation:

General Ledger > Journals > Subsystem Journals > Journal Generator Template > Defaults

Select a reversal code.

PeopleSoft General Ledger uses the Journal Generator template to handle reversals. The PeopleSoft Payables revaluation routing does not reverse entries because of document sequencing. Therefore, you must select one of these PeopleSoft General Ledger reversal codes: Beginning of Next Period, End of Next Period, or Next Day.

You should not select Do Not Generate Reversal, or your revaluation will be overstated.

Use the Procurement Control - GL Templates page (BUS_UNIT_INTFC6) to attach PeopleSoft Payables journal generator templates to PeopleSoft General Ledger business units.

Navigation:

Set Up Financials/Supply Chain > Business Unit Related > Procurement > Procurement Control > GL Templates

Specify the PeopleSoft Payables journal generator templates for the PeopleSoft General Ledger business units. Journal generator templates include accruals, payments, cancels, closes, revaluations, and cash clearings.

Use the Payables Definition - Definition page (BUS_UNIT_TBL_AP1) to select a revaluation posting option.

Navigation:

Set Up Financials/Supply Chain > Business Unit Related > Payables > Payables Definition > Definition

Select a revaluation posting option to determine how the transactions that you are revaluing are grouped.

Field or Control

Description

Unit (business unit)

The PS/AP Revaluation process creates one accounting entry for each business unit/transaction currency combination.

Supplier

The PS/AP Revaluation process creates one accounting entry for each supplier/business unit/transaction currency combination. Grouping does not cross business units. For a supplier that has both gains and losses, only the net gain or loss is posted to PeopleSoft Payables and then to PeopleSoft General Ledger.

Voucher

The PS/AP Revaluation process creates one accounting entry for each voucher.

Example: Defining Revaluation Posting Options

This table lists sample data for our example:

Business Unit

Supplier

Voucher

Loss/Gain

Transaction Currency

GBR01

VND1

VCHR1

100

GBP

GBR01

VND2

VCHR2

(50)

GBP

GBR01

VND2

VCHR3

25

GBP

Depending on the revaluation option that you select, the system generates the following entries:

  1. For the business unit.

    There is one balanced entry per business transaction currency combination. In our example, both suppliers have the same currency so there is only one entry. If they had different currencies, there would have been two entries.

    Business Unit

    Supplier

    Voucher

    Loss/Gain

    Transaction Currency

    GBR01

     

     

    75

    GBP

  2. For the supplier.

    There is one balanced entry per supplier, business unit, currency combination. The summation does not cross business units.

    Business Unit

    Supplier

    Voucher

    Loss/Gain

    Transaction Currency

    GBR01

    VND1

     

    100

    GBP

    GBR01

    VND2

     

    (25)

    GBP

  3. For the voucher.

    Each voucher creates a set of accounting entries; there is no summation.

    Business Unit

    Supplier

    Voucher

    Loss/Gain

    Transaction Currency

    GBR01

    VND1

    VCHR1

    100

    GBP

    GBR01

    VND2

    VCHR2

    (50)

    GBP

    GBR01

    VND2

    VCHR3

    25

    GBP