web
You’re offline. This is a read only version of the page.
close

Roula Karkache Ishac Accounting Manager

Roula Karkache Ishac

Joined: 5/13/2025

  • Difference of exchange to be applied to USD currency as well (to affect and to be displayed in vendor, customer and bank modules)

    Tue, 13 May 2025 08:08:13 GMT – Dynamics 365 Finance – New 

    Dears,


    In Microsoft Dynamics Business Central 365 (SAAS), it's not possible to perform DOE in vendors, customers and bank module to USD currency (not only GL account).

    This is needed in countries where three currencies are needed (transaction currency which could be Euro, CHF which is the local currency in Switzerland and USD which is the additional currency and reporting currency).

    Would you please add this feature?


  • Clarification and Adjustment Request on Currency Valuation for Vendor Payments

    Tue, 13 May 2025 10:25:54 GMT – Dynamics 365 Finance – 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