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

---

Photoshop Files and Formats

People often ask me: What image file formats will Photoshop... Read More

Keep Your Software Simple! A Review of EditPlus

I like my software simple. If it's too complex or... Read More

Computer Based Language Development and Spell-checking

Language development computer: Computer-based method for aiding language development seems... Read More

What to Do if All Screensavers Fun is Grayed Out?

Finally, you have some time to personalize your desktop with... 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

Begun, The Browser Wars Have

As Mozilla Firefox nears 10% market share, with well over... Read More

Run Your Own Search Engine

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

Data Quality Best Practices for Salesforce.com

Executive SummaryAn effective plan for entering, cleaning and updating the... Read More

Fleet Maintenance Software Reviews

Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More

Microsoft Office Selecting Secrets

Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More

Defining OLAP Solutions and Data Warehouse design

This tutorial covers OLAP solutions used by Data warehouses and... Read More

Microsoft Great Plains POP: Purchase Order Processing ? Overview For Consultants

Great Plains Purchase Order Processing (POP) module makes up one-third... Read More

The True Meaning of Freeware

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

Microsoft Great Plains: Large Scale Implementation

Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Dig Out That Worm

Internet worms. Is your PC infected?If your computer has become... Read More

Microsoft Great Plains Implementation in Russia ? Overview for Consultant

Microsoft Business Solutions Great Plains is very popular ERP platform... Read More

IBM Lotus Domino or Microsoft Exchange?

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

20 Extra Hours Per Week: What Would You Do?

While I was in college, if you would have asked... Read More

Software Piracy - Global Increase

Pirated software is on the increase and now accounts for... Read More

Dont Choose Adobe When Working With PDF

While Adobe is the most known maker of PDF tools,... Read More

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

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

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More

Groupware and Version History: Collaboration Series #1

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

Beware of The Pirated Software E-Mail Scams!

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

Lotus Notes Domino and Web: Application Development ? Tips for Programmers

Beginning with Domino version R4 it has integration with the... Read More

Collaboration Software: Index of Collaboration Software Technologies

Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

ERP Software Financing: the Future? ? Overview for Company Owner

In our case ? we serve Microsoft Business Solutions ERP... Read More

The Bluebird Project

The objective for Zandi Digital is to make available clever... Read More

Cisco Certification: Introduction To ISDN, Part IV

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

Microsoft Great Plains BR: Bank Reconciliation

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

An Easy Way to Deal with Email Viruses and Worms

If you feel intimidated when someone tries to teach you... Read More