My Oracle Support Banner

Revenue Distributions for a Negative Sign Credit Memo are not Following the Percentages Amounts as in the Accounting Rule Setup (Doc ID 2729091.1)

Last updated on JANUARY 08, 2021

Applies to:

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

Symptoms

The Revenue and Unearned Revenue percentages calculated for a Credit Memo with negative sign are not following the percentages as in the Accounting Rule setup.

The negative credit memo is a partial one, created using Actions > Credit menu option with Rule Method: Prorate, and after a positive sign credit memo was previously applied to the invoice.

 

Steps to reproduce:

1. Create Transaction Type A: as Invoice, Any Sign, Allow Overapplication
2. Create Accounting Rule A: 3 Months, Fixed, Non Deferred with schedule as:

    Period    Percent .
       1       33.3333
       2       33.3333
       3       33.3334

3. Create Transaction Type B: Credit Memo, Negative Sign, Allow Overapplication
4. Create Transaction Type C: Credit Memo, Positive Sign, Allow Overapplication
5. Create Invoice # INV1 with Transaction Type A, Invoicing Rule: Advance Invoice, with single line with Accounting Rule A and amount 10000

The distributions of the Invoice show:

PERCENT AMOUNT ACCOUNT_CLASS
       100    10000    REC
       100    10000    ROUND
 33.3333  3333.33    REV            
 33.3333  3333.33    REV          
 33.3334  3333.34    REV       
-33.3333 -3333.33   UNEARN
       100    10000    UNEARN
-33.3333 -3333.33   UNEARN
-33.3334 -3333.34   UNEARN


6. Create positive sign credit memo by querying the invoice on step 5, and use menu option Action > Credit
    Enter Transaction Type C, Transaction Number: CMPOS, Rule Method: Prorate , partial amount: +2000, save.

The distributions for the positive sign Credit Memo show:

PERCENT AMOUNT ACCOUNT_CLASS
100            2000   REC
100            2000   ROUND
100            2000   REV
-100         -2000   UNEARN
100            2000   UNEARN

7. Create negative sign credit memo by querying the invoice on step 5 and use menu option Action > Credit, 
    Enter Transaction Type B, Transaction Number: CMNEG, Rule Method: Prorate , partial amount -5000, save.

The distributions for the negative sign Credit Memo show:

PERCENT   AMOUNT  ACCOUNT_CLASS
      100       -5000  REC
      100       -5000  ROUND
44.4444   -2222.22  REV            
27.7778   -1388.89  REV            
27.7778   -1388.89  REV
-44.4444   2222.22  UNEARN
       100      -5000  UNEARN
-27.7778   1388.89  UNEARN
-27.7778   1388.89  UNEARN

When it is expected to be the same as the invoice (see step 5 above).

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.