Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

Microsoft Great Plains fits to majority of horizontals and retail business is good fit as well. We'll consider the system, consisting from Microsoft Great Plains as Accounting, Inventory Pricing and Microsoft Retail Management System (RMS) Headquarters and Store Operations Manager. In this case you can base web commerce off Great Plains databases and POS automates walk-in retail store. Inventory count might be done from both sides: Great Plains or RMS, depending on the main line ? if it is eCommerce ? consider Great Plains inventory cycle counting, otherwise in the case of POS ? it should be done in MS RMS

? eCommerce. If the business is small/mid-size, instead of using eConnect ? consider working with direct sql custom stored procedures. You will avoid license fee for eConnect and you could use rather simplified logic. You need to know Great Plains Tables structure and data flow: Tools->Resource Description->Tables. More likely you will need Sales Order Processing (SOP) and Inventory Control (IV) tables: SOP10100, SOP10200, IV00101, etc. You should consider purchasing standard internet basket and integrate it with your e-commerce web application. It should work with Great Plains Inventory catalogue

? Catalogue update. If you resell computer parts ? you should have utility, updating your inventory items and price list as you get new catalogue from the distributor. This might be done as SQL routine or Great Plains Dexterity customization. Dexterity will allow you to alter Item Maintenance screen ? if you have additional description line for the item, or similar little things

? Microsoft RMS->GP transactions integration. You can purchase integration directly from Alba Spectrum Technologies, and it works on Sales Order Processing or Accounts Receivables transactions integration level and has also Purchases integrated. This integration could work as nightly SQL routine and bring all the daily sales transactions from RMS stores or Headquarters to mapped Great Plains companies.

? Promotional pricing. These campaigns are automated in RMS and Great Plains, however promotion scenarios might be not the same. One of the ways to synch both systems is to use RMS promotions and update Great Plains price list via custom stored procedures.

? Inventory Items Synchronization. Again you can base your items in either one of the systems: Great Plains or RMS and then synchronize via stored procedures.

? Additional RMS custom issues. Some customers mentioned the need in editing global customer data on the store level and the second interesting suggestion was immediate propagation across all the stores gift card balance ? if customer walk in into several stores within the day ? the chances are that balance is still not updated via Headquarters worksheets

Good luck with implementation and customization 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

---

Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist

C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More

Create A Flash Presentation For Free With Open Office

The intentions of this short tutorial are not to teach... Read More

Introduction To ISDN, Part II

In the previous ISDN article, we looked at how and... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options

Microsoft bought Navision, Denmark based software development company, along with... Read More

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

And kill the best layout software in the process of... Read More

Device Driver Basics

Most people understand that the "hardware" part of their computer... Read More

SQL Administrator Skills Required to Support Microsoft Great Plains

Microsoft Great Plains is becoming more and more popular and... Read More

Who Is Minding Your Sensitive Data?

Stealing company information used to be the specialty of spies... Read More

Microsoft Great Plains Middle East - Arabic Language Support

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... Read More

Is Your Small Business Ready For A CRM Software Solution?

I have yet to see a business that, sometimes in... Read More

Kick-Ass Performance For Your PC? Its Easy

Is your PC is slow and wimpy? Then you need... Read More

Easy Guide to RAID Recovery

What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More

Microsoft CRM or Siebel

Siebel is traditional CRM market leader, however and mostly due... Read More

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... Read More

Recovering Microsoft Great Plains Customization ? Tips for IT Director

Remember nice and prosperous Clinton era? When you implemented innovative... Read More

How to Choose the BEST Charting Software

I suggest that you do not spend a lot of... Read More

Microsoft Great Plains Integration Manager ? Working With Text File

Microsoft Business Solutions main middle market ERP application - Microsoft... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

A Time-Saving Programming Tactic that Doesn?t Work

Let's say that you have a software project that's under... Read More

Groupware and Version History: Collaboration Series #1

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

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More

Downloading Spyware Removers: Think Before, not After

Just imagine: you are walking, say, towards your car, and... Read More

Think Of This

Think of this, first we had the HAM Radio, then... Read More

The Religion And Philosophy Of Small Internet Business

I have always had a tendency to focus on the... Read More

Demand More From Your Lead Tracking Software

An integral part of any quality CRM system is lead... Read More

C++ Tutorial 2, Input and Variables

This is the tutorial where we really get into programming.... Read More

Simple Solution for Php Includes - IFrames

I have recently created my first Php program. I wanted... Read More

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system... Read More

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

Scrap Booking Online: Word Perfect or Corel Graphics Suite?

Scrapbooks are very popular these days. I think that almost... Read More