Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Show Currency Code and...
Business Central forum
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!!
 
Categories:
Reports and Business Intelligence
  • 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 8,744 Most Valuable Professional on at
    Show Currency Code and Amount in General Ledger Entries 'Open in Excel'

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans