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


Marketing Your WinRunner Team

It won't matter how effective your WinRunner Team is if... Read More

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

Microsoft bought Navision, Denmark based software development company, along with... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

Five Tips For A Great Software Demo

Whether you need to close a sale, gather end-user feedback,... Read More

Groupware as a Document Manager: Collaboration Series #3

This article is the third of a series of articles... Read More

Microsoft Great Plains Middle East - Arabic Language Support

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

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

Spyware Protection: A Must for Any Home Computer

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

Is Software Tester a Most Infamous Person in a Software Project Team?

The fact that a software tester is a most infamous... Read More

Groove Network. Are you in it?

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

Microsoft CRM: Implementation, Customization, Support ? Consultant Overview

Microsoft Business Solutions CRM is present several years on the... 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

Constructionalist Parsing - Deciphering Natural Language

The research in the field of Natural Language Processing usually... Read More

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software... Read More

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

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

Healthcare Preventive Maintenance Software

Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More

Crystal Reports for Microsoft Great Plains

Microsoft Business Solutions ? Great Plains is designed to meet... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Increase Office Efficiency With One Simple Tool

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

Create A Flash Presentation For Free With Open Office

The intentions of this short tutorial are not to teach... Read More

Groupware Finds Home in American Business: Collaboration Tool Analysis

What is Groupware?Have you ever had to manage document collaboration... Read More

Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan FAQ

Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More

Software Tools To Help Your Business Sell More

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

Microsoft CRM Customization - Processing In/Out-Going Email Messages

We would like to give you several situations, when you... Read More

Off The Record - Tips For Picking Recording Software

Need software to record your voice, streaming audio or musical... Read More

Four Easy Ways To Prevent Spyware

How would you like to prevent spyware and adware from... Read More

Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

Microsoft Great Plains fits to majority of industries, in the... Read More

Linux Vs. Windows

This article will not attempt to advocate the use of... Read More

Protect Your Computer...and Your Business!

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

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

Microsoft Great Plains is one of three Microsoft Business Solutions... Read More

How To Create A Data Capture Procedure Checklist For Your Small Business CRM Software

Fortunately one of the most common reasons cited for the... Read More

MicroWorld Releases New Version of MailScan Ver. 4.5 - Antivirus and Content Security Software

MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More