How to cancel an invoice

发票包含已冲销预付款明细行，发现其他明细行有错误时验证不能通过，不能修改错误明细行。处理方法如下：

1.Search issue invoice with prepayment apply to it.
2.Click On Actions and choose Apply/Unapply Prepayment
3.Select the prepaument and unapply it.
4.Then go back to invoice workbench and click Action button
5.Cancel invoice to test.（也可以直接修改明细行，不必取消发票）

其他相关参考资料如下：

HOW TO CANCEL AN UNAPPLIED PREPAYMENT [ID 1077300.6]
		Modified 27-NOV-2008     Type PROBLEM     Status PUBLISHED

Problem Description: 
=================== 

     You have submitted an advance (prepayment) to an employee.  The prepayment
     was greater than the total of the expense report.  The employee should 
     return the unused prepayment.

     If you create a credit memo, you cannot apply the prepayment to the credit
     memo.
 
Problem References: 
=================== 

     Oracle Payables User's Guide Release 11 Vol 1 page 4-118. 
 
Search Words: 
============= 

     apxinwkb, apxpawkb

Solution Description:
=====================

     Please perform the following to handle the refund:

     1. Navigate to Invoice Workbench (Invoices=>Entry=>Invoice).
     2. Create a "Standard" invoice type in the amount of the refund from the
        employee.
     3. Enter a description that you are retiring the prepayment.
     4. Create an invoice distribution for the amount of the refund
        and debit your cash account by entering the cash account in the account
        field.
     5. Approve the invoice.
     6. Choose the Actions button, select apply/unapply Prepayment Check the box
        and choose OK.
     7. Select the prepayment to which you want to apply the refund.
     8. Enter the refund amount to the "Amount to Apply" field. 
     9. Approve the new prepayment distribution on line or use the Payables
        Approval program from the Submit Request window.
    10. Choose the Apply/Unapply button to apply the prepayment amount to the
        invoice.
    11. Save


Solution Explanation:
====================

     This fully retires the prepayment and reduces the amount remaining on the
     invoice to 0.

 

 

Invoice With Prepayment Application Stuck On Line Variance Hold [ID 1142283.1]
		Modified 06-JUL-2010     Type PROBLEM     Status MODERATED

In this Document
  Symptoms
  Cause
  Solution
  References

---

 

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

 

Applies to:

Oracle Payables - Version: 12.1.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

On : 12.1 version, Invoice Issues & MassAdd

Due to Line Variance Hold unable to validate invoice or cancel prepayment application or cancel the invoice.
Distribution and line line totals = 0
Invoice header amount = 261
Invoice status Needs Revalidation
In the summary window, item + tax = 261


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, this invoice is stuck

Cause

=== ODM Cause Determination ===
BUG 9723477 - INVOICE WITH PREPAYMENT APPLICATIONS IS STUCK ON LINE VARIANCE HOLD

This issue is caused because prepayment was applied with 'Prepay on invoice' checked. This means that invoice header amount would be net of prepay amount.

Solution

=== ODM Solution / Action Plan ===

Following action plan / solution :

1- Apply unpublished patch 9463111:R12.AP.B and patch 9838486:R12.ZX.B in a test environment.

2-Then manually execute the script zx_pop_estb_id.sql delivered by the patch 9838486:R12.ZX.B
Follow the instructions given the patch ReadMe to pass the various input parameters to the script.

3-Then unapply the prepayment invoice and then reapply WITHOUT CHECKING the 'Prepay on invoice' checkbox in prepay apply/unapply window.

4- Migrate the solution as appropriate to other environments.