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.

Pages Used to Setup the PeopleSoft Payables Revaluation Process

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.

Understanding the PS/AP Revaluation Process

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.

Prerequisite

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

Journal Generator Template - Defaults Page

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

Navigation:

General Ledger, and then Journals, and then Subsystem Journals, and then Journal Generator Template, and then 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.

Procurement Control - GL Templates Page

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, and then Business Unit Related, and then Procurement, and then Procurement Control, and then 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.

Payables Definition - Definition Page

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

Navigation:

Set Up Financials/Supply Chain, and then Business Unit Related, and then Payables, and then Payables Definition, and then 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