SAP,Business,One,Consolidate,F computer SAP Business One Consolidate Financial Reporting
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
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 layers2. Multinational Consolidation. Lets 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 dollars3. 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 Manager4. 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 job5. 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). [email protected]. 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
SAP,Business,One,Consolidate,F