My Oracle Support Banner

Multiple Lines Credit Memo created from Advanced Collections Dispute has Incorrect Tax (Tax is duplicated on all lines) (Doc ID 2754230.1)

Last updated on FEBRUARY 22, 2021

Applies to:

Oracle Advanced Collections - Version 12.1 and later
Oracle Receivables - Version 12.1 and later
Information in this document applies to any platform.


Credit Memo is created with incorrect Tax % and Amount
It happens when there are more than 1 lines in the Invoice and create a Partial Dispute on the invoice from the Collections form
Dispute section=Total
The issue is noticed with Standard Tax as well as Inclusive Taxes
The issue is not reproduced if there is 1 Line in the Credit Memo or Invoice, or if Dispute is created for 100%

The issue can be reproduced at will with the following steps:
1. Lets assume that a dispute is created on an Invoice that has 2 lines and 15% TAX
Line 1 =100 + 15% Tax =100 + 15 =115 
Line 2 =200 + 15% Tax =200 + 30 = 230
Total = 345

This screenshot is taken from Receivables Responsibility 
NAV : Transactions --> Transactions 

2. Create a Dispute on this Invoice 
Collections Agent Responsibility 
NAV Collections form
Query up the customer using Organization field in Collections Header.
Go to Transactions Tab. Set the due date from and To to see the transaction created.
Select the invoice and click on Transaction Details screen.
Create a dispute using Dispute Pecent (less than 100%) and Dispute section=Total


3. Approve the Dispute as per your setup along with Workflow Background Process so that Credit Memo is created

4. Review the Credit memo in Receivables Responsibility
NAV : Transactions --> Transactions


Notice that same tax is calculated on all lines.

The expected Tax should be 
Line 1 =-76.33+ 15% Tax =-76.33 + -11.45 = -87.78
Line 2 = -152.67 + 15% Tax =-152.67+ -22.90= -175.57
Total = -263.35





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.