Suggested by Roula Karkache Ishac – New
Dear Team,
Please note the following issue related to currency valuation when booking a payment for a vendor in EUR:
When a payment is posted and applied to a vendor invoice in EUR, the difference of exchange is correctly calculated in CHF. However, the value in USD (Additional Currency) is not accurate. The system currently displays a USD value that does not reflect the correct difference or net to zero.
Request:
Would it be possible to adjust the system so that:
- The USD amount is recorded as either 0 USD, or
- Reflects the actual exchange rate difference between the USD equivalent at the invoice posting date and the payment date?
This would ensure proper reconciliation in USD and prevent open residuals in this currency.
Example:
Document Type
Posting Date
Source Code
Currency
G/L Account
G/L Name
Amount (EUR)
Amount (CHF)
Amount (USD)
Action Needed
Payment
13/05/2025
PURCHAPPL
EUR
2007
Vendor X
0.00
CHF 97.13
112.98
This amount ($112.98) should be 0 or -311.28 USD to correctly close in USD
Payment
13/05/2025
PAYMENTJNL
EUR
2007
Vendor X
9,339.62
CHF 8,881.98
10,331.49
Invoice
16/04/2025
PURCHASES
EUR
2007
Vendor X
-9,339.62
CHF (8,979.11)
-10,020.21
Net Difference:
- EUR: 0.00
- CHF: -97.13
- USD: +112.98 (should be adjusted)
Exchange Rates Used:
- EUR → CHF
- 16/04/2025 (Invoice date): 1 EUR = 0.9614 CHF
- 13/05/2025 (Payment date): 1 EUR = 0.9510 CHF
- USD → CHF
- 16/04/2025: 1 USD = 0.8961 CHF
- 13/05/2025: 1 USD = 0.8597 CHF
We would appreciate your guidance or support to implement this adjustment in the system so that USD values either reconcile correctly or reflect the actual exchange difference.
Thank you and best regards,
Roula Karkache Ishac
+9613043266