Free Articles, Free Web Content, Reprint Articles
Wednesday, April 24, 2019
Free Articles, Free Web Content, Reprint ArticlesRegisterAll CategoriesTop AuthorsSubmit Article (Article Submission)ContactSubscribe Free Articles, Free Web Content, Reprint Articles

SAP Business One Consolidate Financial Reporting

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). 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 migrationFree Reprint Articles, customization and reporting

Source: Free Articles from


Andrew Karasev is SAP Business One Consultant and Great Plains Certified Master, MVP, 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project and founder of Alba Spectrum information space.  By the nature of our service we are helping customers USA, Canada nationwide and internationally with consulting force speaking in English, Russian, Spanish and Brazilian Portuguese

Home Repair
Home Business
Self Help

Page loaded in 0.180 seconds