Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Report for GL account ...
Small and medium business | Business Central, N...
Answered

Report for GL account in original currency

(0) ShareShare
ReportReport
Posted on by Community member 8
Hello all,
 
Could someone explain how I can extract report for particular GL account in original currency. When I access the GL entries from COA I get only the amount LCY. I also tried different reports but not able to find solution.
 
Thank you in advance.
Categories:
Business Central
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    Report for GL account in original currency
    Hi
    I will try to answer your 3 additional questions:
    1. In terms of accounting is that correct? Or if I use different currencies I have to always go through to the subledger?
    2. Nevertheless, the system allows me to book these transactions. But then I am not able to get any information/report to the amounts. When I extract GL entries from COA I get only LCY.
    3. How shall I revaluate these postings without any chance to investigate my actual amounts different from the LCY. 
     
    1) It is correct that the original currency and currency amount only will be saved for transactions going through a subledger either that is customer ledgers, vendor ledgers or bank account ledgers. All other transactions are kept in LCY and potentially an additional report currency if that iss configured. 
     
    2) If you need to report transactions in foreign currency you will have to report them through the sub ledgers.  Again the exception is the additional reporting currency that you might have configured.,
     
    3) Business Central have a routine where you can revaluate currency transactions for customer, vendor and bank ledger entries. You can read the documentation for that process here: Foreign currency revaluation for General ledger - Finance | Dynamics 365 | Microsoft Learn  This will revaluate the value of the balance transactions you have in the system. Your Gain and loss will be posted as currency gain or currency loss. So if you f.ex. have done a purchase in currency and posted that to a cost account it is posted with the currency rate at the invoice date and that cost is not normally adjusted do to exchange rate fluctuations. It is only balance due to be paid or recieved that is adjusted and of course also the value of a bank account if you have a bank account in another currency than your LCY.
  • Community member Profile Picture
    Community member 8 on at
    Report for GL account in original currency
    Hello all,
     
    Thank you for your feedback!
     
    Speaking of original currency I mean the actual currency that the transactions was posted. In the following case you see that I am booking to the GL ledger without using the subledgers and I book using different currencies. This opens a few questions.
     
    1. In terms of accounting is that correct? Or if I use different currencies I have to always go through to the subledger?
    2. Nevertheless, the system allows me to book these transactions. But then I am not able to get any information/report to the amounts. When I extract GL entries from COA I get only LCY.
    3. How shall I revaluate these postings without any chance to investigate my actual amounts different from the LCY. 
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,472 Super User 2024 Season 2 on at
    Report for GL account in original currency
    Hi, hope the following helps.
     
    Thanks.
    ZHU
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    Report for GL account in original currency
    Unless you have setup additional reporting currency your G/L reports will always be in LCY.
    So I wonder a little about what you mean by original currency, can you explain that? Do you mean the currency that a purchase or a sales invoice was posted in? For that you will have to look at the Customer og Vendor legder entries,
    That information is not a part of the G/L Entries. 

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans