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

In The News:

pen paper and inkwell


cat break through


Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

Microsoft Business Solutions Great Plains has I'd say end user... Read More

Groupware and Version History: Collaboration Series #1

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

Do You Want Your Own Fully Programmable ERP? - Part 1

We are in a transition phase in the Managerial Administration... Read More

Microsoft Great Plains in Metal Distribution: Implementation & Customization ? Consultant Overview

Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More

The Dirt on Screensavers

Remember back in the days where screensavers were the coolest... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

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

Software Automation Helps Increase your Bottom Line

When you own a small business, time is money. And... Read More

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

Software: What Suits Me?

Almost all new and major brand of PCs come with... Read More

Review on QuarkXpress 6.0

After almost two decades of existence, Quark has become the... Read More

How To Make Good Use of Spreadsheets

Most computer users use spreadsheets software such as Microsoft Excel... Read More

Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content

It's no secret that software companies operate in a very... Read More

Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist

This is a short article, written in question/answer/FAQ style to... Read More

Brief Notes About Mainframe Software Pricing

We don't think about mainframe software pricing anymore, we just... Read More

Microsoft RMS Customization ? PO Items Receiving in Great Plains

Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

Artificial Intelligence And Intuition

The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More

Bill of Lading ? Custom Reporting for Microsoft Great Plains ? Overview for Consultant

Bill of Lading is required report for Logistics and Freight... Read More

Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Run Your Own Search Engine

Our hosted solution allow you to run your own search... Read More

Basic Tips and tricks for Windows XP

Running Applications in Compatibility Mode With Windows XP, you can... Read More

ERP Consulting: Microsoft Great Plains Partner Future Directions

In the Clinton era the status quo was simple: you... Read More

How to Make Attractive and Effective PowerPoint Presentations

Microsoft PowerPoint has dramatically changed the way in which academic... Read More

Microsoft Great Plains Reporting ? Overview for Developer

Looks like Microsoft Great Plains becomes more and more... Read More

Who Is Minding Your Sensitive Data?

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

ERP Implementation: Success Factors

As seeing large number of implementations ? in our case... Read More

Great Plains Customization Upgrade? Overview For CIO/IT Director

Around the same time Microsoft made its move with .Net... Read More

Microsoft Navision and Crystal Reports - An Overview

Microsoft Business Solutions ? Navision is an integrated solution for... Read More

C++ Tutorial 2, Input and Variables

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

The True Meaning of Freeware

The vast majority of us will have, at some point,... Read More