web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Multi-currency reporti...
Microsoft Dynamics GP (Archived)

Multi-currency reporting - Displaying an Invoice in the local currency

(0) ShareShare
ReportReport
Posted on by Community Member

We utilize multicurrency, USD is our reporting element and default currency, we pay through one of our companies using CAD. I have generated a few reports that show the default currency as Dollar or CAD. I know that our default reporting is USD. I have been asked if its possible to show Invoices paid in CAD can be displayed as CAD and not USD so that we can tie out our EFT's to CAD. IS this even possible?

Thank you

Mark

*This post is locked for comments

I have the same question (0)
  • Tim W Profile Picture
    Tim W 2,925 on at
    RE: Multi-currency reporting - Displaying an Invoice in the local currency

    For most of us GP peeps on here we think in terms of functional currency and originating currency which would be the more the familiar terms.

    Question: you say "we pay through one of our companies using CAD" is that a separate company in GP that has a different functional currency or is this you pay one of your vendors you pay in CAD? 

    Assuming the latter:

    If I have a company who's functional currency is USD (that's most of us) you then create relationships to other currencies (such as CAD) allowing you to enter, report on, and pay in a different currency than the functional (I believe this is what you mean by default) which is the originating currency in the transaction.

    If you open you Transaction Entry window in AP you should see the Currency ID field.  If you want to track a CAD transaction you need to enter it here with the Canadian currency.  CAD becomes the originating currency, USD remains as the functional or base currency.  You can toggle back and fourth between the two sets of values on most any window but the process starts with you entering the transaction in the correct originating currency. 

    This is out of the box functionality.  That said, it's a tough setup if you haven't done it before so I'd recommend you get some experienced help on this.  It's an ongoing task to manage the rate tables and account for gain or loss and I think it might be easier if you also setup a CAD checkbook to pay these but those details are beyond my experience.

    It works mostly as you describe, at my company we sell in 12 currencies, we only pay in one though so haven't gone down that path yet but it coming soon enough.

     

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    RE: Multi-currency reporting - Displaying an Invoice in the local currency

    Hi,

    Where do want to display the invoice in CAD.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans