My Oracle Support Banner

EAP: Payment History By Bank Report (APX2004) Has Incorrect Amount for Total Payments (Doc ID 2859981.1)

Last updated on APRIL 01, 2022

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The Payment History by Bank Report (APX2004) is run. It reports payments for two different Bank Accounts that are associated to the same Bank Code. One Bank Account has a default Currency Code of CAD, and the other Bank Account has a default Currency Code of USD.

The Total Payments for each Bank Account has the correct amount in the respective currency.

However, the grand Total Payments for the Bank, which is the Total Payment amount for each Bank Account added up, is incorrect. The grand Total Payment amount is adding the face value amount paid in CAD currency to the face value amount paid in USD currency, and displaying the grand Total Payment amount in CAD currency. So, if the amount in CAD is 1,000 and the amount in USD is 2,000, the grand Total Payments shown is 3,000 in CAD. The USD amount is not converted to the CAD amount in order to give the correct grand Total Payments in CAD. Currency conversion is not taking place.

STEPS
1. External Accounts is setup with two different Bank Accounts for the same Bank Code:  (Banking > Bank Accounts > External Accounts)
a. Bank = XXXXX, Bank Account = YYY / Currency Code = USD
b. Bank = XXXXX, Bank Account = ZZZ / Currency Code = CAD
2. Create 1st Voucher with Total = 230, Transaction Currency = USD, Bank = XXXXX, Account = YYY, Method = CHK  (Accounts Payable > Vouchers > Add/Update > Regular Entry)
3. Create 2nd Voucher with Total = 5,000, Transaction Currency = USD, Bank = XXXXX, Account = YYY, Method = CHK
4. Create 3rd Voucher with Total = 1,000, Transaction Currency = CAD, Bank = XXXXX, Account = ZZZ, Method = CHK
5. Create 4th Voucher with Total = 200, Transaction Currency = CAD, Bank = XXXXX, Account = ZZZ, Method = CHK
6. Pay 1st and 2nd USD Vouchers through Pay Cycle Manager  (Accounts Payable > Payments > Pay Cycle Processing > Pay Cycle Manager)
7. Pay 3rd and 4th CAD Vouchers through Pay Cycle Manager using a different Pay Cycle from Step 6
8. Run Payment Posting  (Accounts Payable > Batch Processes > Payment Payment Posting)
9. Navigate to Accounts Payable > Reports > Payments > Payment History by Bank
10. On the Payment History by Bank Run Control ID, specify the Date Range with the Payment Date of the Vouchers, and Print Options = Summary
11. Run Payment History by Bank (APX2004)
12. Check the Summary Payment History By Bank (APX2004) Report
13. On the last page, Total Payments for XXXXX = 6,430.00 CAD, which is incorrect -- 1,200 CAD + 5,230 USD does not equal 6,430 CAD

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.