Microsoft Dynamics GP ERP application is good fit for large organizations, where you work with layered organization structure with multiple companies and intercompany purchases and sales, plus potentially in international environment, where in each country you have local subsidiary, operating in local currency.
Such scenarios require you to efficiently produce consolidated Profit and Loss Statement, Balance Sheet and maybe Consolidated Cash Flow statement, potentially with multicurrency. In this small publication we would like to come through typical consolidated report creation options and recommend solution
1. Different accounting systems in different countries. Let’s assume that you have Dynamics GP Great Plains in US headquarters and you have sort of eclectic internationally: SAP Business One in Brazil, Navision in Europe. In the case when you do not have stable worldwide permanent connection with firewall – good strategy is Brazilian and European branches export on GL level and then you move transactions into Great Plains Brazilian and German companies images. Good job could be done by GP Integration Manager module. In this example, image for Brazil set to use Real and Euro for Germany. If foreign subsidiary has low volume of transactions, you can even use Excel to export them and use Excel instead of Great Plains company
2. Great Plains in all branches. In this scenario you typically trying to make central server, where all Great Plains companies are hosted and you give reliable VPN or Citrix connection to your local and remote GP users. This solution might seem to be ideal, however you should know that GP is popular and localized in English speaking countries: US, UK, Canada, Australia, New Zealand, South Africa, Asia and Oceania, plus in Spanish speaking Latin America. It is not often possible to implement Great Plains in the country where it is not localized, meaning local regulations, language support
3. Consolidated Reports. If your organization needs relatively simple solution, which doesn’t require a lot of user training and technical consulting, we recommend you to deploy FRx financial reporting. It supports multicurrency, budgets, Excel worksheets (here you can also use ODBC data link in your Excel worksheet to cover more complex scenarios) consolidations and it allows you to analyze your reports for consolidated and for individual subdivisions if you deploy so-called FRx reporting tree. In the case when you are larger organization and you need more high end solution, you should consider Enterprise Reporting for GP
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQPlanning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella