MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see that ERP for large publicly traded company had to be built upon very reliable hardware (more likely non-Intel hardware: mainframe, Sun sparc, etc.), powerful database platform: Oracle, DB2, Ingress, Sybase and reliable OS: UNIX. 10 years ago Microsoft had Windows NT first tries, plus Windows 95 was kind of revolution, but not the one to stake on for corporate users. Nowadays hardware (from Intel side), Windows 2003 Server Enterprise Edition, WindowsXP Pro, and Microsoft SQL Server could be considered reasonably reliable plus it is certainly easier to support these products, because of the large pool of Microsoft-oriented IT professionals available Worldwide. Microsoft Business Solutions offers several lines of ERP systems: Microsoft Great Plains, Microsoft Navision, Solomon, Axapta. We don't want to state here that in the future Microsoft will be only ERP systems provider, but it certainly is and will be one of the major players on the ERP/MRP market. In this small article we'll consider the ways to implement large corporation required features in Microsoft Great Plains.

? GL Consolidation. If you do business exclusively in the USA ? you probably do not need this, however if you have to operate in the multicurrency and under multiple countries regulations ? you need this feature. European ERPs of late 1990th had this GL consolidation as separate module. Microsoft Great Plains doesn't have this feature out of the box, and you have to implement it via MS SQL Server Data Transformation package, Stored Procedure or Great Plains Dexterity customization. The alternative approach is to use Enterprise Reporting or FRx with multicurrency to provide consolidated reporting

? Internal Audit reports. Internal Auditor should be provided with reliable random selection of documents to review. Great Plains is MS SQL Server based application and if you base your Crystal Report on the stored procedure in SQL Server ? you can easily get random selection

? Intercompanies Transactions. This is probably complicated with multicurrency ? but Great Plains has the module to address this issue

? Customer/Vendor Consolidation. You might deal through agents on your local or regional markets and based on the results you pay the agent or subtract from it. This feature is covered in Customer/Vendor Consolidation module

? Multiple languages support. Great Plains had support to all the major languages in version 6.0. When Microsoft acquired Navision Software ? it staked on Navision in continental Europe and all the emerging markets (Russia, East Europe, Brazil, China). The way you implement local language or Unicode characters support ? you translate several screens for GP local users and extend Dexterity with Unicode enabling software utility.

Do your homework with regards to implementation, customization, integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com

---

Spyware, Adware, etc. -- Terms and Common Sense

When reading an article where some term is used often,... Read More

It?s Back!! WordPerfect?s Amazing Comeback

Have you noticed WordPerfect is gearing up for a comeback... Read More

Microsoft Great Plains: Annual Enhancement Program ? How To Be Re-Enrolled

Microsoft Business Solutions Great Plains is mid and even corporate... Read More

Is Your Family Protected?

When you think... Read More

The Truth about Colossus: Are You Just A Magnetic Image?

What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More

Microsoft CRM Implementation & Customization: MS CRM Fax Gateway

With this small article we are continuing Microsoft Business Solutions... Read More

Perfectly New Database Query Tool - Foxy SQL Pro Released

Are you a database professional? Do you work with a... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

Helping Newbies Understand Professional Software

The Windows registry is a huge database that ensures normal... Read More

Cisco Certification: Introduction To ISDN, Part IV

In part III of this ISDN primer, we learned that... Read More

Microsoft CRM Implementation for Large Corporation ? overview

Microsoft Business Solutions CRM is now approaching the phase of... Read More

How the Firefox: How to... Manual Helped Me

A few months back I really got sick of my... Read More

Beware of The Pirated Software E-Mail Scams!

You have gotten those E_Mails buy software at deep discounts.... Read More

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

Antivirus Software ? Get The Bugs Before They Get You!

You turn on your computer, and it doesn't look quite... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

Groupware and Online Collaboration: Collaboration Series #4

This article is the fourth of a series of articles... Read More

Who?s Watching What You Type?

If someone entered your home, uninvited and installed numerous cameras... Read More

Microsoft Great Plains e-Commerce ? additional considerations for programmer

Microsoft Great Plains, designed back in 1990th as database transferable... Read More

Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant

When you visit department stores and see that majority of... Read More

IBM Lotus Domino or Microsoft Exchange?

IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

Why Java RDBMS?

It is a well known fact that Java as a... Read More

Great Plains Dexterity: Customizations & Source Code Programming

Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

Performance Tuning of a Daffodil DB / One$DB -JDBC Application

This article illustrates the best practices to improve the performance... Read More

How To Create A Data Capture Procedure Checklist For Your Small Business CRM Software

Fortunately one of the most common reasons cited for the... Read More

Does your Company have Documentum?

Are you lost in the mess of documents that get... Read More

Software Piracy

SOFTWARE PIRACY We regularly hear reports... Read More

How to Choose the Right Accounting Software for Your Business

With any good luck and a good amount of hard... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

What is Shareware?

Shareware is software that you can try before you buy;... Read More

Removing Incoming Email in MS Exchange, C# Example

The purpose of one of our projects was MS Exchange... Read More