Article Categories
» Arts & Entertainment
» Automotive
» Business
» Careers & Jobs
» Education & Reference
» Finance
» Food & Drink
» Health & Fitness
» Home & Family
» Internet & Online Businesses
» Miscellaneous
» Self Improvement
» Shopping
» Society & News
» Sports & Recreation
» Technology
» Travel & Leisure
» Writing & Speaking

  Listed Article

  Category: Articles » Technology » Computers » Article
 

Microsoft Great Plains, Axapta, SAP Business One, Oracle E-Business Suite - SQL databases/companies




By Andrew Karasev

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

 

Please do not hesitate to call or email us: USA 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com
 
 
About the Author
Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.greatplains.com.mx http://www.enterlogix.com.br ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.

We are serving USA Nationwide: CA, IL, NY, FL, AZ, CO, TX, WI, WA, MI, MA, MO, LA, NM, MN, Chicago, New York, Los Angeles, Phoenix, San Francisco, Denver, Seattle, Boston, Atlanta, Miami, Houston, Dallas, San Diego, Toronto, Montreal, Vancouver, Minneapolis, Washington, Baltimore, New Orleans, Austin, Kansas City.



Article Source: http://www.simplysearch4it.com/article/19682.html
 
If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/19682.html" as shown above and make it hyperlinked.



  Some other articles by Andrew Karasev
SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil
SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this article ...

SAP Business One in Illinois: implementation, upgrade, customization, integration
Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of diversified mid-size businesses, engaged in light assembly, shipping and receiving and distribution ...

SAP Business One Chicago Market Review, plus customization, integration & data conversion
SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the Israel software development companies, now it is ...

Microsoft Dynamics GP Office Stack Integration advances –
Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains Dexterity ...

eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes
This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion and reporting. As software programmer you should know ...

Microsoft Dynamics GP Dexterity Customization
Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual Studio ...

  
  Recent Articles
Microsoft Word. The power is under the hood
by Robert Duval

How To Select The Best Gaming Laptops
by Tim Childree

How To Select The Best Business Laptops
by Tim Childree

High-Tech Computer Rental for Business Promotion
by Michael Braganza

Managing a Worldwide Print Infrastructure from a Single Workstation in a Central Location
by Rick Ferguson

A Sneak Peek Into The World Of Refurbished Laptops
by Javier Fuller

Battery information
by goodbattery

Tell Me About Computers
by Khal Nuwar

Setting Up Your Own Internet Radio Station
by Jason Cole

Understanding Solar Energy
by Anna Stone

Mac FAXstf X Pro Faxing Program for Mac OS X Users
by Nivea David

How to Retrofit a Picture or an Image into Desktop Wallpaper for Your Computer
by Steve Dimeck

Can't connect to database