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 laterInformation 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
- 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 |
|
|
- 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 |
- R09801: post the vouchers
- Run R04901A with the following settings:
- Processing options:
- PO 1: 'As Of' Date 11/30/2021
- PO 2: Update Option 1
- PO 3: Prepayment Remark blank
- Processing options:
- Run R04423D with its POs set as follows:
- Aging tab:
- Aging Specifications 1
- Date Type I
- Aging Method blank
- Aging Days
- Aging Category 1 0
- Aging Category 2 0
- Aging Category 3 0
- Aging Category 4 0
- Age Credits
- Print
- Hold Payment blank
- Recurring Voucher Information blank
- Remaining Payments 0
- Payment Information blank
- Include Payment Amounts blank
- Aging tab:
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 |