web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Daily Exchange Rates

Microsoft Dynamics GP (Archived)

Daily Exchange Rates

(0) Share

Report

Report

Posted on by Community Member

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

I have the same question (0)

All responses Img

All responses (8)

Answers Img

Answers (1)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Paul,

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

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (2)

Report

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!!!

Was this reply helpful? Yes No

Community Member on at

Like (0)

Report

This was perfect! Thanks.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

Always welcome.:)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans