Amount Applied Defaults To Amount More Than Is Remaining On The Transaction (Doc ID 2307981.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Receipts Related

ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
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
transaction amount.

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
increasing).



STEPS
-----------------------
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.



BUSINESS IMPACT
-----------------------
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.

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