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


Lotus Domino/Notes - Microsoft Great Plains Tandem as ERP with Documents Workflow - Overview for IT

Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More

Why Stick With Email Clients Like Outlook?

Trying to figure out a stream in banning one email... Read More

Simple Solution for Php Includes - IFrames

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

Microsoft CRM Customization Secrets ? Second Edition

This article is for advanced Microsoft CRM SDK C# developers.... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

The Software 2005 Conference - A Review

The Software 2005 conference is now a wrap. This conference,... Read More

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... Read More

Lotus Notes Domino and Microsoft CRM Integration

Well, even if the combination might look very unusual, we... Read More

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

Let us give you - developer some hints in the... Read More

The True Meaning of Freeware

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

Two Reasons to Use Timesheet Software

This short paper will expand on two key reasons to... Read More

Razzle Dazzle Them

Once upon a time not so long ago, there was... Read More

Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution

Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More

Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer

... Read More

Instant Messenger Clients

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

Corel WordPerfect 7 Macro Programming Example

Case study: A secretary using Corel WordPerfect 7 is often... Read More

Increase Office Efficiency With One Simple Tool

When you need a phone number, you do a quick... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

The Religion And Philosophy Of Small Internet Business

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

Spyware Protection: A Must for Any Home Computer

Now that spyware is the single most dangerous threat to... Read More

7 Things to Consider Before Buying Small Business Accounting Software

The world of small business accounting software can be a... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

Defining OLAP Solutions and Data Warehouse design

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

Great Plains Dexterity Development: FAQ

Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More

Microsoft Great Plains eCommerce: overview for developer

Microsoft Business Solutions Great Plains was designed back in the... Read More

Hear It in Digits

Music downloads are off the charts! We're listening to digital... Read More

Review of TikiWiki Content Management System

TikiWiki is open source software - it is written in... 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

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... Read More

Microsoft Great Plains Food Processing ? Implementation & Customization Highlights

Microsoft Great Plains might be considered as ERP platform to... Read More

3 Reasons Why Medical Billing Software is Leading the Way

Since technology changes so quickly, it is hard to begin... Read More

Photoshop Files and Formats

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

5 Mac Security Tips You Can?t Live Without

So, you've bought a new Macintosh, and now you may... Read More