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

---

FreeDOS

Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Device Driver Basics

Most people understand that the "hardware" part of their computer... Read More

Understanding Document Management

The term "document management" and "paperless office" is the subject... Read More

Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content

It's no secret that software companies operate in a very... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

Choose your Java Wisely

Java has come along a long way. Many would agree... Read More

It?s Back!! WordPerfect?s Amazing Comeback

Have you noticed WordPerfect is gearing up for a comeback... Read More

Microsoft Great Plains Reporting ? Overview for Developer

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

7 Things to Consider Before Buying Small Business Accounting Software

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

Backing Up And Restoring Your MySQL Database

If you've been using MySQL database to store your important... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

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

My Experience - Making a Vision into Reality

Disclaimer: All the thoughts expressed are my views only! Your... Read More

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

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

Microsoft eCommerce Web-development: Great Plains eConnect .Net ? Highlights for Programmer

In our small article we'll consider Microsoft Business Solutions Great... Read More

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

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

Know-how in Microsoft Publisher

For those who still don't know, Microsoft Publisher helps computer... Read More

EDI: Electronic Document Interchange for Microsoft Great Plains ? Overview for Software Developer/Pr

Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More

What is Preventive Maintenance Software?

Preventive Maintenance (PM) is defined as scheduled work done on... Read More

Lowering The Risks In Developing Do-It-Yourself Software Projects

Mike Dunville* had a decision to make. As the new... Read More

Dreamweaver vs FrontPage

There are two major WYSIWYG(What You See Is What You... Read More

Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer

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

Begun, The Browser Wars Have

As Mozilla Firefox nears 10% market share, with well over... Read More

Demand More From Your Lead Tracking Software

An integral part of any quality CRM system is lead... Read More

Microsoft CRM for Corporate Business ? Working Offline

If your company has regional and worldwide operations, you might... Read More

Quick Summary of Basic and Common Linux Commands

There are many commands that are used in linux on... Read More

Great Plains Dexterity History and Programming Overview

As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More

Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

Currently Microsoft Business Solutions is on the way of creating... Read More

Guide to Software Marketing

Intro This concise article will tell you in plain English... Read More

Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

Best Spyware Removers

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

Photoshop Files and Formats

People often ask me: What image file formats will Photoshop... 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

Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer

Microsoft Business Solutions Great Plains is written in Great Plains... Read More