If you were controller in the companies where accounting was implemented on Great Plains Dynamics, Navision or maybe Epicor then probably FRx was doing perfect consolidate P&L statement report via reporting tree
And now you are hired to the midmarket multinational company where headquarters and overseas subsidiaries are implemented on SAP B1 platform installed on the same MS SQL Server. FRx or Microsoft Management Reporter is not available for SAP BO. Accounting personnel here are exporting all subsidiaries GL Trial Balance reports to Excel and then spend few weekends composing the consolidated ones. Is it what you got to do and as you can imagine Excel worksheets do not allow you to drill down to transactions and audit reports. Here are our recommendations supported by successful implementations:
1. GL consolidation concept. This is very old solution. Imagine you have several legal companies and you need to produce consolidated Balance Sheet or Profit and Loss Statement. You simply create virtual company where all GL entries are imported from all the branches. Business One has pretty robust Balance and P&L reports with several possible layers
2. Multinational Consolidation. Let’s assume that you have headquarters in the United States and facilities in Brazil and China. Obviously sales and purchasing are done in Brazilian Real and Chinese Yan in their respected countries while the corporation itself has to produce BS and P&L in US dollars. What needs to be done is to setup two currencies in each company. When Brazilian subsidiary General Ledger entry is imported into consolidated company then it is flipped to be restated in dollars
3. What if we do have Business One in our foreign branches and Dynamics GP in the Headquarters? GL consolidation could be done in more sophisticated way as GP has FRx or its newly recommended replacement Microsoft Management Reporter. There is no need to declare virtual consolidated company. Instead consider just creating GP company which would be only used from importing General Ledger entries from SAP B1 based accounting deployed for your foreign subsidiary. In our experience we recommended exporting GL entries from B1 into text file and importing them via Great Plains Integration Manager
4. SAP B1 Scalability for multinational company. Well even relatively small corporation come through initial public offer procedure and if we tell you that it is possible to have up to one hundred SAP B1 named users in single installation – do you think that even well known company could not get advantage of SAP Business One as Corporate ERP platform with reasonable functionality and doing the job
5. Please call us 1-866-304-3265, 1-269-605-4904 (for international customers, where our representative pick up the phone in St. Joseph, MI call center). help@efaru.com. We have local presence in Chicagoland, Southern California, South West Michigan and Houston and Dallas areas of Texas. We serve customers USA, Canada, Mexico and Brazil nationwide and internationally via web sessions and phone conferences (Skype is welcomed). Our consultants speak English, Spanish, Portuguese, Russian and Chinese. We feature our expertise is in International Business. We provide second opinion in SB1 data migration, customization and reporting
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 FAQ
Planning 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
