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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Manual realization of FX gain/losses

(1) ShareShare
ReportReport
Posted on by 2

Hi all,

I would like your opinion on the following scenario linked to the realization of FX gains/losses. In this scenario, the legal entity accounting currency is EUR and the reporting currency is GBP.

 

Step 1 - An outstanding payable exists on a vendor account (1000,00 CHF).

 

Step 2 - A vendor payment journal is created, and the AP file is generated and submitted. Adjustments are made to allow a GL as offset account (rationale in later steps).

DR: Vendor 1000,00 CHF

CR: Ledger clearing 1000,00 CHF

 

Step 3 - Business stuff happens. Payment goes through an intermediary and is ultimately recorded at the Bank level in EUR.

 

Step 4 - Bank transaction is recorded in the system.

DR: Ledger clearing 1070,00 EUR

CR: Bank 1070,00 EUR

 

Step 5 - Ledger clearing account should be settled. FX gain/losses should be realized and recognized.

DR/CR: ?
CR/CR: ?

 

What would be the correct approach in Step 5 from a D365 FO perspective? Assume that the advanced ledger functionalities cannot be activated (we identified issues with the awareness feature). Also, assume the following overview for the Ledger clearing account.

 

DateTransaction amountTransaction currencyAccounting amountAccounting currencyReporting amountReporting currency
01/01/xx-1000CHF-1068EUR-914GBP
03/01/xx1070EUR1070EUR915GBP
       

 

As a first thought, I would have journalized the entry manually to the FX gain/loss account. However, I realise we would have to enter a non-zero transaction amount in the FX gain/loss account, which is not normally something I would expect. Through every other revaluation/settlement functionality, the transaction amount on that G/L is zero, with deviations posted to the accounting and reporting currency only. I wonder about the wider implications of having a non-zero transaction value on that account (e.g., consolidation).

 

What would be the recommendation?

Categories:
I have the same question (0)
  • Suggested answer
    Aayush Tiwari Profile Picture
    263 on at

    Hello @CU07071130-0 

     

    In the step 2 when the vendor bill is paid off, The Forex Gain and loss for the vendor have to be posted already for vendor Invoice and Payment, Now coming on the Forex Gain and loss for the payment transaction You should post the Voucher Forex Gain and loss in the last step. 

     

    AccountAmount TypeTransaction currency amountTransaction currencyAccounting currency (EUR)Reporting currency (GBP)
    Ledger clearingDr2EUR21
    FX gain/lossCr2EUR21

     

    Regards

    Aayush Tiwari

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 330 Most Valuable Professional

#2
CU10121822-0 Profile Picture

CU10121822-0 310

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 242 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans