My Oracle Support Banner

How Can The Adjustment GL Date Be Prior To The Invoice GL Date? (Doc ID 2652158.1)

Last updated on MARCH 25, 2020

Applies to:

Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

Aging - 7 Buckets by Account Report does not balance to the General Ledger.

The AR Reconciliation Report is showing difference that matches the AR to GL Difference.

The imbalance is due to adjustments with a gl_date that is before the gl_date of the transaction it is created against.

EXAMPLE:

AR_ADJUSTMENTS_ALL
ADJUSTMENT_ID AMOUNT GL_DATE CUSTOMER_TRX_ID EVENT_ID
11111 100 30-SEP-2019 33333 55555
XLA_EVENTS
EVENT_ID APPLICATION_ID EVENT_TYPE_CODE EVENT_DATE
55555 222 ADJ_CREATE 30-SEP-2019
RA_CUST_TRX_LINE_GL_DIST_ALL
CUST_TRX_LINE_GL_DIST_ID CUSTOMER_TRX_ID AMOUNT GL_DATE LATEST_REC_FLAG ACCOUNT_CLASS
44444 33333 100 01-OCT-2019 Y REC
AR_PAYMENT_SCHEDULES_ALL
PAYMENT_SCHEDULE_ID CUSTOMER_TRX_ID AMOUNT_DUE_ORIGINAL AMOUNT_DUE_REMAINING STATUS GL_DATE GL_DATE_CLOSED AMOUNT_ADJUSTED
77777 33333 100 0 CL 01-OCT-2019 30-SEP-2019 -100

 

 

 

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.