ITPub博客

首页 > IT职业 > IT职场 > Interfacing RMA/ Credit Memo while Applying to Invoice

Interfacing RMA/ Credit Memo while Applying to Invoice

IT职场 作者:chenshm329 时间:2018-12-28 11:11:05 0 删除 编辑

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 UNABLE TO CREATE CM THROUGH AUTOINVOICE FOR INCLUSIVE TAX CODES and 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

PROACTIVE TIP:
Applying higher versions of the files listed above can help you avoid known issues. Use Note 1584999.1 to help identify other patches containing higher versions of these files.

3. Recommended Patch(es)

11i.AR.O:   
R12.AR.A
R12.AR.B
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 for assistance.

Still Have Questions?

To discuss this information further with Oracle  experts and industry peers, we encourage you to review, join or start a  discussion in the .

To provide feedback on this note, click on the Rate this document icon at the top right corner of this note.



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17087603/viewspace-2286768/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-08-09

  • 博文量
    182
  • 访问量
    133574