2576653 - How is the Exchange Rate Derived Considering Different User's Time Zone

SAP Knowledge Base Article - Public

2576653 - How is the Exchange Rate Derived Considering Different User's Time Zone

Symptom

You have business users across different time zones accessing the system and posting documents in foreign currency. You wonder how the system validates the applicable exchange rate for the different users in different time zones.

Environment

SAP Business ByDesign

Reproducing the Issue

For posted documents, you may check the exchange rate derived by the system in the Journal Entry, which can be found as follows:

  1. Go to General ledger work center
  2. Go to Journal Entries view
  3. Open the relevant journal entry.

Resolution

The exchange rates are always stored in UTC time zone.

For example, a user with time zone settings in UTC+8 creates a supplier invoice with posting date on 25.07.2017. When creating the document, the system always appends time as 23:59:59 to the posting date, hence 25.07.2017 23:59:59. The user time zone is then considered for the exchange rate logic derivation. Since the user has time zone as UTC+8, the UTC time to be considered for exchange rate is 25.07.2017 15:59:59

Therefore, to derive the exchange rate, the system looks in the exchange rate table (in UTC) for the valid rate on 25.07.2017 15:59:59 UTC

In order to check user's time zone, please follow below steps:

  1. Go to Application and User Management work center.
  2. Go to Business Users view.
  3. Highlight the user and click Edit Attributes.

In case you do not have access to Application and User Management, you can check only your own user's time zone by clicking Personalize -> My Settings at the top of the screen on the right-hand side.

Keywords

Exchange Rate. Time Zone. Foreign Currency. , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions