Earned Discount Gets Recalculated While Applying Receipt On Invoices - Invoice Balance Is Left Open With 0.01
Last updated on AUGUST 24, 2016
Applies to:Oracle Receivables - Version: 11.5.0 to 18.104.22.168 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
ARXRWMAI - Receipts
Discount amount gets recalculated while the receipt application is saved.
The same could happen if the apply date is changed.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms