Microsoft Great Plains, Axapta, SAP Business One, Oracle E-Business Suite - SQL databases/companies - overview
Corporate ERP clients sometimes come up with the question, which can not be answered by one specific ERP reseller. Very good example is this question: our corporation has about 100 legal entities, such as subsidiaries in Brazil, Colombia, France, Germany, Russia, plus we have legal entities in the USA by product lines and services. Currently we have Microsoft Dynamics GP – Great Plains architecture requires each legal entity to be Great Plains company and have separate Microsoft SQL Server database. It is simply not feasible to run 100 SQL databases for just ERP/Accounting system. How this is designed in other MRPs: Oracle Financials, Microsoft Dynamics AX, SAP Business One? In this small article we are trying to orient you, IT specialist.
Microsoft Dynamics GP/Great Plains. The architecture of Great Plains requires separate SQL Server database for the company/legal entity. You can have intercompanies transactions, but you should do in this case intercompanies 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 to support any number of organization (just one database instance)
Support any number of legal entities within a single installation of Oracle Applications.
Secure access to data so that users can access only the information that is relevant to them
Sell products from a legal entity that uses one set of books and ship them from another legal entity using a different set of books.
Purchase products through one legal entity and receive them in another legal entity.
The list above shows the basics benefits of using multi-org on Oracle Applications.
Microsoft Dynamics AX/Navision Axapta.
Axapta can accommodate multiple companies within ONE DATABASE. This enables integrated reporting, intercompany transactions, consolidation and seamless user operation within multiple companies environment.
Master Records Sharing. Axapta also pioneers with Master records sharing for multiple companies, such as GL Account, Customer, Vendor.
SAP Busines One. SAP Business One, if it sits in Microsoft SQL Server – requires separate database for each company/legal entity
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Germany, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer
Your Article Search Directory : Find in Articles
Recent articles in this category:
- Web Development Projects - Developers Tools Tips
Open source usually refers to software that is released with source code under a license that ensur - A Guide to Cnc Kits
Building a CNC machine means that you would require a lot of tools, parts or different components. - Xlphoto Printing, the Best Choice for Banner Printing and Poster Printing
Suppose, you have visited a tourist spot or a hill station; over there, you have witnessed some of - Reliable Software Programming
Software reliability is an important facet of software quality. It is defined as "the probability - Designing an Ecommerce Site
In a recent article I talked about Google AdSense placement based on eye-tracking research. Howeve - Asp.net Development Benefits
Rightway solution has been keenly looking out for. Microsoft ASP.NET is a free technology that allo - Choosing Offshore Software Development Company
To turn into successful and gain the full benefits of software outsourcing, you require preferring - E-commerce and Web Portal Development in Vietnam
VIETNAM, owing to its superior intellectual capital has emerged as the ultimate destination for - Types of Softwares
Computer software is a general term used to describe a collection of computer programs, procedur - Offshore it Out Sourcing Consultancy in Vietnam
Vendors who provide Off shore IT Outsourcing Consultancy services are referred to as outsourcing
Most viewed articles in this category:
- Oracle Applications (Oracle E-Business Suite) Customizations: What is it?
Oracle recommends every company that installs Oracle Applications to avoid any customization, but I - Offshore Outsourcing: An All Win Premise
The awareness that outsourcing can boost productivity sans forfeit of class has impelled MNC’s - Oracle E-Business Suite vs. Microsoft Dynamics AX - Axapta: LATAM and Brazil
In this small article we will only concentrate on Microsoft Dynamics Axapta (and will not consider M - SAP Business One vs. Microsoft Dynamics GP - highlights for consultant
In this small article we will not make side-by-side technical specs comparison. We would rathe - Microsoft Great Plains - licensing and product versions
Current Microsoft Business Solutions Great Plains has more that 10 years of history. Former Gr - OCR Software - Optical Character Recognition or Optical Crud Recognition?
Optical Character Recognition (OCR) refers to a software technology and processes that involve the t - Microsoft Dynamics AX - Axapta - technical notes plus customization
Axapta or current name Microsoft Dynamics AX has one of the newest ERP design and architecture among - Microsoft Dynamics AX-GP-NAV-CRM: trends and international recommendations
Microsoft Great Plains/Microsoft Dynamics GP, Microsoft Navision (former Attain) Microsoft Dynamics - Microsoft Moves to Small Business Accounting/Retail Market - stakes and thoughts
In this small article we will be looking at the new opportunities for Microsoft Small Business Serve - Microsoft Axapta - Dynamics AX: Brazilian Portuguese version - consultant highlights
Axapta/Microsoft Dynamics AX short overview. Navision Axapta was designed by Navision Software