Aging 4 Bucket Report is Not Matching Aging 7 Bucket Report - Adjustment Issue (Doc ID 1609544.1)

Last updated on FEBRUARY 17, 2016

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

Aging 4 Bucket Report (ARXAGE) is not matching the Aging 7 Bucket Report (ARXAGMW) when Adjustments are generated in the future and Aging Report is run prior to Adjustment.

Example:
Issue:
Invoice Generated for 100.00 in 15-Dec-2013 and Posted
Receipt is applied to Invoice for 99.94 but a small amount, .06 cents is Adjusted via the Applications Form on the end of 31-JAN-2014. 
(Both the GL dates for the Receipt application and the adjustment is 31-JAN-2014).
Then, run the Aging 4 Bucket Report for 15-JAN-2014.

The invoice is showing the full amount, less the Adjustment.
This should show the full amount, since the adjustment is after the 15-JAN-2014 gl date.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms