Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview

In this small article we will show you the possible way of deploying Microsoft Business Solutions Great Plains for the market niche of large, mid-size and small reselling and distribution business in carpeting and floor covering, textile & fabric. We will not be talking about fabric production, but rather cutting for the end-user or small retailer. Microsoft Great Plains itself in our case should be considered as a platform for light customization and modification. We'll describe industry requirements and the way them to be implemented in Great Plains

? Variable Length Rolls. Usually, when you place and order through your supplier ? there is no way to know exact length of the roll or bolt. It might have 75 yards or 80 yards ? you typically know the average length, say 77 yards and this is why you know what to expect in yards if you purchase 10 bolts

? Inventory in Yards. When you receive the roll ? you need to place it into inventory in exact yards. Typical method is to assign lot number to the bolt and then associate the exact initial length in yards with this unique lot number. This is Great Plains Dexterity customization, which provides parallel unit of measure, associated with the lot number

? Light Assembly. Bill of Materials would be probably too complex for cutting the fabric. This is why we suggest to deploy automatic inventory decrease and increase adjustments ? you decrease number of yards in the roll and increase your finished good in the number of units assembled

? Meter / Yard challenge. If you purchase from the supplier in China, Mexico, South East Asia or Europe ? they measure their rolls in meters, not yards ? so you need to implement automatic unit of measure translation and conversion. You resolve this on the level of your EDI ? electronic document interchange

? Cut-beds tracking to original roll. If you are assembling/cutting something like billiard table beds ? you would like them to be tracked to the original roll in the case of customer complaint. This means that you will have to assign the same or modified lot number to the cut-bed

? Inventory Count. You need to track what is the current length of the bolt/roll. This is realized via custom Dexterity table, having Item Number, Lot Number, Initial Length in Yards, Current Length in Yards

? Customization Tools: Great Plains Dexterity ? this is Great Plains Dynamics programming language and development environment; Modifier with VBA ? will allow your modify Great Plains forms and attach VBA scripts to your custom buttons; SQL scripts and stored procedures ? low level database programming, excellent for the professional with profound GP tables structure and data flow knowledge.

Good luck with implementation, customization and integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! help@albaspectrum.com Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia

---

10 Things You Could be Using Photoshop For, But Probably Arent

Most people don't use Photoshop to its fullest capabilities. Here... Read More

Microsoft Great Plains - Microsoft RMS Integration ? overview

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

Best Spyware Removers

Finding the best spyware removers to detect and remove spyware... Read More

Protect Your Computer...and Your Business!

We all take the computer for granted. I mean, all... Read More

Groove Network. Are you in it?

If you are in a business that passes documents around... Read More

Troubleshoot Windows with Task Manager

Task Manager is a Windows system utility that displays thetasks... 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

Antivirus Software ? Get The Bugs Before They Get You!

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

Popular Fleet Maintenance Programs

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

Did You Ever Want to Completely Erase Everything on Your Computer?

Did you ever want to erase everything on your computer?... Read More

Microsoft CRM Customization

Microsoft CRM customization techniques are very diversified and based on... Read More

Performance Tuning of a Daffodil DB / One$DB -JDBC Application

This article illustrates the best practices to improve the performance... Read More

Software Piracy

SOFTWARE PIRACY We regularly hear reports... Read More

How Do I Get Rid Of That Darn Spyware?

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

eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains

eStore Advantage allows front-office applications to communicate with back-office business... Read More

OSI Layers Model

IntroductionDuring the early years of our modern computer era, very... Read More

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... Read More

What is a Document Manager without Version History?

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

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

Cisco CCNA Certification: Becoming A Truly Valuable CCNA.

I've been active in the Cisco Certification track for four... Read More

Microsoft Great Plains Inventory Control ? Overview For Consultant

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

COSMIC: A Small Improvement on the Symons Method

The COSMIC FP (function point) software quality metric, is no... Read More

Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE

Lotus Notes Domino is very efficient in electronic document workflow... Read More

Microsoft Great Plains Integration Manager ? Working With Text File

Microsoft Business Solutions main middle market ERP application - Microsoft... Read More

Professional Software Icons For Your Standalone Application

User interfaces and accessibility are some of the most important... Read More

Ukraine IT Myths Dispersed

While Ukraine is becoming a new popular IT outsourcing destination,... Read More

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

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

PHP On-The-Fly!

IntroductionPHP can be used for a lot of different things,... Read More

Introduction To ISDN, Part III: PAP

Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More

Recovering Microsoft Great Plains Customization ? Tips for IT Director

Remember nice and prosperous Clinton era? When you implemented innovative... Read More