|
|
| Software Information |
|
|
|
|
Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights
Microsoft Great Plains is one of the Microsoft Business Solutions family ERP products: Great Plains, Navision, Axapta, Solomon, Small Business Manager. MBS also has Microsoft CRM - Client Relation Management software and Microsoft Retail Management System (Microsoft RMS) Microsoft Great Plains 8.5 is scheduled to be released in the second quarter of 2005. It is usual practice when you here announcements and then you are notified about software release delays. Expect first the version to be released for US market and then you can expect Spanish and Canadian French version. Satellites or third parties are usually released in the following six month period. From our Microsoft Business Solutions insiders we could give you the rumors we have heard ? Version 8.5 seems to be rather a big service pack to version 8.0. Let me give you some historical review. Microsoft Great Plains Dynamics of version 7.0 was merged with Microsoft Great Plains Dynamics and this was basically a foundation of Microsoft Great Plains version 7.5 ? Microsoft Great Plains version 7.5 was the last version for legacy database platforms: Pervasive SQL 2000 and Ctree. Version 8.0 and higher are available on MS SQL Server and MSDE only ? Microsoft bought a product from eOne Solutions (in Australia) called SmartList Builder. This new feature allows users to create their own SmartList without being limited to the available "folders" on the standard SmartList's left panel. We have yet to know more about this but the consultants in Australia are really enthusiastic about this. Upgrade expectations. ? As our experience indicates - Microsoft is working on the ERP application migration (Project Green). This means that MBS is rather concerned on it's ERP applications modules interoperability - consider the strong point of Navision - Manufacturing module should somehow communicate and seamlessly work with GL platform - more likely Great Plains financials - Great Plains systems manager and general ledger. So, and again this is our personal opinion - MBS is not bringing a lot of new ERP functionality into Great plains version 8.5, but rather standardizes it's interface. ? Great Plains and Microsoft Windows. Some of the former bugs were related to Pervasive SQL and Ctree platform and plus Windows 2000 Pro bugs, especially from FRx side. Now Microsoft stakes on Microsoft SQL Server/MSDE only, so you should have more trust in released 8.5 CD. Customization Upgrade and Expectations ? Microsoft Great Plains 8.5 is Microsoft Great Plains Dexterity based application, so your customization should be upgradeable, feel free to call us if you have concerns. ? Microsoft VBA/Modifier - should be available for 8.5 - so if you deploy VBA and have modifications to your GP forms (FORMS.DIC) - you should be OK with version 8.5 ? Crystal Reports - these are usually based on company DB SQL views or stored proc - so assuming that DB side will have minor changes only - Crystal Report upgrade should be easy. Good luck in upgrading 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, serving clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://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
Does your Company have Documentum? Are you lost in the mess of documents that get passed around your company, never knowing what the latest version is and which one you should work on without worrying if someone else has already made the same editions that you are making? Perhaps you have heard of collaboration software solutions such as Documentum to help your company manage its documents that are passed around. Documentum is a very good solution to this problem but is it the only one? In this article you will be presented with some basic information about the differences in collaboration software from Documentum and NextPage. Easy Guide to RAID Recovery What is RAID RECOVERY? Resume Software ? Advantages Revealed The various resume software offered, particularly on the internet, can seem very attractive to job seekers; especially to those not comfortable writing resumes. At first glance resume writing software can provide a number of perks and can appear to be the perfect solution to many job seekers. Microsoft RMS Customization ? PO Items Receiving in Great Plains Microsoft Retail Management (RMS) and Microsoft Great Plains are retail and accounting/ERP solutions coming from the same Microsoft subdivision ? Microsoft Business Solutions. There is often common need to do integration between the two. Despite the fact that both systems come from the same software development company ? the integration is not as simple as it probably should be. Microsoft Great Plains Accounting/ERP Implementation ? Finance Industry Customization Example Microsoft Business Solutions Great Plains is very generic accounting application out of the box and has multiple modules to address specific horizontal or vertical market requirements. At the same time Great Plains, now being moved on MS SQL Server platform allows you to deploy standard tools to customize and fit to these requirements, when you don't need rich custom functionality, just few touches. In this small article let's take a look at finance industry. Microsoft Great Plains Customization: Project Organization ? International Business Example Microsoft Business Solutions Great Plains fits to majority of horizontal niches and clientele in the USA, Canada, Mexico, Latin America, U.K., Brazil, South Africa, Australia, New Zealand and Middle East. If you are project organization: Real Estate, Law Firm, Placement Agency with permanent clients, Construction or Freight Forwarding company ? you probably use or plan to deploy Project management or Project accounting extension for Microsoft Great Plains. If you have your business in one country ? this work relatively simple, however we see clients, involved into international business, when your headquarters is located in the US for example and offices and locations are in Mexico. Let's look at your options: What is Spyware? Are You Being Watched? Find out why Spyware Removal from computers is important and how adware infestations affect your computer, your privacy and your family. Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer �Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market.� At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation market competitor to Oracle, PeopleSoft, SAP, IBM.� This article is brief review of Microsoft Great Plains integration with Microsoft Access.� This is also applicable to Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary - DYNAMICS.DIC and runtime DYNAMICS.EXE) and Great Plains Standard on MSDE� or MS SQL Server. If you are developer who is asked: how do we implement� Great Plains integration/interface� with your MS Access-based� system ? read this and you will have the clues on where to look further. Great Plains Integration Manager - this is rather end-user tool - it is very intuitive, it validates 100% of business logic, brings in/updates master records (accounts, employees, customers, vendors. etc.) brings in transactions into work tables.� The limitation of Integration Manager - it does use GP windows behind the scenes without showing them - so it is relatively slow - you can bring 100 records - but when you are talking about thousands - it is not a good option.� By the way you can program Integration Manager with VBA.� Microsoft Access is ODBC compliant and so you can do direct Integration Manager query to MS Access eConnect ? it is type of Software Development Kit with samples in VB.Net.� Obviously the development environment should be Visual Studio.Net.� eConnect will allow you to integrate master records - such as new customers, vendors, employees, etc., plus you can bring transactions into so called Great Plains work tables (eConnect doesn't allow you to bring open or historical records - you need to post work records in Great Plains, the same limitation applies to Integration Manager above)� eConnect is rather for ongoing integration.� It was initially created for eCommerce application integration to Great Plains. SQL Stored Procedures.� Obviously you have unlimited control and possibilities with SQL queries.� You need to know Great Plains tables structure and data flow.� Launch Great Plains and go to Tools->Resource Description->Tables.� Find the table in the proper series.� If you are looking for the customers ? it should be RM00101 ? customer master file.� If you need historical Sales Order Processing documents ? they are in SOP30200 ? Sales History Header file, etc.�� Do not change existing tables - do not create new fields, etc.� Also you need to realize that each GP table has DEX_ROW_ID - identity column.� Sometimes it is good idea to use inbound/outbound XML in the parameters - then you can deploy web service as a middle party between two systems. Data Transformation Services (DTS) ? Good tool for importing your third party data into staging tables in GP - then you can pull them in using either stored procs of Integration Manager.� You can also deploy this tool for EDI export/import.� You can have DTS working with Linked Server - SQL Server Construction for linking to Microsoft Access Great Plains Dexterity Custom Screens.� Sometimes users prefer to have seamlessly integrated into GP interface custom screens - for parameters settings and initiating integration.� Dexterity is a good option, however remember - it is always better to create new custom screen versus customizing existing one - due to the future upgrade issues.� Also - Dexterity is in phasing our by Microsoft Business Solutions. Modifier/VBA custom buttons on the existing screens - �alternative to Dexterity is you are comfortable with VBA and ADO. SQL Linked Servers ? you can do direct SQL queries to other ODBC compliant platform via SQL Linked Server (including Microsoft Access) - you may need to familiarize yourself with OPENROWSET command in Transact SQL.� This is also good option if you need cross-platform Crystal Report - pulling data from SQL Server and third party databases on the same report. Warning - do not place existing GP tables into Replication! - you will have upgrade issues. Happy integrating!� if you want us to do the job - give us a call 1-866-528-0577! [email protected] SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences... Ok... Where to start? 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 Exchange, MS Outlook, MS SQL Server, Replication, Indexing, Active Directory, Windows 2000/2003 security model, C#, VB.Net, HTML, XML Web Service, XLTP, Javascript to name a few. Recovering Microsoft Great Plains Customization ? Tips for IT Director Remember nice and prosperous Clinton era? When you implemented innovative those old days accounting application ? Great Plains Dynamics. And did a lot of customizations to fit your business requirements precisely. You still remember the names of consultants and programmers who did the job and probably the name of the company ? Great Plains reseller in your business metro. This company more likely doesn't exist in the same form ? either closed the doors or merged and transformed to something else. When you tried to contact former programmers ? they more likely nicely let you know that they do not do this any more ? they got completely different job and profession. Great Plains Software was acquired by Microsoft and not part of Microsoft Business Solutions. In old good days Great Plains Software was taking care of popularizing its customization and growing Great Plains Dexterity programming expertise. Nowadays Microsoft Business Solutions has more concerns on merging all its ERP applications: Great Plains, Solomon, Navision, Axapta and making them run together as a set of modules (project Green). Brand Your Websites URL With a Favicon Have you ever noticed that when you look at your browser favorites menu or the address bar, some entries have their own little icon beside their URL? Fast Car Knoppix Small can be beautiful! Working with Knoppix for the past two years has been a joy. Two terms to describe this distribution, simple, elegance. See Knoppix is one of the many operating systems that runs from the CD, so it doesn't have the hardware conflicts associated with many instruction sets between hardware and software. String in Java Handling character strings in Java is supported through two final classes: String and StringBuffer. The String class implements immutable character strings, which are read-only once the string has been created and initialized, whereas the StringBuffer class implements dynamic character strings. All string literals in Java programs, are implemented as instances of String class. Strings in Java are 16-bit Unicode. Free Software - Powerful Alternatives to Budget-Busting Software When you buy a computer, it most likely comes with Microsoft Windows preinstalled. And when you need a word processor, spreadsheet, or other software, you probably buy it from a computer store. That software is vital. Without it, a computer is just an expensive paperweight. Navision Attain Database access via C/ODBC in ASP.NET Application Navision Software was purchased by Microsoft and now it is supported by Microsoft Business Solutions together with Microsoft Great Plains, Axapta, Solomon, Microsoft Retail Management System and Microsoft CRM. Navision has extremely strong position on mid-size European and US markets, plus it has excellent manufacturing solution. Our goal is to help IT departments to support and tune Navision with in-house expertise and skills. The topic of this article is Navision database access from ASP.NET application via C/ODBC interface. Our goal will be ASPX page accessing Navision Customers. Basic Tips and tricks for Windows XP Running Applications in Compatibility Mode With Windows XP, you can run programs as if though they were being run under a different operating system. (This is known as "emulation".) Simply right-click a shortcut, select "Properties" and then check "Run in compatibility mode" and select the operating system you wish to make the program believe it is being run under. This fools or tricks the program into thinking you are really using a previous version of Windows, such as NT, 2000, 98, or 95. This is especially useful for certain games that won't run properly. Be careful *not* to use this with certain system utilities, such as antivirus, defrag, registry, and disk tool applications. Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist Microsoft Great Plains is main Microsoft Business Solutions product, targeted to mid-size companies. Currently Microsoft is in progress of transforming several ERP products it has: Microsoft Great Plains, Solomon and Navision into several business suites - Microsoft Financial, Microsoft HR, Microsoft Manufacturing, Microsoft Logistics. IBM Lotus Domino or Microsoft Exchange? IBM Lotus Domino or Microsoft Exchange? Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization Microsoft CRM is winning market share step-by-step from such the traditional CRM providers as Siebel, Saleslogix. In this article we'll show Microsoft Business Solutions CRM potential in the VoIP direction. Nowadays VOIP-based technologies and Instant Messaging Systems are getting wider and wider spread. Each work desk or each personal computer has one or another instrument of information exchange, belonging to the VOIP or instant messaging systems. Currently the mostly presented information exchange systems are:
|
| home | site map |
| © 2005 |