Currency Conversion

[former_member355106]

Hello together,

in our model there are existing different account balances for different dates like:

12.09.2021 500 USD -> 450 EURO

13.09.2021 520 USD -> 470 EURO

14.09.2021 1900 USD -> 1700 EURO

TOTAL 2620 USD

Currency Conversion of SAC is using the date where the entry of the balance was created to make the currency conversion. So if there exists an account balance for the date 12th of November the system is looking inside the currency conversion table if the exists a currency conversion date for the same date and converts it to (Example) 450 EURO.

But does there exists a possibility to change that? We need the system to take the sum of all values in USD (here 2620 USD) and to convert by using the todays exchange rate.

We were thinking of creating a new data field with today's date that is used inside the currency conversion logic so always the current date would be uset but we could not find a way to do so. We could not find a formula for todays date inside our model.

Any hints would be nice. Thank you.

BR/

Oliver

[William_Yu]

Hi, oliver76,

When you create currency conversion measure either in story or model, you always has an option to define the date, it's not necessary to be the booking date. If you select a future date from now(far away), system will always use the latest currency rate(very likely the current date rate) in your currency table.

Best regards, William

[former_member355106]

Dear William, thank you very much for your time and reply.

The screenshot you have put in your answer. Where in the system I can it? I was checking the currency conversion table and there it looks different.

Saludos,

[William_Yu]

Hi oliver76,

You don't have to do anything in your rate table for this. Instead of using 'Default Currency'(which convert from 'Currency' by using the booking date), you can create your currency conversion cross calculation/measure from story or from model( only for new model).

My screenshot is taken from the currency conversion measure creation from new model. You can try to create currency conversion cross calculation/measure from story(demo video), it has a very similar UI.

Best regards, William