Corporate ERP customers sometimes come to the question that can not be answered by a particular ERP reseller. Very good example is the question: Our company has about 100 legal entities such as subsidiaries in Brazil, Colombia, France, Germany, Russia, as well as legal persons, we have in the U.S. of products and services. We currently have Microsoft Dynamics GP - Great Plains architecture requires to be any legal person, Great Plains companies and have separate Microsoft SQLServer database. It is simply not possible to walk 100 SQL databases for ERP / Accounting System. As this developed in other MRP: Oracle Financials, Microsoft Dynamics AX, SAP Business One? In this small article we will try to orient you, an IT specialist.
Microsoft Dynamics GP / Great Plains. The architecture of Great Plains will require separate SQL Server database for the company / legal person. You can intercompanies transactions, but you should in this caseintercompanies records in GL by hand or have Intercompanies Transactions module (or advanced intercompanies module from third party)
Oracle Financials/Applications/E-Business Suite. Regarding Oracle Applications, it has an organization model that you can define organizations and the relationship among them. Using this model, you are able to define different structures to customize Oracle Applications according to your business need. The basics business needs are:
• Use (a single installation of Oracle Applications product any number of companies only a sample database support)
• Support any number of legal entities in a single installation of Oracle Applications.
• Secure access to data so that users can access only the information that is relevant to them;
• Sales of products from a legal entity that uses a set of books and deliver them from another legal person with a different set ofBooks.
• Purchase products through one legal entity and receive them in another legal person.
The list above shows the basic advantages of using multi-org Oracle applications.
Microsoft Dynamics AX / Axapta Navision.
• Axapta provides space for several companies within a database. This provides integrated reporting, transactions, consolidation and seamless user operation within several corporate environment.
• Data sharing. Axapta alsoEngineers with master data sharing for multiple companies, such as GL account, customers, suppliers.
SAP Business One. SAP Business One, as she sits in Microsoft SQL Server - requires separate database for each company / legal person
Please do not hesitate to call us or e-mail: USA 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com
