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

In The News:


pen paper and inkwell


cat break through


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

Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More

Microsoft Great Plains Implementation in Russia ? Overview for Consultant

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

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

Microsoft Great Plains: Annual Enhancement Program ? How To Be Re-Enrolled

Microsoft Business Solutions Great Plains is mid and even corporate... Read More

Groupware: Answers the 5 Questions of Document Collaboration

Every organization which creates collaborative documents, whether they are budgets,... Read More

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... Read More

The Religion And Philosophy Of Small Internet Business

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

Free Software: How Not To Get More Than You Bargained For!

I completed an experiment recently. I wanted to find out... Read More

Theres Gold in Your Websites Server Log

Many Webmasters have never bothered to view their website's server... Read More

Why do Manufacturers Invest in Business Management Software?

With many manufacturing shops heading over seas in favor of... Read More

Exactly What Does FTP Stand for and What Can it do for Me?

FTP stands for "file transfer protocol". FTP is basically a... Read More

The Truth about Colossus: Are You Just A Magnetic Image?

What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More

Ukraine: a Prospective Player on the World Software Outsourcing Market

The destruction of the Soviet Union about 15 years ago,... Read More

eCommerce development for Microsoft Great Plains: tools and highlights for programmer

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

Simple Solution for Php Includes - IFrames

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

Instant Messenger Clients

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

Fundraising Software ? How Can That Help Me?

Fundraising software lets you connect with donors in a way... Read More

Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting

Manufacturing in the USA is far away down from mid... Read More

Accounts Payable: A Powerful Document Management and Workflow Solution

Accounts payable is just one area of office management where... Read More

SSH (SCP) Send Files from Windows to Your Linux Box

Not all of us have the luxury of working both... Read More

A Case Study on Selecting Contract Management Software

Professional services firm cuts costs and improves productivity with integrated... Read More

Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup ? overview

Microsoft Great Plains may be recommended for international freight forwarding... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

Linux for Home Users

Hey Guys! Don't raise your eyebrows or fear by hearing... 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

Tools for Customizing Great Plains

Microsoft Business Solutions ? Great Plains has captured the US... Read More

Groove Network. Are you in it?

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

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

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

C++ Tutorial 2, Input and Variables

This is the tutorial where we really get into programming.... Read More

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

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

Microsoft CRM Customization Secrets ? Second Edition

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