EAR 9.2 : AR30009-Aging by Department Report Not Factoring in 'As of Date' on Run Control Page in the Balance Amount on the Report. (Doc ID 2968437.1)

Last updated on SEPTEMBER 11, 2023

Applies to:

Symptoms

AR30009 Aging by dept. report not showing results as expected - the items that are paid today(6/15/23) for example, if the report is ran for a date in the past for example 5/31/2023(today is 06/15/23) - the item shows current balance but not historic balance as of 5/31/23, System is not factoring as of date and always shows current data/balances.

The issue can be reproduced at will with the following steps:
1. Run aging process for a Business Unit(EGV05) from Accounts Receivable > Receivables  Analysis > Aging > Request Aging Process.
2. Run aging detail by dept report , use system date or current date(06/15/23) from Accounts Receivable > Receivables  Analysis > Aging > Aging by Department Report.
3. Open report and note down balance amount shown for item(PC-00020942) ,$4300.
4. Apply a partial payment of $300 for above item with today's date(06/15/23).
5. Run aging process again as in step-1.
6. Run aging detail by dept report as in step-2 with As of Date as 05/31/23.
7. Open report and notice that balance amount shown for item(PC-00020942) is $4000.


 

Changes

Cause

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