My Oracle Support Banner

E1: 04: The "As-Of” Open A/P Details with Aging report (R04423D) does not show aging if the Aging Specifications come from the A/P Constants (P0000) (Doc ID 2831224.1)

Last updated on DECEMBER 31, 2021

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When running the "As-Of” Open A/P Details with Aging report (R04423D), the PDF does not show any amounts in the aging columns even if vouchers qualify. This only happens if the first processing option on the Aging tab, “Aging Specifications”, is set to 1 (one): Age on due date using A/P Constants' aging days.

 

STEPS TO REPRODUCE

  1. P0000: set aging in A/P Constants as follows:
 

Aging Days 1

30

Aging Days 4

120

Aging Days 2

60

Aging Days 5

150

Aging Days 3

90

 

 

 

  1. P0411: create vouchers with the following data for a supplier:

Doc No.

Invoice & Service / Tax Date

Due Date

Discount Due Date

G/L Date

Gross & Open Amounts

 

1

10/14/2021

11/30/2021

11/30/2021

10/21/2021

8,526.00

2

10/14/2021

11/30/2021

11/30/2021

10/21/2021

9,164.00

3

10/14/2021

12/31/2021

12/31/2021

10/29/2021

36,018.00

4

11/8/2021

1/7/2022

12/30/2021

11/30/2021

8,526.00

5

11/8/2021

1/7/2022

12/30/2021

11/30/2021

8,526.00

6

11/30/2021

12/24/2021

12/30/2021

11/30/2021

35,226.30

 

  1. R09801: post the vouchers

  2. Run R04901A with the following settings:
    1. Processing options:
      1. PO 1: 'As Of' Date                        11/30/2021
      2. PO 2: Update Option                    1
      3. PO 3: Prepayment Remark            blank
  1. Run R04423D with its POs set as follows:
    1. Aging tab:
      1. Aging Specifications                     1
      2. Date Type                                    I
      3. Aging Method                              blank
      4. Aging Days
        • Aging Category 1              0
        • Aging Category 2              0
        • Aging Category 3              0
        • Aging Category 4              0
      5. Age Credits
    2. Print
      1. Hold Payment                              blank
      2. Recurring Voucher Information      blank
      3. Remaining Payments                    0
      4. Payment Information                   blank
      5. Include Payment Amounts            blank

  

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.