3364107 - Exchange Rate for Key figure Invoiced Net Value in Invoice Volume Report

The Invoiced Net Value in the Invoice volume report is not as expected because the system is considering the exchange rate even though the currency in the customer invoice is USD and the display currency is also USD in the report.

SAP Business Bydesign

1. Go to the Customer Invoicing work center.
2. Select the Reports view.
3. Find the Invoice Volume Report.
4. Open the report in web browser.
5. Select the Invoice ID XYZ(XYZ is the ID of the Customer Invoice) in the Selection .
6. Select the Go button.
7. You will see that the report shows the Invoiced Net value as 101.1234 USD is the Invoiced net value amount of invoice in the report).
8. However if you see the Customer Invoice XYZ, you can see the net value is 100 USD.
9. You would like to know why the Invoiced Net value is not 100 USD.

In the Report Invoiced Net Value key figure always stores the data in backend in the currency based on the country of the company. In your case, the currency based on the country of the company is AUD , hence the system converted the Invoiced Net value field from USD-> AUD and stored the same in the backend.

When invoice XYZ was created, the system considered the active exchange rate for USD->AUD for Invoice date. This value was saved in the backend. However, the exchange rate from USD -> AUD was changed after the invoice was created.

The Invoice volume Report considers the exchange rate based on the date maintained in selection field Display Currency - Conversion Date while displaying the Invoiced Net value field. If you have maintained the current date in this field, the system considers the exchange rate for current date and displays the Invoice net value based on the same.

Note: USD and AUD are considered as example currencies, the behavior is applicable for all currencies

This is the current system behavior.

2464846 - Net Value Showing in Different Currency in Sales Order Item Data Source and Sales Order Document or Customer Invoice Item Data Source and Invoice Document

1892948 - You Get the Incorrect Exchange Rate in Invoice Volume Report

Invoice Volume Report; Company Currency ; Exchange Rate; , KBA , SRD-CRM-INV , Customer Invoicing , Problem