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 :
Microsoft Dynamics GP (Archived)

List or Report showing all currency conversion rates for a period

(0) ShareShare
ReportReport
Posted on by 205

We have a multicurrency system.  Our cash is reported in US$, but we also have a CAD$ bank account.  One of our temp workers is reconciling the bank statements, and was wondering if there is a report or list in GP that shows all the currency conversion rates that were used each period.

I work in Accounts Payable, and when I enter a Canadian invoice, it prompts me to enter a conversion rate with an expiration date, which I typically enter as the last day in the month.  When I do this, it shows a screen with all the rates and time periods I've entered.  However, I am not sure how to get to this screen without entering a Canadian invoice.  A report or list of these conversion rates would be very helpful.

Our temp worker is actually looking for the conversion rates used for Receivables, which I know very little about as far as GP goes.

If anyone has any suggestions on how to print a report or at least pull up a screen that shows all the receivables currency conversion rates that were used, that would be great!

Thank you.

*This post is locked for comments

I have the same question (0)
  • K Day Profile Picture
    7,365 on at

    You should be able to see all the information for the Multicurrency rates by going to GP Button (In version 10), Tools -Setup - System -  Exchange Table.

    I can't point you to a report but I know that it is stored in SQL so you should have a few options to get this info like a Smartlist, or maybe there is a canned GP report under financials. 

     

  • Richard Whaley Profile Picture
    25,195 on at

    The report you seek is a system report (exchange rates are universal),  In version 10 select the Administration tile, open reports, select System and then General and pick the Exchange Rates report.

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans