Revenue Policy Gives Unexpected Revenue/Unearned-Revenue Accounting (Doc ID 401854.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version: 11.5.10.0 to 11.5.10.3 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
EXECUTABLE:RAXTRX - Autoinvoice Import Program

Symptoms

Revenue policy gives unexpected revenue/unearned-revenue accounting in AR transaction:

EXPECTED BEHAVIOR
Expect the invoice imported by Autoinvoice to have Revenue line instead of Unearned under the conditions below:

STEPS
The issue can be reproduced at will with the following steps:

1. Receivables responsibility
2. Setup the Revenue policy as follows:
Standard Refund Policy = 0
Payment Term Threshold = 90
First, Second, Third Selection = null

3. Create Sales Order  with Payment terms = Current 60, defined as follows:

Payment Terms
Name = Current 60
'Credit Check' checked
Payment Schedule region
Seq = 1
Relative Amount = 100
Day of Month = 1
Months Ahead = 3

4. Run AutoInvoice.
The invoice generated has :
Date = GL Date = 25-May-2006
Due Date = 02-Aug-2006
Diff = 67 < 90 so Revenue account should be used

5. Check the Accounting, see Unearned Revenue

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