Why are distribution gl_date created in prior periods for applied credit memos with rules? (Doc ID 956854.1)

Last updated on AUGUST 09, 2021

Applies to:

Goal

This note is consolidated into Note 1110573.1, Troubleshooting Credit Memos in Receivables

Why are distribution gl_date created in prior periods for applied credit memos with rules?

Applied credit memos are created specifically for a transaction. If

ra_customer_trx_all.previous_customer_trx_id is populated then this is an applied credit memo.

Example:

CM -
An applied credit memo is generated specifically against an invoice (in other words, ra_customer_trx_all.previous_customer_trx_id is populated)
Invoicing Rule = In Advance
Accounting Rule = Immediate
rule_start_date = 22-MAY-2009
receivable (REC) gl_date = 24-JUL-2009

INVOICE -
rule_start_date = 22-MAY-2009

CALENDAR -

Period        Status
May-09     Opened
Jun-09       Opened
Jul-09        Opened


RA_CUST_TRX_LINE_GL_DIST_ALL:

AMOUNT     GL_DATE           ACCOUNT_CLASS
-100               22-May-09           REV
100                 22-May-09          UNBILL

-100                24-Jul-09             REC
-100                24-Jul-09             UNBILL
      0                24-Jul-09             TAX

The above is from ra_cust_trx_gl_dist_all. The problem I'm discussing is line 1-2. These are the distributions. You notice that the distribution gl_date shows 22-MAY-2009 even though the CM REC gl_date shows 24-JUL-2009.

Solution

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