Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
lcarness 9/24/2018 10:38:45 AM

Excel Worksheet used to translate in Management Reporter

Does anyone have a sample of an Excel template they use to translate non reporting currency companies in a consolidation report. I have heard people describe doing this on various boards, but no one provides an example of what the Excel worksheet looks like or how they reference it in the Column Set. I would really appreciate some help with this.

My big issue is that I need different accounts to translate at different historical rates, i.e. Inter-company, Equity, etc. I inherited a poorly designed GP implementation that never had FX setup correctly, and now, 5 years later, the effort to go back and try to tie out all of the rate issues is massive. This would be easier if I could use an Excel worksheet and Management Reporter. 

Version: GP 2013
Section: Dynamics GP, Management Reporter, SmartConnect

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables