EGL9.1: Incorrect Monetary Amount/Exchange Rate For IUR Accounting Entries When Ledger is Different From the AP Business Unit’s GL Business Unit (Doc ID 1993859.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

9.1 bundle # 30.


Inter-unit receivable entries are not generating the correct monetary amount value when the GL Business Unit on the distrib line is different from the AP business unit’s GL business unit

REPLICATION STEPS
=================
Setup:
======
1. Posting method = Summary Control

2. AP BU BUY01 setup:
GL BU = US001
Payables Options shows Currency = GBP

3. GL BU US001 setup:
Currency = USD
Ledger Group = BUY01/RECORDING

4. GL BU US003 setup:
Currency = USD
Ledger Group = BUY01/RECORDING

5. GL BU GBR01 setup:
Currency = GBP
Ledger Group = GBR01/RECORDING

6. GBP USD rate on 5/30/2014 = 1.6754

Steps:
======
1. Create voucher
Voucher currency is GBP
Voucher total amount = 92.40
Voucher has 2 distrib lines with amounts 15.40 and 77
Voucher dist line 1 is linked to GL BU US003
Voucher dist line 2 is linked to GL BU GBR01
Invoice date = 05/30/2014
Accounting date = 01/03/2015
Exchange rate on the voucher = 1.6754

2. Post voucher

Results:
========
VCHR_ACCTG_LINE shows IUR lines as follows:

1. For distrib line 1:
RT_TYPE is blank (Should be COMM)
MONETARY_AMOUNT = 0 (Should be 25.8)

2. For distrib line 2:
RATE_MULT = 2.01051948 (Should be 1.6754)
MONETARY_AMOUNT = 154.81 (Should be 129.01)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms