Aging - 4 Buckets Report Is Not Showing Open Invoice And Credit Memo If Outstanding Amount and Individual Bucket Balances Each Net To Zero (Doc ID 3070514.1)

Last updated on FEBRUARY 03, 2025

Applies to:

Goal

Aging - 4 Bucket Report is not displaying open items consistently depending on the 'as of' date entered.

Using Receivables Responsibility

Navigate to Transactions>Transactions
1. Create Invoice with due_date 06-JAN-2024
2. Create Credit Memo with due_date 29-JAN-2024 for offsetting amount, (but do not apply)

3. From Concurrent Manager, submit Aging - 4 Buckets Report with parameters:
As of GL Date : 28-FEB-24
Report Summary : Invoice Summary
Show Open Credits : Age

Customer outstanding amount is zero but 'Current' and '1-30 Days' buckets display open balances with opposite sign

4. Rerun Aging - 4 Buckets Report with parameters:
As of GL Date : 31-MAR-24
Report Summary : Invoice Summary
Show Open Credits : Age

Customer outstanding amount is zero for all buckets (outstanding, current, 1-30 days) In this case the report is NOT showing invoice and credit all in the report

Solution

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