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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Show Currency Code and Amount in General Ledger Entries 'Open in Excel'

(1) ShareShare
ReportReport
Posted on by 2
Hi,
 
I have a requirement in General Ledger Entries -> Open Excel. There is no Currency Code and Source Currency(Foreign currency) Amount. I only see local currency amount only when open Excel.
 
Please find attached screenshot and guide me how to achieve the result?
 
Please note, I am very new to Business Central.. Kindly do explain me step-by-step. Many thanks!!
 
I have the same question (0)
  • Suggested answer
    Gerardo Rentería García Profile Picture
    25,225 Most Valuable Professional on at
  • Suggested answer
    Judy Profile Picture
    Microsoft Employee on at
    Hi,
     
    I have tested it on my demo environment. The currency code and the Amount field are indeed in the Excel when open with the "open in Excel":
     
     
    Best Regards,
    Judy
  • Suggested answer
    HVGEEL Profile Picture
    308 on at
    First: let's set 2 thing apart.
     
    (1) entry in the General Journal page allows for the use of a foreign currency, as Judy shows in her reply. But that is NOT your question.
    (2) Table 17 (GL Entry) does NOT have the foreign currency notion: all entries are "translated' into your LCY (Local Currency)
     
    Sop trying to find the original currency and FX-amount in T17, will not be possible.
     
    However, the data will always be there in the corresponding document: look in the subledgers (Bank Account Ledger Entries, Customer Ledger Entries, Vendor Ledger Entries,L...) : For it is a customer that pays you in his currency, on a particular date... using a certain rate.
     
    On topic:
    If you try to test a Finance Charge memo, try not posting it against a GL Account in a Gen Journal... it simply makes no sense, because it does not say who the Memo is for. It is simply hanging there in thin air.
    Create an Issued Reminder including posting Finance Charges for an actual Customer instead. This registration will generate Customer Ledger Entries (CLE) for you
    You will find the Currency Code, Currency Factor and LCY amounts in the CLE.
     
    Apply the entries by settling the Finance Charge memo... if there is a FX difference, you will need GL accounts for the FX Loss/ Gain set on you Currency.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,010

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,270 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans