SAP C4C. Currency conversion for quotation closing date

[former_member625116]

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.

[former_member497128]

Hi Andrey,

Based on your description, it seems that you are looking to see same unit of currency in report (instead of seeing all three different currencies)

If this is the case, then you can try as below:

-> Run the report

-> Go to view tab and in column fields, click on setting icon for key figure

-> select desired value in Currency Conversion, click ok and runt the report again.

After this you should be able to see the values in single currency.

If this is not working in your case or if i have missed anything to understand then i would request you to raise incident with details like report name, key figure name and your requirement in details and then someone from our side will check and assist you.

[former_member625116]

Hi, Saurav.

I know the feature you described. My question was about the data the comversion is made for.

If can be one for all quotations in report. E.g., today. But I need to make the conversion for the closing date of quote. And it is different almost for each quote. So the summ of conversion will be different for each quote.

Andrey.