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

Last updated on JUNE 21, 2023

Applies to:

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

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

	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

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