Sap Business One Consolidated Profit And Loss Statement How To Build
Business One is good solution when you are midmarket organization with attributes of multinational corporation, such as branches in foreign countries and headquarters and research facility in the United States. SAP B1 is popular in international business scenarios as it is localized in such popular regional powers as China, Brazil and Russian Federation. There are known cases studies when companies with non-SAP Corporate ERP applications launched Business One for their branches in Brazil and later one switched to it in the headquarters as well. There are some challenges however and one of them is consolidated financial reporting. As you may know such popular tools as Microsoft Management Reporter and FRx do not have GL connectors to SAP BO. Some customers are doing GL trial balance export to Excel and then prepare it to fit consolidation template. This is definitely possible way but you may mention that it is time consuming and open to human errors. In this publication we recommend old-good-days method of GL consolidation:
1.How does it work conceptually? You have to create new company with account structure matching your template. Then you schedule regular GL entries migration into this company General Ledger. This company obviously doesnt represent legal entity but it has all your branches GL activity and ready for consolidated Balance Sheet and P&L. You can use internal reporting
2.How does it work technically? You can deploy several tools. First of all it is possible to pull GL records via Data Transfer Workbench when it has integrations for each company SQL database via ODBC. Second method is programming with Software Development Kit. This second method might seem like something challenging. However it is only one type of transactions and code samples in VB and C# are straight forward. There are ISV products working with SAP B1 SQL database via direct data feed. They are usually expensive and require learning curve. But if you are ready to deploy luxury solution then you should probably make your homework
3.International Business Specific multicurrency. Business One is multicurrency enabled so in our opinion it is just one additional factor to incorporate into the solution. We have done it for the company which operates in Brazil and USA with respectively Real and Dollar
4.Standard for Chart of Accounts. This might be additional challenge as often company deploys the same system in several countries but contracts different consulting partners to do from ground up implementation without coordination with central office. In consolidated financial reporting Chart of Accounts should be reviewed and unified in all business entities. In any case this is good exercise in order to understand you foreign country branch operations and finances or in other words strengthen central control
5.Other aspects of multinational environment and Business One. It is generally good idea to host all the installations on the server located in the Headquarters. There are definitely some specifics associated with foreign company regulations and tax code. But these compliances should not be the central emphasis. Instead you should think about your new Corporate ERP system as the tool allowing you to exercise tight central control over all of your overseas subsidiaries. General advice is to assign chosen consulting organization here in the United States for picking subcontractors for each country to implement just compliance related functionality. Compliance is just a small part of what the system is for
6.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). [emailprotected] 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