Software Information |
|
Microsoft Great Plains - Typical Problems And Fixes ? Overview For IT Administrators
How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix:
How to unlock the batch? This happens when user posts the batch and has her computer crashed (via surfing the internet - smile - or things like this)
Now we would like to stress you the need to move away from Pervasive SQL 2000/Ctree platforms - you are in trouble - Microsoft Business Solutions cuts technical support for Microsoft Great Plains 7.5 and prior on these platforms. This means not only the support, but also tax updates (especially Payroll and Federal Magnetic Media). What is migration from Ctree/Pervasive.SQL 2000 to MS SQL/MSDE? MBS has migration tool. You need first to install Great Plains on SQL Server with exactly the same account/segments structure and then install migration tool (it is Dexterity chunk) on your ctree/Pervasive workstation - then, when you integrate the chunk - you will map it to target SQL-based Great Plains Company, select all system and company tables, click the button and it will move all your tables one-by-one. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data Do I need consultant? It is probably good idea to have consultant to do the upgrade. We strongly recommend you to use consultant in the following cases
Good luck in fixing and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! [email protected] Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Colorado, Oregon, Washington, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: [email protected]
|
RELATED ARTICLES
Software Review: Xsitepro Total Site Management Software It's not very often I get excited about a software program, but today I'm so excited I just had to tell you about Xsitepro, the top tool for Internet marketers. In particular, those who have been using HTML applications programs like Dreamweaver and Frontpage to produce their Internet media will find this program revolutionary in that it can at least halve your time for site development. ERP Consulting: Microsoft Great Plains Partner Future Directions In the Clinton era the status quo was simple: you serve your local clients and if you want to expand your business ? open offices in other business metros. Great Plains Software was granting generous margins on the software sales and stimulated local leading VARs/Partners/Resellers with so-called orphan leads ? customers who lapsed in payment annual enhancement program or called Great Plains Software directly to comply about quality of service by their VAR. When Microsoft purchased Great Plains Software and formed Microsoft Great Plains Business Solutions (soon renamed into Microsoft Business Solutions) and acquired new ERP/MRP/accounting applications: Navision, Axapta, Solomon (Solomon Software was bought by Great Plains Software in the late 1990th). When Microsoft introduced Microsoft CRM ? it tried to change traditional partner reselling model, let's see what it is and why (this is our personal opinion ? we are trying to envision the future for generic ERP VAR) Microsoft Great Plains e-Commerce ? additional considerations for programmer Microsoft Great Plains, designed back in 1990th as database transferable and graphical platform independent ERP application ? Great Plains Dynamics/Dynamics C/S+/eEnterprise. For eCommerce developer the most important is to understand Great Plains tables structure and business processes in Sales Order Processing, Accounts Receivables, Inventory Control (inventory items allocation, backordering, etc), posting to Bank Reconciliation and General Ledger. And this is where Great Plains structure seems to be not transparent. Let's give you highlights: ERP Implementation: Success Factors As seeing large number of implementations ? in our case these are Microsoft Business Solutions Products: Great Plains, MS CRM, Navision ? we would like to give you our opinion on what should you consider to do to secure implementation success. These principles should work as for large corporation as well as for midsize and even small business. We will not be talking about old-wisdom, which you know from the college classes or business school about management and staff involvement into the decision making, brainstorming, etc. ? we'll be ERP specific Microsoft CRM: Data Conversion ? Import from Act! Best Software Act! is very popular CRM for small and mid-size organization. This system attracts business owner by its low price, plus system is very easy to use. However if your business is growing you should reach the moment to implement more advanced CRM solution. Natural question is ? how do we convert the data from Act! to new CRM solution and the mapping of your objects for conversion. You would probably like to avoid operator data entry with potential numerous errors and mistypes. Assuming that you are IT specialist, we'll give you technical side of Act to MS CRM data migration: Dreamweaver vs FrontPage There are two major WYSIWYG(What You See Is What You Get) editors available for beginners. These are: Microsoft FrontPage and Macromedia Dreamweaver. So the question is which one is better? Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes Microsoft Great Plains fits to majority of industries, in the case of Chemicals & Paint you should consider implementation with balanced approach of utilizing existing Great Plains standard module and light customization and reporting with Great Plains Dexterity, MS SQL Server stored procedures, Modifier/VBA and direct .Net publishing from Great Plains Company database. Let's consider industry requirements and their implementation in Microsoft Great Plains: Free Microsoft Word Online Training Tutorial Resources Microsoft Word is one of the most popular office applications that provide many features such as word processing, web publishing and database creation. Tapping into these Word resources, however, is not always easy and straightforward, leaving users stumped and puzzled. Understanding Document Management The term "document management" and "paperless office" is the subject of countless articles and books. Everyone wants to achieve this lofty goal but not everyone understands what the terms really mean. Before you can embark on the journey of achieving total document management, it's important that you have a good basic knowledge of the terms and concepts that go with it. Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization ? Overview In the case when you represent mid-size or mid-size-to-large business, it is not a surprise that you have to do ERP selection and switch to new technologies, doing your own research. If you a trying to stay with Microsoft technologies and try Microsoft Business Solutions products: Microsoft Great Plains, Microsoft Navision, Solomon, Axapta with integration to Microsoft CRM, you should know the history of Great Plains Software and Navision partners over the last 10 years. Two Reasons to Use Timesheet Software This short paper will expand on two key reasons to move to a computerized timesheet system at your company. There are more than two reasons of course, but these will be expanded on at a later date. The two key reasons to be discussed here are Timesheet Efficiency, and Timesheet Automation. Off The Record - Tips For Picking Recording Software Need software to record your voice, streaming audio or musical instruments? There are dozens of great products on the market. Some cost up to five hundred dollars, but here are some of the low cost alternatives you might want to consider. Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant When Great Plains Software introduced the first graphical accounting application for Mac and Windows in the beginning of 1990th it had Great Plains Dexterity customization tool, IDE and programming language. Dexterity design was based on several longevity principles: Graphical platform independence and database platform independence and easy switch from one DB to the other among the most important ones. Dexterity was written as a shell in C programming language, which was "platform independent" and at the same time very efficient in compilation (close to assembler). Since then we saw new tools and options: Five Tips For A Great Software Demo Whether you need to close a sale, gather end-user feedback, show progress to your customer, or simply explain how your product works, sooner or later, you will need to demo your software product. Start Developing Your Own Software Learning how to program software seems like a daunting task fit only for the geeks and nerds who lock themselves away in dark rooms staring at their monitors for days on end as they pour over thick manuals written largely in zeros and ones. Fortunately the reality is that it's not as complicated to make basic applications as people may think. If it were, the majority of nerds wouldn't be doing it because the defining factor of our kind is an inherent laziness. Why do you think we like computers? The heaviest thing we have to lift is a monitor and that's done fairly irregularly and for a very short period of time. Benefits of Integrating Online Chat Software with CRM Customer Relationship Management (CRM) is a strategy and processes used to learn more about customers' needs and behaviors in order to develop stronger relationships with them. CRM applications are traditionally developed as client-server software. The proliferation of the Internet and the Web has fueled the rapid growth of Web-based CRM or online CRM applications. Web CRM systems are widely deployed for Web based call center, contact management, trouble ticket, personal information manager and scheduling. As more and more corporations use chat software to provide quality customer support, many CRM vendors have built chat functionality into new generation of Web-based CRM systems. Beware of The Pirated Software E-Mail Scams! You have gotten those E_Mails buy software at deep discounts. It is very tempting to save 85% to 95% on your favorite Software Titles. Why would you pay $279 for Windows XP when you can pay $49. Most of the times these are Pirated copies of the Software. You can run into huge problems later when you seek upgrades, Support or Security patches. Microsoft Great Plains 8.0 Brazilian Version ? Overview For International Consultant Microsoft Great Plains has substantial mid-market share in the USA plus due to the marketing efforts of former Great Plains Software (now part of Microsoft Business Solutions) in Spanish Speaking South America, South Africa, United Kingdom, Middle East, Poland ? we see strong position of Microsoft Great Plains in these regions (on these markets MBS promotes two mid-market ERP: Great Plains and Navision). How to Upgrade Dexterity Customization ? Tips for IT Manager If you have Microsoft Great Plains and support it for your company and have light or heavy Great Plains customization, written in Dexterity ? you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive to MS SQL/MSDE. Great Plains Dexterity is proprietary programming language/environment, which was created in early 1990-th to provide platform / database / graphical interface independence for Mac and Windows based Great Plains Dynamics.� Today it is legacy and Microsoft Business Solutions is phasing Dexterity out. However Great Plains 7.5 and even 8.0 is Dexterity based application, so you have to deal with it and it's customization. � Good news.� Prior to version 7.0 Great Plains had plans on expanding GP functionality and so was changing tables structure ? forcing Dexterity customization to be analyzed and partially rewritten with each upgrade.� Not any more ? GP structure stays the same ? Microsoft is doing new modules acquisition and unifying it's graphical interface to move all it's ERP packages: Great Plains, Solomon, Navision and Axapta to web-based Microsoft Business Portal. � Still pain.� Dexterity has possibility to customize existing Great Plains screens, so called Alternative Great Plains forms.� This was upgrade problem in the past and it stays now ? there is no way to do it in house (until you are willing to pay for full-time internal developer ? who is usually in the learning curve).� You got to bring in consultant. Recommended approach.� You should have the strategy to migrate Dexterity customization to SQL, Crystal Reports, custom web publishing ? Visual Studio.net and slowly abandon Dexterity customization SQL Stored procedures - performance improvement.� Consider replacing dexterity data manipulation with SQL stored procedures.� Dexterity is cursor-driven language and it is not efficient when processing huge datasets. Crystal Reports.� Take advantage of open and leading technology.� Crystal Reports will eliminate the need in the future for painstaking Dexterity reports upgrade.� Base you Crystal report on the SQL view or stored proc Do direct web publishing off your GP database.� Use Visual Studio ? it is easy to find specialists and have them in staff.� We are in the World when web publishing is very easy. Good luck and if you have issues or concerns ? we are here to help! if you want us to do the job - give us a call 1-866-528-0577! [email protected] Microsoft Great Plains eCommerce ? Stored Procedures Approach Since Version 8.0 Microsoft Business Solutions Great Plains & Great Plains Standard are available on Microsoft SQL Server and MSDE (which is in fact MS SQL with database size limit of 2GB). As eCommerce designer you should be aware of several options and customization tools in your disposition, when you utilize Microsoft Great Plains 8.5 (June 2005), 8.0, 7.5, Great Plains Dynamics/eEnterprise 7.0, 6.0, 5.5 or 5.0 Great Plains Dynamics C/S+. When you have old versions (7.5 and prior) we assume that you are on MS SQL Server 2000/7.0, because if you are on Ctree or Pervasive SQL/Btrieve ? you should use ODBC / RDO connection tools, such as MS Access and its queries or use MS SQL Server Linked Server technique with OPENROWSET statements. So, lets assume that you are on MS SQL Server. You have basically two options eConnect (you should pay for the reg key/license and this is SDK) and custom stored procedures. We'll only consider custom stored procedures way here: |
home | site map |
© 2005 |