Different exchange rate in the customer invoice volume report and JE

[SAPSupport]

Dear SAP，

We found the exchange rate used in the invoice volume report is not the same in the JE. So the invoice total amount in the report is different than the JE. 

for example, the invoice A, with total amount= 14000 SGD. the invoice currency is SGD, company currency is CNY. 

In the JE, system picked the rate 5.4418, the invoice amount in company currency is 76.185,20 CNY. 

However, in the invoice volume report, the invoice A shows a different total value in CNY, it is 75.544,00 CNY. 

We want to know the reason.

Thanks.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

The way the currency conversion / exchange rate is determined in the invoice volume report is different from the financial documents or reports. In this case, in the invoice volume report, the system determines the exchange rate based on the time of creation of the invoice, and uses the exchange rate that is active at this moment in time to calculate exchange rate from SGD into CNY.

In this example, the invoice A was created 02.09.2024. invoice volume report uses 02.09.2024 00:00:00 as the creation date. Then check the exchange rate history.

5.396 valid from 31.07.2024 15:58, created at 8/1/2024  1:02:02 AM.

5.4418 valid from 31.08.2024 15:58, created at 9/2/2024  1:32:44 AM.

Since 5.4418 was created after 02.09.2024 00:00:00, so it was not picked. Instead, the rate 5.396 was picked and calculated. So the invoice total value = 14000*5.396=75.544,00 CNY in the report.

However, for the journal entry, the actual creation time was used, which is 02.09.2024 03:32. And the rate 5.4418 was picked.

This causes the different total amount got displayed in the report and in the journal entry.

See more explanation in the KBA: 2393488 - Invoice Total is Invoice Volume Report is Different Than Journal Entry

https://me.sap.com/notes/2393488

Thanks,

Adie