Great Plains Consultant Newsflash: Consolidated Reporting

Microsoft Dynamics GP ERP application is good fit forcan even use Excel to export them and use Excel
large organizations, where you work with layeredinstead of Great Plains company
organization structure with multiple companies and2.       Great Plains in all branches.  In this
intercompany purchases and sales, plus potentially inscenario you typically trying to make central server,
international environment, where in each country youwhere all Great Plains companies are hosted and you
have local subsidiary, operating in local currency. give reliable VPN or Citrix connection to your local and
Such scenarios require you to efficiently produceremote GP users.  This solution might seem to be
consolidated Profit and Loss Statement, Balanceideal, however you should know that GP is popular and
Sheet and maybe Consolidated Cash Flow statement,localized in English speaking countries: US, UK, Canada,
potentially with multicurrency.  In this small publicationAustralia, New Zealand, South Africa, Asia and
we would like to come through typical consolidatedOceania, plus in Spanish speaking Latin America.  It is
report creation options and recommend solutionnot often possible to implement Great Plains in the
1.       Different accounting systems in differentcountry where it is not localized, meaning local
countries.  Let’s assume that you have Dynamicsregulations, language support
GP Great Plains in US headquarters and you have3.       Consolidated Reports.  If your
sort of eclectic internationally: SAP Business One inorganization needs relatively simple solution, which
Brazil, Navision in Europe.  In the case when you dodoesn’t require a lot of user training and technical
not have stable worldwide permanent connection withconsulting, we recommend you to deploy FRx financial
firewall – good strategy is Brazilian and Europeanreporting.  It supports multicurrency, budgets, Excel
branches export on GL level and then you moveworksheets (here you can also use ODBC data link in
transactions into Great Plains Brazilian and Germanyour Excel worksheet to cover more complex
companies images.  Good job could be done by GPscenarios) consolidations and it allows you to analyze
Integration Manager module.  In this example, imageyour reports for consolidated and for individual
for Brazil set to use Real and Euro for Germany.  Ifsubdivisions if you deploy so-called FRx reporting tree.
foreign subsidiary has low volume of transactions, you