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