Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise was introduced in 1993 as first Microsoft Windows and Macintosh based graphical accounting/ERP application for Mid-Size businesses. Considering the history of furniture retailer and custom assembly lines ? they showed up on the market about five decades ago and they have automated their business operations with Unix-based businesses in the late 1960th and earlier 1970th. You can find such furniture resale systems as Storis, which is Unidata based application, automating furniture retail outlets. Let's consider the options.

? General Ledger. There is no need to immediate replacement of legacy retail stores automation software. It is reliable and proved to work over years. They usually sit in very reliable Unix hardware such as IBM AS/400 or RS6000. You would need just import General Ledger transaction to the system, where you would have flexible and quick financial reporting. In this case you need Unidata export and feed it into Great Plains General Ledger. Use Great Plains Integration Manager or heterogeneous SQL queries.

? Payroll. Great Plains would be reasonably priced payroll solution if you process payroll inhouse. If you have less then 500 employees ? then Great Plains Standard douse excellent job and software price would be around k$10. You will have to pay annual maintenance program and receive Payroll taxes and federal magnetic media updates to keep you safe from the payroll taxation errors and miscalculation. If you cross over 500 employees line ? Great Plains software price will be around k$30 and you could find cheaper solutions with unlimited number of employees ? look at Accpac.

? eCommerce. If you are replacing your legacy system, then you could build eCommerce upon Microsoft Great Plains Inventory Control (IV) and Sales Order Processing modules. Looking into the future you should expect increasing portion of you business to come from eCommerce ordering. Here you deploy eConnect and have your or contracting developers do the job. If eConnect is too expensive ? you could appeal to experienced developers, who has set of custom stored procedures to work with SOP10100, SOP10200 and IV00100 tables

? Commission Reporting. In Furniture outlet shift manager commission is based on her/his employees-salespersons performance. And it is usually tiered. We saw very complex and proprietary formulas. Our suggestion is to realize it in SQL Stored Procedure and then you could create Crystal Report with parameters to calculate and report commission amounts

We encourage you to analyze your alternatives. You can always appeal to our help, give us a call: 1-866-528-0577 or 1-630-961-5918, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies (http://www.albaspectrum.com), serving Microsoft Great Plains, CRM, Navision to mid-size and large clients in California, Illinois, New York, Georgia, Florida, Texas, Arizona, Washington, Minnesota, Ohio, Michigan

In The News:

pen paper and inkwell


cat break through


Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

This is intermediate level SQL scripting article for DB Administrator,... Read More

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Introducing GRML

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

How Do I Get Rid Of That Darn Spyware?

Ad-Aware and Spybot are probably the two most well known... Read More

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

Builders Beware

Which Type of Shop Can Rely On A Home Built... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

What is Spyware? Are You Being Watched?

Find out why Spyware Removal from computers is important and... Read More

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Microsoft Great Plains Reporting ? Overview for Developer

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

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

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

Upgrading Great Plains Dexterity Customization ? switching to new technologies: SQL, Crystal, eConne

1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

Crystal Reports is the most flexible tool on the market... Read More

Device Driver Basics

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

Microsoft Great Plains international implementation ? USA / Mexico ? overview for consultant

Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More

Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur

I started using PIP (Picture It Publishing) Platinum 2002 right... Read More

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

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

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

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

Adware and Spyware Blockers

The most important things you can do for your computer... Read More

Microsoft CRM Customization ? Programming Closed Email Activity

Microsoft CRM is CRM answer from Microsoft and attempt to... Read More

Microsoft Great Plains 8.0 Brazilian Version ? Overview For International Consultant

Microsoft Great Plains has substantial mid-market share in the USA... Read More

Antivirus Software ? Get The Bugs Before They Get You!

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

Programming Environments And The Software Production Process

Introduction: The creating of a computer program involves a number... Read More

Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

How To Develop Software For Your Business

Software development is a risky business.Many software developers are barely... Read More

How To Identify, Cure and Prevent Spyware/Adware Infections

Just when you thought you were Web savvy, one more... Read More

CRM and Customer Life Cycle

Customer Relationship Management or CRM is a combination of enterprise... 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

What is a Document Manager without Version History?

Document Manager and Version HistoryIn previous articles I have discussed... Read More