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
|
|
|
Ukraine It Myths Dispersed
While Ukraine is becoming a new popular IT outsourcing destination, there are still many myths about it and no clear understanding of the opportunities outsourcing to Ukraine can present. Let us look closely at some of those myths and find out whether there is any truth behind them.Myth No. 1 ? Ukraine is politically unstableThis myth has seen its rise in November-December 2004 during the events around the presidential elections that led to the Orange Revolution. However, presently there are no grounds for concerns. During the Orange Revolution, the Ukrainian people have shown their devotion to the democratic ideals and prevented the worst scenario from happening, bringing the legitimately elected president to the power. The new Ukrainian government has clearly voi...(related: Software)
Upgrading Great Plains Dexterity Customization ? Switching To New Technologies: Sql, Crystal, Econne
1. Replace Dexterity cursor with SQL Stored Procedure
Dexterity was designed as multiplatform technology (primarily Btrieve, Ctree, SQL Server, potentially Oracle). Dexterity data retrieving mechanism is based on Range start, Range End, Get First and Get Next clauses. It is in fact similar, however a little bit slower to cursors in Transact SQL. Long ranges in Dexterity are good candidates for replacement by SQL stored procedures with update clause.
For example, consider to replace following Dexterity code:
Range clear SOP_HDR_WORK.
Clear 'SOP Type' of table SOP_HDR_WORK.
Clea...(related: Software)
Backing Up And Restoring Your Mysql Database
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.Backing up your databaseThe quickest and easiest way to backup and restore your database would be to use MySQLDump. If you've got shell or telnet access to your server, you can backup...(related: Software)
Five Reasons For Using An O/r Mapping Tool
So, why should you use any O/R mapping tool? I am not talking about a specific tool but rather all O/R mapping tools in general. There are a number of reasons for using an O/R mapping tool but before I dive into that, let me give you a brief overview of what an O/R mapping tool really is.An O/R mapping tool generates persistence objects for your .NET application. It is a modeling and code generation tool that connects to your database and reads its schema, then lets you map objects to database tables and views, specify single-row inse...(related: Software)
How To Make Attractive And Effective Powerpoint Presentations
Microsoft PowerPoint has dramatically changed the way in which academic and business presentations are made. This article outlines few tips on making more effective and attractive PowerPoint presentations.THE TEXT
- Keep the wording clear and simple. Use active, visual language. Cut unnecessary words ? a good rule of thumb is to cut paragraphs down to sentences, sentences into phrases, and phrases into key words.
- Limit the number of words and lines per slide. Try the Rule of Five - five words per line, five lines per slide. If too much text appears on one slide, us...(related: Software)
Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan Faq
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM require existing customer to be ...(related: Software)
Software Development In 2005 - Back To The Future
2005 ? Back to the Future.What does the future hold? A big question and initially the answer is anything and everything. The predictions are sometimes close but most of the time they are far from the reality. Technology has moves on apace and the core players in the various sectors of the computing industry invest in research and development which increases the rate of technology introduction with performance improvements or benefits outweighing the previous technology that customers/users/consumers must take advantage of, or so that is what they tell us. What is the truth? And what is the future?For the developer community I believe that things have not changed all that much other than there a more defined lines to be drawn between types of developers i.e. games vs corporate applications, mobile vs military. T...(related: Software)
Benefits Of Shareware
Shareware has been fighting the stigma of being misunderstood for decades. While corporate software giants can no longer ignore the marketing potential of a trial version, small software startups are struggling with new listings and bandwidth costs. Businesses and individual consumers need to take a closer look at the benefits of taking advantage of shareware marketing. The concept of a trial version is not a new one. Consumer expectations, and the need for immediate satisfaction have spurned the industry to realize the need for instant software. The availability of file downloads in the Internet era, is spurning a revolution of purchasers who never leaving their homes or offices. As a result, the Internet has taken the proliferation of shareware to a new level.Why the Success?Why developers have succeeded using shareware market...(related: Software)
Microsoft Great Plains Customization And Development ? Overview For Programmer
When Great Plains Software was designing and developing Great Plains Dynamics/Dynamics CS+/eEnterprise - it placed several fundamental principles into the system1. Computer platform independence. If you consider the situation in the computer software industry those days (earlier 1990-th) - nobody knew which office computer platform will be the winner: IBM PC ...(related: Software)
Adware And Spyware Blockers
The most important things you can do for your computer right now is to install adware and spyware blockers. Everyone is aware of computer viruses and run an anti-virus program to guard your c...(related: Software)
Sql Administrator Skills Required To Support Microsoft Great Plains
Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator position is a must. If you are database administrator and you are part of the decision making team, purchasing Microsoft Business Solutions Great Plains for your corporation, we would l...(related: Software)
Microsoft Great Plains & Crm In Transportation & Logistics ? Overview
Microsoft Business Solutions Great Plains and MS CRM (client relation management system) are very p...(related: Software)
Microsoft Crm Customization ? Programming Closed Email Activity
Microsoft CRM is CRM answer from Microsoft and attempt to get market share from Siebel, Oracle and others traditional Client Relationship Management System vendors. Microsoft CRM uses all the spectrum of Microsoft recent technologies: .Net, MS Excha...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software