Why Zero Amount Shown for "Exchange Rate Variance" (ERV ) Distributions in Distribution Window of Invoice Workbench

The issue can be reproduced at will with the following steps:

1. Create a Purchase Order (PO) Matched invoice Foreign Currency invoice having difference Exchange rate for Invoice and PO.

2. Query the Invoice in Invoice Workbench

3. Click on All Distributions button

4. Check value for Amount field for Distribution type Exchange Rate Variance, its Zero

Solution:-


It is intended behaviour as per following generic business example:

If we assume that Functional Currency is USD

1) Create PO with currency CAD

PO Transaction

PO created for 1 CAD

Exchange rate:1.5 (CAD/USD)

Then:

Transaction Amount: 1 CAD
Functional Amount: 1.5 USD

2) Create AP Invoice matching to the PO Created

AP Invoice

Invoice created by matching to PO.

Exchange rate at the time of invoicing 2 (CAD/USD)

Then:


Transaction Amount: 1 CAD
Functional Amount: 2 USD

System will calculate Exchange Rate Variance with

Unable To Void Payment (prepayment) from Workbench or Payments Manager in r12

Issue:

Case 1: The check to be voided pays a standard invoice which was applied to a prepayment.
The prepayment application has not been fully unapplied and accounted.

Case 2: The check to be voided pays a prepayment invoice and there is a standard invoice that was applied to the prepayment invoice.
The prepayment application has not been fully unapplied and accounted on the standard invoice.



Solution for above case:-

Case 1:

1. In Invoice Workbench, verify that any prepayment application for the standard invoice has been fully unapplied.
2. If the invoice is in status Needs Revalidation, run validation for the invoice.
3. In Invoice Workbench, verify that the prepayment application has been accounted.  If not accounted, run accounting for the prepayment unapply event.
4. Retry Void of payment from Payments Workbench or Payments Manager

Case 2:

1. Identify the associated Standard Invoice.
2. In Invoice Workbench, verify that any prepayment application for the standard invoice has been fully unapplied.
3. If the invoice is in status Needs Revalidation, run validation for the invoice.
4. In Invoice Workbench, verify that the prepayment application has been accounted.  If not accounted, run accounting for the prepayment unapply event.
5. Retry Void of payment from Payments Workbench or Payments Manager

R12 Payables - Void Payment Restrictions

VOID PAYMENT RESTRICTIONS:

INVOICES PAID BY ANOTHER PAYMENT: When you void a payment, you cannot cancel a
related invoice if it was partially paid by a second payment.
Instead, when you choose Cancel Invoice, the system applies an "Invoice Cancel"
hold to the invoice for your reference. You can release the hold manually in
the Invoice Holds window.

CANCELLING ASSOCIATED INVOICES. If you attempt to cancel an invoice that has
been partially paid by another payment by using the Cancel Invoice
Action, instead of cancelling the invoice, Payables applies an Invoice Cancel
hold to the invoice. This hold is manually releasable.

CLEARED PAYMENTS: You cannot void a payment that the bank has already cleared.

PREPAYMENTS: You cannot void payment on a payment document that pays a
prepayment that you have applied to an invoice. You must first unapply any
prepayments, and then you can void the payment.