My Oracle Support Banner

Transaction Workbench Issue: Credit Memo Created via AutoInvoice Has Incorrect Accounting Which Causes Error to Be Raised: This action has been blocked to avoid inaccurate accounting entries (Doc ID 1470098.1)

Last updated on JULY 10, 2020

Applies to:

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

Symptoms

Attempting to create a credit memo and invoice through AutoInvoice.  The following distributions created:
 
Create invoice with no tax line
REC   4,460
REV   4,460
 
Create and apply credit memo.
REC  -4,248  
REV  -4,248
TAX    -212   <-- wrong, since Invoice has NO Tax, Credit memo is expected to not have TAX as well
 
In the Transactions form the following error occurs when attempting to incomplete the invoice:

This action has been blocked to avoid inaccurate accounting entries. Please contact Oracle Support Services
 
The Credits do not have any TAX line in RA_CUSTOMER_TRX_LINES_ALL, however the RA_CUST_TRX_LINE_GL_DIST_ALL shows a TAX line.
 
The tax line and tax distributions for this CM were submitted through RA_INTERFACE_DISTRIBUTIONS_ALL and RA_INTERFACE_LINES_ALL.
 
INVOICE:
 RA_INTERFACE_LINES_ALL --> 1 line (LINE only)
 RA_INTERFACE_DISTRIBUTIONS_ALL --> 2 lines (REC,REV)
 
CREDIT MEMO:
 RA_INTERFACE_LINES_ALL --> 2 lines (LINE,TAX)
 RA_INTERFACE_DISTRIBUTIONS_ALL --> 3 lines (REC, REV for LINE, TAX for Tax line)
 
As a result, even though there is no Tax line for Invoice, the applying CM has tax distributions.
 
The expectation is to add a validation not to create a tax line for CM when applying lines to an Invoice with no Tax line.

Cause

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
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps
 Still Have Questions?
References


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