You’re offline. This is a read only version of the page.
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
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.
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.
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.
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?
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (