|
|
| www.1001TopWords.com |
|
|
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 system 1. 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 clones with Microsoft Windows, Apple Macintosh with Mac OS or something like Sun SPARC. This is why graphical multiplatform idea was popular among software developers. Also there was a myth about C/C++ languages, working similar on all computers. 2. Database platform independence - there was the need for future surviving. Competition on the database market was also very tough: Oracle, Ingress, Sybase, DB2, Ctree/Faircom, Btrieve (Pervasive SQL 2000 later on) In order to realize these two principles Great Plains Software created its own development environment and programming language - Great Plains Dexterity (DYNAMICS.DIC, REPORTS.DIC, FORMS.DIC are Dexterity dictionaries). At this point customization standards were clarified: 1. If you need seamless integration with Great Plains Dynamics, working in the realm of Dynamics security and database independent data access/modification - you do it in Great Plains Dexterity. 2. If your customization should be light then you appeal to the customization tools coming with your computer platform. Very soon Microsoft Windows took the market, so VBA was the way to go. 3. As soon as Microsoft Windows kicked Mac OS from the office computers market, standard third party Microsoft-friendly tools were recommended - good example is Crystal Reports 4. When Microsoft SQL Server won the database market - Great Plains Software began migration campaign from Ctree/Faircom, Btrieve/Pervasive SQL to MS SQL Server 7.0 and later 2000 Finally, when Microsoft bought Great Plains Software, Microsoft Business Solutions turned to be more concerned about its ERP products migration and transformation into so-called suites: Microsoft Financial, Microsoft Logistics, Microsoft Manufacturing, Microsoft Human Resources and pretty much abandoned the promotion of traditional tools: Great Plains Dexterity, VBA, ReportWriter, Continuum, Integration Manager. As a temporary patch to enable .Net programming it released such tools as eConnect. Right now (2004-2005) we are in the transformation phase when old tools, such as Dexterity are still playing important role, but if you are thinking about customization, you probably better consider SQL Server scripts/views/stored procs, if you have customization budget - make a research on eConnect. Try to make as much web publishing in Visual Studio.Net as possible. Use Crystal Reports design and our recommendation is to base Crystal Report on SQL View or Stored Procedure. Good luck with installation, implementation, customization, development, upgrade 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! help@albaspectrum.com About The Author 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, Washington, Minnesota, Colorado, 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: andrewk@albaspectrum.com; akarasev@albaspectrum.com
|
|
|
|
RELATED ARTICLES
Microsoft Great Plains as ERP and Microsoft CRM as CRM If you have Microsoft Great Plains and support it for your company then you need to know some technical details about Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customization, additional complexity comes with migration from ctree/Pervasive to MS SQL/MSDE. 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. The XP Firewall Isnt Enough Every computer that connects to the internet has an IP address. This is like a sort of phone number, and is issued either to an individual computer or to a "gateway" that connects a private network to the 'net. Great Plains Customization Upgrade? Overview For CIO/IT Director Around the same time Microsoft made its move with .Net introduction and tried to gain portion of cheaper databases market: Pervasive SQL/Btrieve, Ctree/Faircom - and launched free MSDE database program. General direction for all its accounting systems was chosen - Microsoft announced future releases of so called Microsoft suites: Microsoft Financial, Microsoft HR, Microsoft Logistics, Microsoft Manufacturing to name a few. However Microsoft did not announce which product (Great Plains, Solomon or Navision) will become the base or will be transformed into each specific suite. Al these suites will be integrated into web-based Microsoft Business Portal Call Alert Notifications - Free Answering Machine Software for PCs If you're online using a dialup Internet connection, you'll probably want to download one of the free call alert software applications like Callwave or AOL Call Alert that can answer, record, and forward incoming calls to your home, office or cell phone. In fact, if you run a small business, Call Wave also offers a dedicated business fax service too. These software offerings are fully reviewed online at http://www.callalertreviews.com. Crystal Reports for Microsoft Great Plains Microsoft Business Solutions ? Great Plains is designed to meet and extend the needs of small and mid-size organizations for its business success. Its comprehensive accounting and business management applications also provide businesses with capabilities to customize various modules of the Great Plains software to fit to their specific needs. Because of these potentials, Great Plains has been targeted to the whole spectrum of both horizontal and vertical clientele. The Hidden Power of Online Manual Writing software manuals is boring, isn't it? We often think: "My software is easy to use. The user interface is intuitive. Why should I waste so much time for writing the document which nobody reads anyway?" Sometimes it's true ? I've never read the WinZip or Internet Explorer manuals ? everything seems clear without explanations. Nevertheless, even if your manual doesn't help to your software users, it may help to you. Publish your manual online and turn its hidden power into the real benefits for your business. Online Manual Makes Your Web Site Visible User manual is a huge bunch of words, the highly targeted words, which are specific for your software market. For instance, if you develop a database management system, its user guide will certainly contain such words as "database", "query", "transaction", "table", "record", and etc. On the other hand, people use these words in their queries when they are looking for a database management solution on the Google, Yahoo, or other search engine. Let the interested people to find your web site and your product. Upload your manual on your web server and make it available for indexing by search engine spiders. This area specific content will make your web site and your software more visible to potential customers. Making the user guide available online will increase your web site rank in relevant search results and will bring highly targeted traffic to web your site. Let the manual to work not only for your users, but for you as well.Online Manual Saves Your Time A picture worth a hundred words. Those who are engaged in user support know this for sure. When replying to user concerns, very often we have to write sentences like this "Open the Document settings dialog. Choose the External modules tab. Select the 'ABC Spell Checker' in the module list. Enter your registration key and verification code in the corresponding text fields which will appear at the bottom of the window. Then, press Activate". If your application is simple the user will likely understand you right and will do everything as you have explained. However, if your application is a complex system with lots of setting windows which behave differently in various modes, the user may be puzzled which window and which fields do you mean. In this case you risk getting into a long conversation by repeatedly explaining the same things again and again. The screenshot could be a very helpful illustration of your explanations. You may run your application, go to the certain window, open that tab page, activate the corresponding item in the list. Then make the screenshot of the window by using Alt+PrtSc key combination or another screen capture tool, save the picture in a file, and finally attach it to your message. Sometimes it's also necessary to add callouts, annotations and other enlightenments to the screenshot picture. Thus, you have to launch your image editor and to manually draw all the elements required. As you see, it may takes up to a half hour to reply to a single message only. And how many messages are yet in the queue? Having the screenshots prepared is a good approach which may save your time. But having screenshots already prepared together with callouts, explanations, and annotations is a great approach which will save you much more time. Most likely, you have all that stuff prepared in your software manual but it's not very polite to reply to the user: "Read that fantastic manual". User may have no idea where the manual is on the PC and on what page is the looked-for solution located. On the other hand, you may also have no time to manually cut particular pages with screenshots and related instructions from the manual and to attach them to each support message. The solution is easy. Put your manual on your web site in the form of HTML pages. Make all the pictures, screenshots with callouts, descriptions, and instructions accessible for every user. When you are processing another support request, simply insert an URL link to the appropriate page of your online manual and add just a few clarification words ? more words and pictures are already on that page. You will save much time and nerves because you will be sure that the user is looking at the same thing which you are describing. At the same time, the user will get a fast solution which is supported by clear pictures and neat instructions.Online Manual Makes Your Products Trustworthy Besides the users get the faster and more helpful support, they also see that you did this tedious job ? writing the handy and well structured manual with great screenshots and clear explanations. They know that this job is boring and developers don't like to do it. Therefore, if you did it and if you did it perfectly, it means that you respect your customers, not only their money. Good manual means that you consider your business and product seriously yourself. This helps your business to look more credible and serious. So, make your manual available online and prove your respect to your existing and prospective users. Make them trusting in you and in your product before they even download a demo copy of it.Online Manual Brings SalesAs we see, the software manual which is a part of your web site generates a targeted traffic. The people may easily find your product because online help makes your web site more visible in relevant search results on the search engines. Those new visitors get more loyal when they see a well done help system. Also, if a prospect experiences difficulties with your software and asks for technical support, you may easily resolve the issue by referring the user to a certain page of your online help. With just a one click the user will see screenshots and explanations which will help them to settle the case. So, you have a motivated and targeted visitor, who feels loyal to your company and products, and whom you can easily help in case of a technical problem. The probability of such visitor ordering a license is several times higher than of the average one. Screenshots Vista Windows FeaturesAdditionally, Vista will include many other new features. The Dirt on Screensavers Remember back in the days where screensavers were the coolest thing at the office? You could stare at your co-worker's "fish in the ocean" screensaver at the cubicle next door for hours and actually have a full afternoon of conversation about that one screensaver. Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few. Reduce Pop-ups and Annoying Ads There is many things more frustrating than surfing a website only to have your screen suddenly full of pop-up advertising or a cascade of new windows opening. There are so many intrusive kinds of advertising on websites that there must be a way to deal with them. Luckily for us there is a few programs out there that will help to reduce the amount of advertising that happens while you surf. 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. 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. SSH (SCP) Send Files from Windows to Your Linux Box Not all of us have the luxury of working both at home and at work on a UNIX based system. However that doesn't mean you can't transfer files safely and securely between the two systems. Huddle Up; Groupware on Three It could just be me, but my experiences with document collaboration remind me of a football game. It sounds crazy, I know, but working with a group and sending emails off to other members of the group caries with it that familiar uneasy sensation of Thanksgiving Day football games, where I often play quarterback and just as often wonder whether members of my family will catch the pass, and if they do, what they will do with the ball. Using groupware in document collaboration is similar to having a game plan that separates the "Turkey Bowl" family football team from the real competitors. ERP Software Financing: the Future? ? Overview for Company Owner In our case ? we serve Microsoft Business Solutions ERP and CRM products: Microsoft Great Plains, Microsoft CRM, Navision, Microsoft RMS, as well as we do customization and integration to these products. We would like to share with you our experience with financing through Microsoft Financial Corporation, the entity handling software financing for Great Plains, CRM, Solomon, Navision & Axapta. Microsoft Great Plains Reporting ? Overview for Developer Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. There are several reporting tools available and you definitely need to know which one to use for different types of reports.If you are developer who is asked: how do we create report for Microsoft Great Plains ? read this and you will have the clues on where to look further.Great Plains Report Writer (ReportWriter) ? this is built-in reporting tool. All the original report in Great Plains are written in ReportWriter. ReportWriter itself is Dexterity module. You should use this tool if you would like to modify existing Great Plains reports, such as Blank Invoice Form - here you can place your company logo, change the positioning, fonts, colors, etc. ReportWriter will allow you also do new reports - simple option if you want to export all the records from one Great Plains table - use it. New report, however doesn't have interface where you would enter parameters - so it is not useful for real custom reports. Another limitation of ReportWriter - you can not do cross-modules report - when you need sales and purchasing info on the same report for example. FRx. This is excellent tool when deal with financial reporting - it works on the General Ledger level (Balance sheet, P&L, Cash Flow Statement, etc.). It also allows you to do multiple companies consolidation - when you do consolidated Balance Sheet (with inter-companies transactions elimination). Smart List - Export to Excel ? this is nice feature in Great Plains - you could create a list with simple criteria and then export it to Excel. Crystal Reports. It gives you unlimited functionality. Obviously flexibility requires you to know Great Plains table structure: 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. Create ODBC connection to GP Company database. Use the same technique as when you create standard ODBC connection for GP workstation ? but change default database to targeted company database. Create SQL Query to probe the data ? we always recommend tuning your query and see that you are getting adequate results ? in any case ? Crystal Report is just a nice tool to show the results of your query. Direct Web Publishing off Great Plains databases ? yes - it is easy now with Visual Studio.Net and you can hire good programmers. This is good - Microsoft Business Solutions products: Great Plains, Solomon, Navision and Axapta will be integrated into so called Microsoft Business Portal - which will have web interface - you can get the idea if you look at Microsoft CRM web client - so direct web publishing is good taste. SQL Queries. If you have SQL background - this is great field for you. You know - with properly formatted SQL query you can realize simple EDI export/import for the integration with legacy systems.Happy designing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com 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.ApplicationPublic crwReport As CRPEAuto.ReportPrivate Sub Print_BeforeUserChanged(KeepFocus As Boolean, CancelLogic As Boolean)If SalesTransactionInquiryZoo.Type = "Invoice" ThenIf crwApplication Is Nothing Then Set crwApplication = CreateObject("Crystal.CRPE.Application")End IfSet crwReport = crwApplication.OpenReport(RPT)crwReport.ParameterFields(1).SetCurrentValue (DocumentNo)crwReport.PreviewEnd If3. Use Direct .Net Web Publishing from Great Plains DatabaseThe 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 What is Preventive Maintenance Software? Preventive Maintenance (PM) is defined as scheduled work done on a system to identify and fix any occurring issues before they become problems. The concept of preventive maintenance applies to many different industries. PM is often done on buildings, various types of machines, computers, institutions, as well as personal assets, including finances and property. Cisco Certification: Introduction To ISDN, Part V The major reason I recommend getting your hands on real Cisco equipment rather than a simulator is that real Cisco routers give you the chance to practice and learn show and debug commands.
|
| © Athifea Distribution LLC - 2013 |
