Amount Applied Defaults To Amount More Than Is Remaining On The Transaction
Last updated on JANUARY 29, 2018
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Receipts Related
A large receipt is being applied to a transaction that is significantly less. The Amount Applied is defaulting to an amount that is more than the remaining amount on the transaction.
Amount Applied should not result in overapplication of a transaction.
AR: Always Default Transaction Balance for Applications
This profile option determines the default amount applied value that displays in the
Applications window, whether you enter applications directly or by using the Search
and Apply feature. The default value includes discount amounts, where applicable.
If you set the profile option to Yes, then the default amount applied is the remaining
If you set the profile option to No, or if a null value exists, then the following defaulting
rule is applied:
1. If the unapplied receipt amount is greater than or equal to the transaction, then the
default amount applied is the remaining transaction amount.
2. If the unapplied receipt amount is less than the remaining transaction amount, then
the default amount applied is the unapplied receipt amount.
3. If the unapplied receipt amount is negative, then the default amount applied is the
remaining transaction amount (to prevent the negative unapplied amount from
The issue can be reproduced at will with the following steps:
AR: Always Default Transaction Balance for Applications: No at User level
Transaction type "Invoice" has Allow Overapplication: checked
Create new transaction using a payment term 3% 20 NET 21 <--- this is the key - need a payment term that allows a discount
Enter 1 line on the transaction - total amount $50.00
Create receipt r51082 for $1000
Go to -Apply- form
Apply To pick the newly created transaction
--Amount Applied: $49.00 (this leaves a balance of 1.00)
--Discount: 0 <------------------------ be sure to null out discount amount
***the key to reproducing is having amount_remaining on the transaction LESS than the discount available
So now the transaction has remaining balance of $1.00 (and available discount amount of 1.50)
Create another receipt r51082-9 for $10000
Go to -Apply- form
Enter Apply To: choose the same transaction as above
Amount Applied defaults to 10,000 which is not correct.
The issue has the following business impact:
Due to this issue, users have to manually enter the Amount Applied when it defaults to the wrong amount.
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