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! [email protected] 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:

SOCOM Rolls Out New Software Program Office  National Defense Magazine

FreeDOS

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

Microsoft CRM Customization

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

Hear It in Digits

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

Introduction To ISDN, Part II

In the previous ISDN article, we looked at how and... Read More

Recovering Microsoft Great Plains Customization ? Tips for IT Director

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

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system... Read More

Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

There are certain pluses and minuses in both cases and... Read More

Implementing Microsoft CRM: setup and configuration ? notes for IT specialist

Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More

20 Extra Hours Per Week: What Would You Do?

While I was in college, if you would have asked... Read More

Linux vs Windows Operating Systems

With so many Microsoft Windows related viruses, errors, and other... Read More

40/sec to 500/sec

IntroductionSurprised, by the title? well, this is a tour of... Read More

Four Easy Ways To Prevent Spyware

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

Microsoft Great Plains, Navision, Axapta ? Selection Considerations

During the years of our consulting practice, which comes back... Read More

How To Choose A Fire Wall Software Program

In the real world a "fire wall" is a fireproof... Read More

Putting Screensavers Under Control

No matter how much you enjoy your favorite screensavers, sometimes... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Fundraising Software ? How Can That Help Me?

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

Free Microsoft Word Online Training Tutorial Resources

Microsoft Word is one of the most popular office applications... Read More

Microsoft Great Plains: Customization Upgrade & Recovery ? Visual Studio VB 6.0

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

S is for Spying, Surveillance -- and for Software as Well

Words we choose to describe things and phenomena often show... Read More

Backing Up And Restoring Your MySQL Database

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

How Do I Get Rid Of That Darn Spyware?

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

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1

The first topic we are going to discuss... Read More