CA Ledger Amounts Are Different
If the CA ledger amounts are different, the system calculates the difference. It then divides the CA amount by the AA amount in the F0917 table to derive an exchange rate. Next, it multiplies the CA difference by the exchange rate to calculate an AA difference. Using the CA and AA differences, the system creates two tolerance variance entries.
Finally, the system subtracts the AA difference from the AA amount in the F0911 table to create an adjusted AA amount in the F0911 table. It then subtracts the AA amount in the F0917 table from the AA adjusted amount in the F0911 table to calculate the currency gain or loss.
In this example, the CA ledger amounts are different:
Table |
CA Ledger |
AA Ledger |
|---|---|---|
F0911 |
2,015.00 EUR |
3,125.16 CAD |
F0917 |
2,000.00 EUR |
3,120.00 CAD |
For variance tolerance entries, the calculations are:
CA (F0911) − CA (F0917) = CA difference
2,015.00 − 2,000.00 = 15.00 EUR
AA (F0917) / CA (F0917) = exchange rate
3,120.00 ÷ 2,000.00 = 1.56
CA difference à exchange rate = AA difference
15.00 Ã 1.56 = 23.40 CAD
For gain/loss entries, the calculations are:
AA (F0911) − AA difference = Adjusted AA amount (F0911)
3,125.16 − 23.40 = 3,101.76 CAD
Adjusted AA amount (F0911) − AA (F0917) = gain/loss
3,101.76 − 3,120.00 = –18.24 CAD
See Also