Earned Discount Gets Recalculated While Applying Receipt On Invoices - Invoice Balance Is Left Open With 0.01

(Doc ID 263404.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version: 11.5.0 to 11.5.10.3 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
ARXRWMAI - Receipts

Symptoms

Discount amount gets recalculated while the receipt application is saved.
The same could happen if the apply date is changed.

Example:

1) Define Payment Terms allowing 5% Discount and also flag Allow Discount on Partial Payments for these terms.
2) Enter Invoice with line amount 9810.70 (Quantity = 1, Unit Price = 9810.70) assign a tax code with Rate 0%
3) Enter Receipt with amount 10000.00
4) Apply the receipt to the invoice
This result in:
Amount Applied defaults = 9320.16
Earned Discount = 490.54
Balance Due = 0
At the bottom of the screen you get message: Discount Earned = 490.54, Total = 490.54.

There are 2 different issues depending on the code level you are:
5a) Discount always gets recalculated:
You save the applications or just tab through the fields of the application screen ==> earned discount amount gets changed to 490.53 and the balance due is changed to 0.01
5b) Discount gets recalculated if you change certain fields like Apply Date.
You save and everything is fine. But if you change the apply date (even it is just a dummy change) the discount gets changed
to 490.53 and the balance is shown as 0.01 open.

NOTE: Case 5b) only happens if 'Allow discount on partial payments' is flagged for the used payment terms.

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