Symptom
Foreign Currency Remeasurement Method 'A002 - Lowest value' and Foreign Currency Remeasurement Principle '002 - Lower Value' are applied for a Company and related Set of Books (SoB).
For a particular bank g/l account XYZ the valuation at key-date would imply an Exchange Rate (EXR) Loss.
You notice, however, that Key Date Valuation Amount equals Historic Valuation Amount.
Therefore no Loss will show for bank g/l account XYZ.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Payment Management work center.
- Go to Foreign Currency Remeasurement Runs view.
- Open the respective run.
- Go to Remeasured Balances.
For G/L Account XYZ no Loss is shown and posted.
Cause
The FCR-Cash groups and aggregates g/l account balances according to House Banks.
Calculated balances in Company Currency according to Key Date Exchange Rate then will be compared to Historic Valuation Amounts.
Whether Gains and Losses will be shown will depend on applied FCR-methods and principles and whether an aggregated Gain or Loss is computed per House Bank.
Depending on account balances and EXR-movements this can lead to a situation that the valuation of a single bank g/l account and bank account can differ from the grouped results for a particular House Bank.
Business Configuration Settings:
Activity: Foreign Currency Remeasurement Methods for Cash
Assign remeasurement method to accounting principle:
For applicable Accounting Principle Foreign Currency Remeasurement Method 'A002 - Lowest value' is assigned under tab 'Use for Cash'.
Edit foreign currency remeasurement methods:
Method: A002 - Lowest value
General Settings:
Foreign Currency Remeasurement Principle: 002 - Lower Value
Example:
Company Currency is EUR.
Bank G/L Account 121003 - Bank 3 is linked to a bank account in USD with a balance of 0.00 USD.
There are other Bank G/L Accounts linked to bank accounts for the same house bank Bank 1.
The Historic Valuation Amount in EUR is 14,556.04 EUR. The periodic EXR Gain/Loss hence would calculate as:
Key Date Valuation Amount (0.00 EUR) ./. Historic Valuation Amount = -14,556.04 EUR
The Key Date Valuation Amount, however, shows as 14,556.04 EUR. Hence no Loss is realized for Bank G/L Account 121003 - Bank 3.
The calculation logic is illustrated in below table:
G/L Account | Bank Name | Balance Amount USD | Key Date EXR | Calc EUR | Historic Valuation Amount EUR | Calc Gain/Loss |
120000 - Bank 1 | Bank 1 | 2,500.00 | 1.2 | 3,000.00 | 2,336.45 | 663.55 |
120001 - Bank 2 | Bank 1 | 6,500.00 | 1.2 | 7,800.00 | 5,486.65 | 2,313.35 |
121003 - Bank 3 | Bank 1 | 0 | 1.2 | 0.00 | 14,556.04 | -14,556.04 |
136000 - Cash in Transit | Bank 1 | -7,025.36 | 1.2 | -8,430.43 | -20,294.27 | 11,863.84 |
284.70 |
At a Key Date Exchange Rate of 1.2 EUR/USD house-bank Bank 1 has a calculatory EXR Gain of 284.70 EUR on aggregate.
According to Foreign Currency Remeasurement Method 'Lowest Value' there is no Gain posted for this bank and affected period.
No Gains or Losses will result from this FCR-Remeasurement Run for each bank g/l account including 121003 - Bank 3.
This scenario changes when applied Key Date Exchange Rate is sufficiently low so that an EXR Loss on aggregate per house-bank would show. We then would expect Losses as well as Gains for affected house-bank accounts to be shown and posted.
G/L Account | Bank Name | Balance Amount USD | Key Date EXR | Calc EUR | Historic Valuation Amount EUR | Calc Gain/Loss |
120000 - Bank 1 | Bank 1 | 2,500.00 | 0.9 | 2,250.00 | 2,336.45 | -86.45 |
120001 - Bank 2 | Bank 1 | 6,500.00 | 0.9 | 5,850.00 | 5,486.65 | 363.35 |
121003 - Bank 3 | Bank 1 | 0 | 0.9 | 0.00 | 14,556.04 | -14,556.04 |
136000 - Cash in Transit | Bank 1 | -7,025.36 | 0.9 | -6,322.82 | -20,294.27 | 13,971.45 |
-307.69 |
Resolution
This is the intended system behaviour.
The rationale of this definition is that, in this example - although an EXR Loss of -14,556.04 EUR for 121003 - Bank 3 is not posted - the even bigger EXR Gain of 14,840.74 EUR for the other bank g/l accounts belonging to Bank 1 is not acknowledged.
This conforms with Foreign Currency Method: A002 - Lowest value and Foreign Currency Remeasurement Principle: 002 - Lower Value.
We would expect deviating results per bank g/l account only in rarer scenarios, since for bank accounts in foreign currency, movements usually would go in a similar direction. Especially when we have bank accounts with a FC-Balance of 0.00 - this effect may occur when values are aggregated for an entire bank.
If a Loss per bank g/l account will be shown then depends on the Balance Amounts, Historic Valuation Amounts and applied Key Date Exchange Rate. If the Key Date Exchange Rate is sufficiently low so that an EXR Loss on aggregate and per house-bank would show - we would see Losses as well as Gains for affected house-bank accounts.
Keywords
KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem