Reports Issue: Unapplied Receipt Register Shows a Receipt as Unapplied Even Though It Is Fully Applied (Doc ID 223822.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 11.5.0 to 11.5.10.3 [Release 11.5.0 to 11.5.10]
Information in this document applies to any platform.

Symptoms

The following scenarios cause a fully applied receipt to still appear on the Unapplied Receipt Register.

Case 1
------
After the receipt has been created and applied, the amount of the receipt is reduced.
example:
1. Create transaction for 3,81 eur, exchange rate 0,0639 and complete the transaction.
2. Create receipt for amount 127,49 eur, exchange rate 0,0639
3. Apply the receipt to transaction from step 1.
4. Modify the receipt amount into 3,81 and save.

Verify the details in the table AR_PAYMENT_SCHEDULES_ALL,  STATUS = CL  ACCTD_AMOUNT_DUE_REMAINING=.01
In AR_RECEIVABLE_APPLICATIONS_ALL All, for UNAPP-records,  the sum of Acctd Amt Applied From = -.01

This receipt will occur on the Unapplied Receipts Register.


Case 2
------
The receipt has been applied to several invoices including a credit memo or negative invoice.

example:
inv1 226.87 DEM = 116 EUR
inv2 226.87 DEM = 116 EUR
inv3 226.87 DEM = 116 EUR
inv4 226.87 DEM = 116 EUR
inv5 226.87 DEM = 116 EUR
cm  -226.87 DEM = - 116 EUR

The receipt is entered with an amount of 907.48, all 6 transactions are applied to the receipt.
During receipt application rounding entries are created to get the receipt closed completely for one of the invoices.

If now the credit memo and exactly this invoice are unapplied from the receipt the receipt still remains closed but will show the 0.01 cent on report unapplied receipt register report. Also ar_payment_schedules_all.acctd_amount_due_remaining shows -0.01 cent as open even the amount_due_remaining is 0.00.

This corruption is not very common as it is not typical to enter the data exactly in this way.

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