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
Last updated on JUNE 07, 2016
Applies to:Oracle Receivables - Version 12.1.2 and later
Information in this document applies to any platform.
Attempting to create a credit memo and invoice through AutoInvoice. The following distributions created:
Create invoice with no tax line
Create and apply credit memo.
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.
RA_INTERFACE_LINES_ALL --> 1 line (LINE only)
RA_INTERFACE_DISTRIBUTIONS_ALL --> 2 lines (REC,REV)
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.
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