My Oracle Support Banner

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

Last updated on FEBRUARY 12, 2019

Applies to:

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


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. 

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.





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

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