| |
| |
|
Software Information |
|
|
|
Upgrading Great Plains Dexterity Customization - switching to new technologies: SQL, Crystal, eConne
1. Replace Dexterity cursor with SQL Stored ProcedureDexterity 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. Clear 'SOP Number' of table SOP_HDR_WORK. Range start table SOP_HDR_WORK. Get first table SOP_HDR_WORK. While errEOF do If 'Salesperson ID' of table SOP_HDR_WORK = "ERIC" then Edit table SOP_HDR_WORK. Set 'Salesperson ID' of table SOP_HDR_WORK to "BILL". Save table SOP_HDR_WORK. End if. Get next table SOP_HDR_WORK. End while.
With the following SQL code
Update SOP10100 set SLPRSNID="BILL" where SLPRSNID="ERIC"
Bringing new data into a table in Dexterity is based on change/edit table clauses, in SQL they are equivalent (by performance) to inserting one record at the time. When having long cycle of change/edit table in Dexterity, consider replacement by SQL stored procedure with Insert Into clause.
2. Use Crystal Reports, call them from via VBA in Modified formThe easy way to call Crystal Report from your VBA code from your modified form: Const RPT = "D:ClientsTheClientInvoice Status.rpt" Public crwApplication As CRPEAuto.Application Public crwReport As CRPEAuto.Report Private Sub Print_BeforeUserChanged(KeepFocus As Boolean, CancelLogic As Boolean) If SalesTransactionInquiryZoo.Type = "Invoice" Then If crwApplication Is Nothing Then Set crwApplication = CreateObject("Crystal.CRPE.Application") End If Set crwReport = crwApplication.OpenReport(RPT) crwReport.ParameterFields(1).SetCurrentValue (DocumentNo) crwReport.Preview End If 3. Use Direct .Net Web Publishing from Great Plains Database The easiest and safest way is to use eConnect - SDK with VB samples, created for eCommerce programmers and web designers to call the functionality in Microsoft Great Plains. If your company can not afford eConnect - create your own set of stored procedures to address Great Plains database and go ahead with Visual Studio.Net to do the web publishing. Happy upgrading and customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Texas, New York, Georgia, Arizona, Minnesota, Washington, Colorado and Florida and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
MORE RESOURCES:
Software - Google News |
|
|
|
RELATED ARTICLES
Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino - overview Microsoft Business Solutions Great Plains has substantial market share among horizontal and vertical clientele in the USA, Canada (including French version for Quebec/Montreal), UK, Australia, New Zealand, Spanish speaking Latin and Central America, South Africa and Middle East. Nowadays ERP can not stay as it is off-the-shelf product - it requires integration with Legacy or newly implemented systems, such as CRM, Retail Management applications, custom in-house made business systems (transportation/cargo tracking, etc). 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 on active service contract: enhancement program. Minimal maintenance plan gives you free new software version (however upgrade itself, if it is done by your MBS partner is not free). Enterprise Resource Planning Overview ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief history of ERP, Why is it necessary, Market Leaders and the future of ERP.What is ERP?Enterprise Resource Planning or ERP is an industry term for integrated, multi-module application software packages that are designed to serve and support multiple business functions. Outlook... Not Just for Email! Using Your Outlook Calendar Microsoft Outlook is one of the most widely used software programs for email, but if you're only using it for email, you're missing out on a great productivity tool! This month's column looks at a few ways you can use the Outlook calendar to make scheduling easier.* Add public holidays to your calendar automatically. Google Brings the Earth to Your Desktop Google Inc. has launched a new software package that allows you to see satellite images on your desktop. Exactly What Does FTP Stand for and What Can it do for Me? FTP stands for "file transfer protocol". FTP is basically a way of sending files over the Internet. Microsoft Great Plains Project Accounting - Overview For IT Director/Controller Microsoft Business Solutions is now in process of creating so called Microsoft Suites: Microsoft Financials, Microsoft Logistics, Microsoft Manufacturing, Microsoft Professional Services - this last one will be based on Solomon Project module. The long story of Great Plains Software Project Accounting - it was originally created by MatchData, which was bought by Great Plains in late 1990-th and renamed into Great Plains Project Accounting. Online PowerPoint Presentation - Convert PowerPoint to Flash Although we don't know whether Microsoft ever envisioned such a big market about PowerPoint on its first release. Today this software is impacting profoundly on education and corporation's activities in the way that nobody could ignore. Microsoft CRM or Siebel Siebel is traditional CRM market leader, however and mostly due to recession 200-2003, Siebel lost sizable portion of CRM market to new tiger, such as Microsoft CRM. Microsoft CRM s recent (2001) CRM answer from Microsoft and attempt top get market share from traditional vendors: Siebel, Oracle, Onyx. OLAP, An Alternative Technology Over Spreadsheets Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average" companies are not confident that their forecasts and reports are accurate and reliable'In a recent study, 81% of FD's cited that their highest priority is the accuracy of revenue and earnings forecasts while 63% complained of inadequate budgeting and forecasting systems .The modern FD is coming under increasing pressure from all sides to produce more robust, meaningful and accurate financial information. Microsoft Great Plains: Large Scale Implementation Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM are coming up to satisfy ERP needs for large corporation, including multinationals. In this article we will be describing Microsoft Great Plains as the MRP platform, fitting to multiple industries and business niches: aerospace, defense, textile, pharmaceutical, healthcare, constructions, mining, services, distributions & logistics, wholesale & retail, public sector, chemicals, oil & gas, finance, brokerage, etc. 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". Great Plains DOS Support - Notes for Consultant Great Plains Accounting, accounting package for mid-size and small companies was in its peak of popularity back in earlier 1990th. It first had DOS interface, later on migrated to classic Windows version (remember earlier event driven Windows and its strange and at the same time revolutionary programming model - guys who remember Borland C++ and Microsoft C++). Basic Steps To Optimize Your Internet Security After seeing many people complain about their weak Internet security I decided to write down some things that will help you for your Internet security.First, here are some tips to make windows safer :For basic security and update patches install Service Pack 2 for Windows XP or Service Pack 4 for Windows 2000. Lotus Domino Implementation and Development: Infrastructure - Present and Future Domino server is a buffer between the operation system and the application. On the other hand Domino server - consists of the services which support development processing and executing of dynamic, secure applications for Internet, Intranet, or Extranet. Rapid Application Development - Is it Really a Need of Today? Rapid Application Development (RAD) is a software development methodology. In this competitive world, software product delivery time should be as little as it can be. Free Software: How Not To Get More Than You Bargained For! I completed an experiment recently. I wanted to find out exactly what software I could get free on the Internet. 10 Steps To Secure And Manage Your Passwords Passwords protect your most sensitive personal, financial and business information. They are the key to accessing membership, financial, and other web sites that you are a member of. 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. DVD Burning Tips CD and DVD replication is a process that works by creating discs from scratch. Not to be confused with duplication (the act of burning information onto readymade, commercially-available blank CD-Rs and DVD-Rs), replication relies on the use of molds to produce actual discs that already contain digital data.
|
|
Home | Site Map | 101InfoLinks.com | Best Book Shop | Sports Fans ONLY 
.
|
| © 2007 |
