Report for GL account in original currency

(0) Share

Report

Posted on by Community member

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Inge M. Bruvik 1,165 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Set Up Additional Currencies - Business Central | Microsoft Learn

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps.

https://www.youtube.com/watch?v=cIrN3feZaAY

Thanks.

ZHU

Was this reply helpful? Yes No
Community member 12 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,165 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No