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 |
---|---|---|
JRNL_GEN_DEFAULTS |
Select a reversal code. |
|
BUS_UNIT_INTFC6 |
Attach PeopleSoft Payables journal generator templates to PeopleSoft General Ledger business units. |
|
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:
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:
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:
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:
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
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
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