Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Daily Exchange Rates
Microsoft Dynamics GP (Archived)

Daily Exchange Rates

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I'm trying to create a report I can export into excel that lists the daily exchange rates that have been entered into a specific exchange rate table.  The one caveat is that I would like to be able to define the period (e.g., March 1 through March 31) prior to the export.  Any suggestions?  I'm able to export an exchange rate table, but it lists every single exchange rate since inception.  I want to be able to drill down to a single month in order to confirm the average exchange rate used to convert to a reporting currency in MR.  I also want to know this average exchange rate to use with my smartlist exports. Thanks in advance.  Paul

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Daily Exchange Rates

    For this, I had been using this and it's great.

    It has instructions which can help you.

    Exchange rates in Excel

    .Just visit the site for more info

    They also have a live support and a forum to help you with your questions/concerns.

    3) Exchange rates in Excel
  • soma Profile Picture
    soma 24,406 on at
    RE: Daily Exchange Rates

    Always welcome.:)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Daily Exchange Rates

    This was perfect!  Thanks.

  • Verified answer
    soma Profile Picture
    soma 24,406 on at
    RE: Daily Exchange Rates

    If you have Smartlist builder, then you create a custom smartlist with adding the table "Multicurrency Exchange Rate Maintenance" and get the exchange rate details under smartlist (Dynamics GP-->Smartlist).

    To create a smartlist, follow the below steps.

    1. Microsoft Dynamics GP menu, point to Tools-->SmartList Builder, and then click SmartList Builder.
    2. In the SmartList ID box, type an ID for the new     object .
    3. In the SmartList Name box, type the name that you want to use for the     object .
    Note: This name is the name that you will see in SmartList. The name that you type automatically populates  the Item Name box.
    4. Click the plus sign next to the Tables area, and then click Microsoft Dynamics GP Table.
    5. In the Add Table window, follow these steps:
        a. In the Product list, click Microsoft Dynamics GP.
        b. In the Series list, click System.
        c. In the Table list, click Multicurrency     Exchange Rate Maintenance, and then click Save .
    6. Mark all the check box as shown below and click     save .


    7. Now go to Microsoft Dynamics GP-->SmartList then expand the System and you can see your     Exchange Rate details.


    Note: you can also export these value to Excel.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Daily Exchange Rates

    Hi Harry.  I'm still new to Dynamics GP.  Where do I access the fields you mentioned?  Thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Daily Exchange Rates

    Hi Babu.  Unfortunately I can't seem to get access to the Dynamics GP server to test your suggestion.  I'll need to work with our network administrator to gain access.  I'll let you know if it works.  Thanks.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Daily Exchange Rates

    The data you're looking for is contained in the MC00100 AKA the Multicurrency Exchange Rate Maintenance - A System table.  The EXCHDATE and XCHGRATE fields likely contain the information you're looking for.  You should use the EXCHDATE field results to filter the data.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Daily Exchange Rates

    Hi Paul,

    You can do refreshable excel using the exchange table, and get the required data using pivot table option.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans