Interfacing RMA/ Credit Memo while Applying to Invoice With VAT Tax Inclusive Tax  Code Error - You can not apply more than the original line amount (文档 ID 1479785.1)

‍

A Return Merchandise Authorization (RMA) was created in Order Management  (OM) and need to be interfaced into Receivables (AR) as a normal  financial process.
After Return Merchandise Authorization (RMA) is processed by autoinvoice process, this autoinvoice process ends with error:

- A credit memo is attempting to overapply a specific transaction line, but overapplication is not allowed.
- The total amount of your credit memo cannot exceed the balance of the debit item it is crediting
- You can not apply more than the original line amount

The Tax code used is Inclusive Tax Code.

It seems as though the entire Credit Memo amount (Say x = line amount + tax, which is inclusive tax) is getting applied to the Invoice Line  Amount ignoring the tax line causing the error.

As a workaround, when AMOUNT_INCLUDES_TAX_FLAG is checked  (AMOUNT_INCLUDES_TAX_FLAG = Y), the interface completes with no error.   This should not be required as long as the Inclusive Tax is checked.

Steps to Reproduce:
Responsibility:   Order Management
Navigation:   Orders, Returns > Orders
1. Create a Return Merchandise Authorization (RMA)
2. Interface/Move the Return Merchandise Authorization (RMA) create to Receivables
Responsibility:   Receivables
Navigation:   Interfaces > Autoinvoice
Run Autoinvoice Master program
Go To:  Menu > View > Requests
Find the autoinvoice process executed
Review the log file generated and observed the process ends with the error mentioned before

A Return Merchandise Authorization (RMA) was created in Order Management  (OM) and need to be interfaced into Receivables (AR) as a normal  financial process.
After Return Merchandise Authorization (RMA) is processed by autoinvoice process, this autoinvoice process ends with error:

- A credit memo is attempting to overapply a specific transaction line, but overapplication is not allowed.
- The total amount of your credit memo cannot exceed the balance of the debit item it is crediting
- You can not apply more than the original line amount

The Tax code used is Inclusive Tax Code.

It seems as though the entire Credit Memo amount (Say x = line amount + tax, which is inclusive tax) is getting applied to the Invoice Line  Amount ignoring the tax line causing the error.

As a workaround, when AMOUNT_INCLUDES_TAX_FLAG is checked  (AMOUNT_INCLUDES_TAX_FLAG = Y), the interface completes with no error.   This should not be required as long as the Inclusive Tax is checked.

Steps to Reproduce:
Responsibility:   Order Management
Navigation:   Orders, Returns > Orders
1. Create a Return Merchandise Authorization (RMA)
2. Interface/Move the Return Merchandise Authorization (RMA) create to Receivables
Responsibility:   Receivables
Navigation:   Interfaces > Autoinvoice
Run Autoinvoice Master program
Go To:  Menu > View > Requests
Find the autoinvoice process executed
Review the log file generated and observed the process ends with the error mentioned before

Cause

This issue has been addressed in Bug 13959114 UNABLE TO CREATE CM THROUGH AUTOINVOICE FOR INCLUSIVE TAX CODES and Bug 16538225 REW:DOCUMENT CREATED MUST HAVE A NON-NEG TOTAL AMOUNT BECAUSE THE CREATION

Autoinvoice process is not honoring the amount_includes_tax_flag value from ar_vat_tax table of the tax used on the interface.
The version of the autoinvoice routine (raavhi.lpc - 120.28.12010000.8 or  lower), the process is not allowing to credit transactions as expected.

Solution

1. Bug Summary

1. Description
   When autoinvoice is used to import a credit memo and the tax code used by the credit memo is tax inclusive,  then AI results in a validation error if the credit memo amount is  applied in full.
   The document created must have a non-negative total amount because the creation sign for your transaction type is Positive.
   
   
2. Workaround
   None
   
   
3. Resolution
   Changed the CURSOR CM_OVERAPP_CHECK to also check the flag associated with the tax amount.
   The query drives of the interface lines and since the Auto Tax rows are not present in the interface table, the query will not pick those records.

2. Fixed File(s)

11i.AR.O: raavhi.lpc 115.17.15104.22

R12.AR.A:
ad_apply_patch.xml 120.3.12000000.2
raavhi.lpc 120.26.12000000.28

R12.AR.B:
raavhi.lpc 120.28.12010000.13

R12.AR.C:
raavhi.lpc 120.47.12020000.5

3. Recommended Patch(es)

11i.AR.O:    Patch 13959114
R12.AR.A :  Patch 16538225
R12.AR.B :  Patch 16538225
R12.AR.C:   No released patch available.

4. Solution Steps

1. Ensure that you have taken a backup of your system before applying the recommended patch.
2. Apply the patch in a test environment. 
3. Confirm the file versions listed above.
   You can use the commands like the following:
   strings -a $AR_TOP/filename |grep '$Header' 
4. Retest the issue. 
5. Migrate the solution as appropriate to other environments.
6. If the patch for your release is unavailable for download or needs a password, or if you experience any issues applying this patch, please  contact the E-Business Patching Community for assistance.

Still Have Questions?