Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Show Currency Code and...
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 Community member 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!!
 
  • Suggested answer
    HVGEEL Profile Picture
    HVGEEL 288 on at
    Show Currency Code and Amount in General Ledger Entries 'Open in Excel'
    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.
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Show Currency Code and Amount in General Ledger Entries 'Open in Excel'
    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
    gdrenteria Profile Picture
    gdrenteria 12,183 Most Valuable Professional on at
    Show Currency Code and Amount in General Ledger Entries 'Open in Excel'

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans