My Oracle Support Banner

EAP: Regular Voucher Applied to Prepaid Voucher Is Not Displayed on the Payables Open Liability Report (APY1406) (Doc ID 3047962.1)

Last updated on SEPTEMBER 17, 2024

Applies to:

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

Symptoms

A Regular Voucher that was paid by being applied to a Prepaid Voucher, is not displayed on the Payables Open Liability Report (APY1406) if the As of Date specified on the Run Control ID is the date that the Regular Voucher was still opened. This problem only occurs if the Prepaid Voucher was paid either through Express Payment or the Pay Cycle.

If the Prepaid Voucher was paid by recording a manual payment, the Payables Open Liability Report will display the Regular Voucher.

STEPS TO REPLICATE
1. Accounts Payable > Vouchers > Add/Update > Regular Entry
2. Add a Prepaid Voucher
    a. Voucher Style = Prepaid Voucher
    b. Supplier ID = xxxxxxxxxx
    c. Invoice Date and Accounting Date = 09/01/2023
    d. Voucher > Payments page, click Express Payment to pay the Voucher
3. Express Payment page
    a. Change the Date to 09/15/2023
    b. Click Create Payment
    c. Print Checks
4. Voucher > Payments page for the Prepaid Voucher - Payment Date = 09/15/2023
5. Add a Regular Voucher
    a. Voucher Style = Regular Voucher
    b. Supplier ID = xxxxxxxxxx
    c. Invoice Date and Accounting Date = 09/01/2023
    d. Voucher > Payments page, check the Hold Payment box with Hold Reason = Other
6. Accounts Payable > Batch Processes > Vouchers > Voucher Posting
7. Run Voucher Posting to post the Prepaid Voucher and Regular Voucher
8. Accounts Payable > Reports > Voucher Reconciliation > Payables Open Liability
9. Run the Payables Open Liability Report
    a. As of Date = 09/02/2023
    b. As of Date Type = Accounting Date
    c. Check the Include Prepayment box
    d. Supplier ID = xxxxxxxxxx
10. Payables Open Liability Report - Both the Prepaid Voucher and Regular Voucher are displayed
11. Voucher > Payment page for the Regular Voucher - Un-check the Hold Payment box
12. Accounts Payable > Payments > Manual Payment and Prepayment > Apply Vouchers to Prepayment
13. Display the Prepaid Voucher
      a. Apply Vouchers to Prepayment page, click Search
      b. Check the Select box for the Regular Voucher
      c. Click Copy Vouchers
      d. Under Applied Voucher, check the Select box for the Regular Voucher
      e. Click Apply
      f. Status for the Regular Voucher changes from Unapplied to Applied
14. Voucher > Payments page for the Regular Voucher
      a. Action = Prepayment Applied
      b. Payment Date = 09/15/2023
15. Run the Payables Open Liability Report
      a. As of Date = 09/15/2023
      b. As of Date Type = Accounting Date
      c. Check the Include Prepayment box
      d. Supplier ID = xxxxxxxxxx
16. Payables Open Liability Report - Both the Prepaid Voucher and Regular Voucher are no longer displayed, which is correct
17. Run the Payables Open Liability Report
      a. As of Date = 09/02/2023
      b. As of Date Type = Accounting Date
      c. Check the Include Prepayment box
      d. Supplier ID = xxxxxxxxxx
18. Payables Open Liability Report - The Regular Voucher is not displayed, which is incorrect since the Regular Voucher was still opened on 09/02/2023 and was not paid until 09/15/2023

Changes

 

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
Changes
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.