Statements: Interest Not Calculated if the Receipt is Entered After Statement Date (Doc ID 433829.1)

Last updated on MAY 19, 2016

Applies to:

Oracle Receivables - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
EXECUTABLE:ARXSGP - Statement Generation Program

Symptoms

No finance charges are calculated for an invoice that has been paid by a receipt entered in the next period, but prior to running statements. 

Example:
The problem is the customer runs statements on the 5th of every month for the previous month end. 

The following example will explain the problem.

1. Invoice is due on 15-SEP-06.
2. A receipt is entered on 05-OCT-06 to pay off that invoice. All dates (apply, gl, receipt) are for 05-OCT-06
3. Statements are run on 05-OCT-06, statement date is 30-SEP-06.

The invoice is included on the statement but it contains no charges. The log file contains the following:

Currency code : USD
Payment schedule id : 96075
Customer trx id : 213995
Class : INV 
Gl date : 30-SEP-06
Apply date : 30-SEP-06
Amount due remaining : 0 
Lines remaining : 0
Tax remaining : 0
Freight remaining : 0
Charges remaining : 0
Days late : 15
get new finance charge : last_rec = 0, sqlerrd = 0

The finance charge module is not calculating finance charges because it shows the invoice balance as 0, even though it had a balance as of the statement date and should have charges applied. The invoice will show a past due balance on the aging reports.

.

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