SAP C4C. Currency conversion for quotation closing date

Hi!

We use SAP C4C standalone. The functionality of opportunities and sales quotes is used. There are 3 currencies that are used in the system and we specify exchange rates for them.

Each sales quote has it's own date of closing - the date, when the bill was paid. We enter it manually in our custom Z-field. As exchange rates change every day, we will have the different amounts in quotes for currency the exchange was made for. E.g. we will have 1000 RUB for 100 EUR at 11.11.2019 and 1100 RUB for 100 EUR at 12.11.2019.

So to count the correct net value and other key figures in our native currency correctly we need to make the currency exchange for the date the sales quote was closed in our custom Z-field.

I searched for something I need in relative selections for the field - "Display Currency - Conversion Date" in report. But didn;t find. There is one value for all data in report.

Also I didn't find the way to make my own relative selection for date in my Z-field. Didn't find the needed features when creating key figures.

So, is there any way to solve this issue? To do currency conversion in report for the quotation closing date.

Best regards, Andrey.