Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / MR multicurrency and C...
Microsoft Dynamics GP (Archived)

MR multicurrency and Currency Index

(0) ShareShare
ReportReport
Posted on by Ian Richardson 4,150

Hi Folks

One of our subsidiaries has its own GP installation separate from ours.  Their account format is the same as ours so I have been working on the assumption that a back up of their dbase to our sever will allow me to consolidate them into our books.

I have got the first back up and found that some of the currency id fields are blank.  They did not have a functional and reporting currency set for their first few transactions.

Is there a way to populate these fields?  If they are blank what is Management Reporter going to make of these JE's for currency translation?  They are USD we are CAD so I want to go from USD company to CAD company.

I have also realized that they did not install the training company Fabrikam consequently their dynamics dbase is assigning different currency index values than our system is.

Where USD = currency index 1008 for me, it is 1003 for them.  Is Management Reporter going to translate these appropriately based on the currency ID's matching, or does it refer back to the currency index?

thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: MR multicurrency and Currency Index

    Nice one.

    I was looking at ISO currency codes here [something in the dark recesses of my mind rang a bell about ISO - but it was nothing!!]

    Post again if it works / doesn't work.

    Ian.

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: MR multicurrency and Currency Index

    yes adding a rate table to m/c set up for z-NZ allows for currency translation

    I will have to make a table in NZ $ that holds the USD to CAD rates.

  • Verified answer
    Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: MR multicurrency and Currency Index

    yes their USD is my Z-NZ.  Fabrikam took the first 7 currency id's

    I guess I can try putting USD to CAD rates on the NZ table.

  • Community Member Profile Picture
    Community Member on at
    RE: MR multicurrency and Currency Index

    Not sure how to go about this. Can you set up a currency in the main install with the same currency index - or is this already used up?

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: MR multicurrency and Currency Index

    hi Ian

    thanks for the reply

    The indexes are most definitely different.  The subsidiary did not load Fabrikam so while CAD was entered before USD they still have the wrong numbers.

    I did try the checklinks on gl only and it only found one JE that had no reporting ledger which it changed to BASE.  It did not object to the blanks at all.

    MR is having no issue pulling the data in the reporting currency (USD), but trying to translate to CAD it is claiming no data is available for this report.

    I realize the dynamics dbases will be different, the only place that is really going to matter (I think) is this currency issue.

    So now i'm at the point of how to get MR to see these transactions with converted amounts.

  • Community Member Profile Picture
    Community Member on at
    RE: MR multicurrency and Currency Index

    Hi Ian,

    My initial thoughts.

    Porting a company database from one instance of GP to another will not necessarily work. the Dynamics Databases will be different - unless you have processed every system change on one in the other.

    For the missing currency fields - enable multicurrency - and run a checklinks against all series. - this may find and correct the missing currency ID's.

    The currency indexes will most likely be different - especially if the currency ID's were set up in a different sequence. Not much you can do about this - but you could [if you get the database to port over without issue] treat the currency of the outside company [as long as its index is unique] as a foreign currency with an FX rate of 1.

    Ian.

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans