Upgrading great plains agility customization ? switching to new technologies: sql, crystal, econne - software
1. Change Ability indicator with SQL Stored Procedure
Dexterity was considered as multiplatform knowledge (primarily Btrieve, Ctree, SQL Server, potentially Oracle). Adroitness data retrieving apparatus is based on Range start, Range End, Get First and Get Next clauses. It is in fact similar, but a barely bit slower to cursors in Deal with SQL. Long ranges in Ability are good candidates for substitute by SQL stored procedures with bring up to date clause.
For example, believe to interchange next Agility 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.
Get next table SOP_HDR_WORK.
With the subsequent SQL code
Update SOP10100 set SLPRSNID="BILL" where SLPRSNID="ERIC"
Bringing new data into a table in Ability is based on change/edit table clauses, in SQL they are alike (by performance) to inserting one best at the time.
When having long cycle of change/edit table in Dexterity, bear in mind proxy by SQL stored formula with Addition Into clause.
2. Use Gemstone Reports, call them from via VBA in Custom-made form
The easy way to call Gemstone Account from your VBA code from your bespoke 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 Nobody Then
Set crwApplication = CreateObject("Crystal. CRPE. Application")
Set crwReport = crwApplication. OpenReport(RPT)
crwReport. ParameterFields(1). SetCurrentValue (DocumentNo)
3. Use Address . Net Web Publishing from Great Plains Database
The easiest and safest way is to use eConnect - SDK with VB samples, formed for eCommerce programmers and web designers to call the functionality in Microsoft Great Plains. If your ballet company can not give eConnect - construct your own set of stored procedures to adopt Great Plains folder 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 Expertise Detective in Alba Spectrum Technologies - USA all over the country 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 manifold states and globally (www. albaspectrum. com), he is Dexterity, SQL, C#. Net, Gem Gossip and Microsoft CRM SDK developer.
Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino - overview
Microsoft Affair Solutions Great Plains has ample promote share among horizontal and vertical clientele in the USA, Canada (including French edition for Quebec/Montreal), UK, Australia, New Zealand, Spanish dialogue Latin and Crucial America, South Africa and Central East. In our time ERP can not stay as it is off-the-shelf effect - it requires integration with Bequest or newly implemented systems, such as CRM, Retail Management applications, custom in-house made big business systems (transportation/cargo tracking, etc).
Microsoft Great Plains: In receipt of New Users Licenses - Twelve-monthly Benefit Plan FAQ
Microsoft Commerce Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM command offered consumer to be on energetic ceremony contract: enhancement program. Negligible maintenance plan gives you free new software account (however upgrade itself, if it is done by your MBS partner is not free).
Enterprise Source Development Overview
ERP (Enterprise Store Planning) Overview covers What is ERP, Brief account of ERP, Why is it necessary, Advertise Leaders and the expectations of ERP.What is ERP?Enterprise Store Preparation or ERP is an conscientiousness term for integrated, multi-module claim software letters that are considered to serve and assistance compound big business functions.
Outlook... Not Just for Email! Using Your Outlook Calendar
Microsoft Outlook is one of the most far and wide used software programs for email, but if you're only using it for email, you're gone astray out on a great productivity tool! This month's discourse looks at a few ways you can use the Outlook calendar to make scheduling easier.* Add broadcast holidays to your calendar automatically.
Google Brings the Earth to Your Desktop
Google Inc. has launched a new software embalm that allows you to see satellite imagery on your desktop.
Exactly What Does FTP Stand for and What Can it do for Me?
FTP stands for "file assigning protocol". FTP is essentially a way of carriage files over the Internet.
Microsoft Great Plains Assignment Accounting - Overview For IT Director/Controller
Microsoft Affair Solutions is now in course of creating so called Microsoft Suites: Microsoft Financials, Microsoft Logistics, Microsoft Manufacturing, Microsoft Certified Armed forces - this last one will be based on Solomon Development module. The long story of Great Plains Software Assignment Accounting - it was formerly bent by MatchData, which was bought by Great Plains in late 1990-th and renamed into Great Plains Cast Accounting.
Online PowerPoint Presentation - Alter PowerPoint to Flash
Although we don't know whether Microsoft ever envisioned such a big bazaar about PowerPoint on its first release. Today this software is impacting greatly on culture and corporation's actions in the way that no one could ignore.
Microsoft CRM or Siebel
Siebel is conventional CRM promote leader, but and customarily due to decline 200-2003, Siebel lost extensive portion of CRM advertise to new tiger, such as Microsoft CRM. Microsoft CRM s current (2001) CRM fulfil from Microsoft and crack top get advertise share from customary vendors: Siebel, Oracle, Onyx.
OLAP, An Another Expertise Over Spreadsheets
Are Spreadsheets Robbing your Endeavor of Competitive Advantage?'90% of "average" companies are not certain that their forecasts and hearsay are precise and reliable'In a current study, 81% of FD's cited that their chief priority is the accurateness of revenue and dividend forecasts while 63% complained of hopeless budgeting and forecasting systems .The contemporary FD is advent under ever-increasing anxiety from all sides to bring into being more robust, eloquent and correct pecuniary information.
Microsoft Great Plains: Large Scale Implementation
Microsoft Affair Solutions Great Plains, Navision, Axapta, Solomon and CRM are advent up to convince ERP needs for large corporation, counting multinationals. In this condition we will be recitation Microsoft Great Plains as the MRP platform, apt to many industries and big business niches: aerospace, defense, textile, pharmaceutical, healthcare, constructions, mining, services, distributions & logistics, blanket & retail, civic 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 although they were being run under a atypical working system. (This is known as "emulation".
Great Plains DOS Aid - Notes for Consultant
Great Plains Accounting, accounting box for mid-size and small companies was in its peak of popularity back in beforehand 1990th. It first had DOS interface, later on migrated to classic Windows edition (remember at an earlier time event determined Windows and its astonishing and at the same time revolutionary indoctrination model - guys who bear in mind Borland C++ and Microsoft C++).
Basic Steps To Optimize Your Internet Security
After bearing in mind many colonize grumble about their weak Internet guarantee I absolute to write down some equipment that will help you for your Internet security.First, here are some tips to make windows safer :For basic confidence and inform patches ensconce Assistance Pack 2 for Windows XP or Assistance Pack 4 for Windows 2000.
Lotus Domino Implementation and Development: Infrastructure - Acquaint with and Future
Domino ma?tre d' is a bumper among the act classification and the application. On the other hand Domino head waiter - consists of the army which aid change doling out and executing of dynamic, confident applications for Internet, Intranet, or Extranet.
Rapid Attention Advancement - Is it Actually a Need of Today?
Rapid Concentration Change (RAD) is a software advancement methodology. In this competitive world, software artifact conveyance time must be as barely as it can be.
Free Software: How Not To Get More Than You Bargained For!
I concluded an carry out trial recently. I sought to find out exactly what software I could get free on the Internet.
10 Steps To Assured And Cope Your Passwords
Passwords keep your most easily hurt personal, fiscal and affair information. They are the key to accessing membership, financial, and other web sites that you are a associate of.
Microsoft Great Plains Integration with Microsoft Admission - Overview for Developer
Microsoft Affair Solutions stakes on Microsoft Great Plains as main Accounting/ERP appliance for US market. At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation bazaar competitor to Oracle, PeopleSoft, SAP, IBM.
DVD Burning Tips
CD and DVD imitation is a administer that works by creating discs from scratch. Not to be befuddled with duplication (the act of burning in sequence onto readymade, commercially-available blank CD-Rs and DVD-Rs), imitation relies on the use of molds to bring into being definite discs that by now control digital data.
|home | site map|
|goldenarticles.net © 2018|