Microsoft Great Plains Jewelry ? Implementation & Customization Overview

Each Industry and market niche has business specific and unique requirements to ERP/Accounting System. Microsoft Business Solutions Great Plains is ERP platform, ready for third party modules additions and customizations, plus being SQL Server-based system it opens you wide spectrum of integration options and tools. In this small article we'll give you Microsoft Great Plains implementation and setup highlights, typical for Jewelry retail network.

? Fixed Assets. Jewelry retailer owns the network of jewelry retail outlets and each one has relatively expensive set of fixed assets: counters, holders, computers, etc. Company has to track each individual Fixed Asset item and depreciate it accordingly: for IRS, State and probably several internal company management accounting depreciation scenarios and methods: straight line, DDB, etc. Due to the fact of reselling precision metals: gold, silver, gem stones and diamonds ? you should expect regular audit from IRS and State authorities. Depreciation plays substantial portion of company's non-cash expenses and so should be 100% accurate. Additional challenges ? bonus depreciation, introduced several years ago. Plus you must have comprehensive reporting on FA locations by store and region.

? EDI purchasing. In Great Plains you should be able to order your inventory via Electronic Document Interchange (EDI) mechanism. You have multiple options to realize EDI ? the simplest would be Purchase Order creation in Great Plains Purchase Order Processing/Receiving module and then exporting them into text EDI-fixed-length compliant format. This text file should be forwarded to your supplier and in Great Plains POP you set flags for POs being sent to your vendor

? Retail Management System integration. In the case when you use Microsoft RMS Store Operations and Headquarters ? you should consider seamless integration of your daily transactions into Microsoft Great Plains Sales Order Processing (SOP) or Receivables Management (RM) modules. The integration is realized as a set of MS SQL Server stored procedures. The other way would be implement both Purchasing and Inventory count on RMS Store Operations/Headquarters level and integrate General Ledger transactions only. If you have only one Great Plains Company ? you can deploy RMS->GP integration utility, coming to you with RMS purchase and support CDs.

? Reporting. In both cases ? Great Plains and RMS compliance reporting should be realized in Crystal Reports and the best way and design style is creating SQL views and stored procedures and basing report on these views and procs.

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 Integration Manager: Using Continuum ? Overview for Developer

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

Basic Tips and tricks for Windows XP

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

Microsoft RMS Customization ? PO Items Receiving in Great Plains

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

Helping Newbies Understand Professional Software

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

Simple Solution for Php Includes - IFrames

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

Implementing Microsoft CRM: setup and configuration ? notes for IT specialist

Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More

Microsoft Great Plains Implementation for Large Corporation ? Overview for VP IT

Microsoft Business Solutions Great Plains was historically designed to serve... Read More

Antivirus Software ? Get The Bugs Before They Get You!

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

Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1

The first topic we are going to discuss... Read More

OLAP, An Alternative Technology Over Spreadsheets

Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

RFID: Strengthen the Position for SAP; United States

SAP Inc., a global leader in client/server enterprise application software... Read More

You Can Write Microsoft Office Program in About 60 Minutes

Microsoft Office program is a programming tool called Visual Basic... 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

Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector ? Future Directions

IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More

Software Engineering: An Introduction

Software Engineering is the Systematic Approach for analysis design implementation... Read More

Popular Fleet Maintenance Programs

Some companies that are in need of fleet management may... Read More

Is Your Family Protected?

When you think... Read More

Snort for Network IDS

What is Snort?Snort is an open source network intrusion detection... Read More

How To Identify, Cure and Prevent Spyware/Adware Infections

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

Fleet Maintenance Software Reviews

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

Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

It would be easy to think, like most people apparently... Read More

Spyware: What It Is and How to Combat It

Spyware is software or hardware installed on a computer without... Read More

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

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

Collaboration Software: Index of Collaboration Software Technologies

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

Interactive Mapping Brings Information to Life

What is Interactive Mapping?Interactive mapping is a visual display medium... Read More

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

Groupware: What Works the Way Businesses Do?

GroupwareThe internet is full of 1.5 million to 7 million... Read More

Manufacturing Solutions for Microsoft Great Plains ? Overview for Consultant

Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More

Beware of The Pirated Software E-Mail Scams!

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

Beware of Spyware

One day, you suddenly realize that your computer started to... Read More

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... 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