[Support production / IBP-832] - SQL-Ledger - Exchange rate is calculated differently

[MariaHashimi]

Detailed Description:

From: https://runmyaccounts.zendesk.com/agent/tickets/54437

Here we have the case that the EUR exchange rate is calculated twice differently with the same amount.

Example:

1)

Exchange rate at 01.02.2024: 0.9458 CHF / EUR (https://my.runmyaccounts.com/#/settings/goodform/accounting/currencies/EUR )

EUR 339.05 = CHF 320.67 → exchange rate difference of CHF 18.38.

12871-240208-0002 has an exchange rate difference of CHF 18.38 which is correct.

UBS CH450023023080570960L 11.2023 (4728941-999) has an exchange rate difference of CHF 10.85 which is wrong.

The problem seems to lie here:

For the exchange rate difference, the exchange rate of the invoice (0.9680) is taken instead of the exchange rate of the payment (0.9458).

Impact:

Manual adjustments needed from accountant.

Steps to Reproduce:

Unknown as these bookings were made by the system.

Affected Components:

General ledger.

Steps Taken (if any):

Analysed bookings. There’s also a second example:

12871-231023-0103 vs. 12871-240212-0022

[ledger123]

Hi @MariaHashimi ,

I will be grateful if you can reproduce this bug on our demo server at https://app.ledger123.com/rma

Regards

[MariaHashimi]

Hi @ledger123, I've received the following comment from Philip

Cannot reproduce on Armaghan’s server. We booked it manually there with the same amounts and fx rates and everything was fine. We assume the root cause lies in the automatic booking from Booka that takes another fx rate than SQL Ledger.

So I will close this ticket and check with Suzana