Software Information

Troubleshoot Windows with Task Manager

Task Manager is a Windows system utility that displays thetasks or processes currently running on your computer. Toopen Task Manager, press Ctrl+Alt+Del. The Applcations tablists the applications currently running on your computer.A single application may actually consist of several runningprocesses, and many programs that run in the background arenot listed (you can see icons for some of these programs inthe System Tray).

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customizations, ctree/Pervasive migration to MS SQL/MSDE. As of right now it is reasonable to upgrade to Microsoft Great Plains 8.0Is upgrade required? Not actually, but you have to consider these factors ?Technical Support discontinuation - the old version may not be supported - currently if you are on version 6.0 - support is already discontinued. You can not have Microsoft Business Solutions help you, but obviously you have MBS partners who can still help you. If you are on Ctree or Pervasive SQL, then your support expires December, 31 2004. ?Tax Updates/Magnetic media expiration - if you have US Payroll module and depend on it with W2 and other forms - you must stay with the version, which is supported and has tax updates. If you are on Ctree or Pervasive SQL - then you will not have tax updates for these platforms at the end of 2004 and your W2s maybe inaccurate. If you have a lot of employees - you may have issues with government.?Following the Technology and Microsoft rules - Microsoft wants you to be on the newest platform and provides you the best support when you follow this rule?If you do have heavy customization - we recommend you to skip one version, for example if you are on version 7.5 - do not upgrade to 8.0 and wait for the next versionWhat is upgrade in the language of technology? Upgrade has server and client sides. ?Server side - upgrade converts tables from old format to the new one. In general words - Microsoft Business Solutions developers may change table structure, append additional fields to add new functionality, things like that. Upgrade copies the table with changes to temporary table, then drops original table, recreates it with new structure and copies all the data from temp table to the newly created one. ?Workstation side - workstation is written in Great Plains Dexterity and has Dynamics.exe - engine and DYNAMICS.DIC - dictionary. These two plus all the additional files will be replaced with the new ones. Other dictionaries, such us REPORTS.DIC and FORMS.DIC should be also upgraded and upgrade will try to deal with them automatically. In some cases modified reports (in REPORTS.DIC) could not be upgraded and need to be recreated in the new version. What is customization upgrade? You should consider different types of customizations: Dexterity, VBA/Modifier, SQL, ReportWriter, Crystal Reports?Dexterity Customization - being very short - Dexterity may have so called Custom Forms - these do not need upgrade - they should work as is. Then Dexterity may alter existing Great Plains forms (so-called Alternate Great Plains forms) - in this case Dexterity customization should be redone for these forms/screens. Plus additional consideration should be given to Dexterity triggers, shadow tables, etc. ?VBA/Modifier customization - Modifier allows you to modify existing Great Plains windows - it creates so called modified Great Plains windows, stored in FORMS.DIC. Usually modification is placing new buttons or fields, which in turn will be given VBA scripts (stored in DYNAMICS.VBA). VBA scripts may call something nice, like Crystal Report, or have some data access logic. Usually the old version of DYNAMICS.VBA workds with the new version. You may need to rearrange buttons on the modified form.?SQL - you may have some stored procs for data integration, EDI or the like - if the addressed tables will be changed in the new version then you need to analyze your SQL code. The good news is - Microsoft Business Solution doesn't make a lot of changes since version 7.0, because Microsoft is now trying to merge the products it owns: Great Plains, Solomon, Navision and Axapta - and so has different priorities?ReportWriter - MBS doesn't change tables, but it keeps changing Dexterity formulas used in ReportWriter original reports - this is the problem in so-called Modified Reports upgrade - usually you have these reports modified: SOP Blank Invoice form, SOP Blank Picking ticket, etc. If report can not be upgraded - it should be redone in the new version with some exceptions.?Crystal Reports - the nice thing about Crystal Report - id doesn't need to be upgraded (if the fields in the tables exist in the new version - which is usually true statement)What is upgrade for third-party modules? Your Great Plains may have so-called third party modules: Mekorma, Kampdata, Horyzon, Wennsoft, Avalara, Truepay, Trinity, Intellisol to name a fewThird party modules may have their own utility for upgrade. You just need to know that your third-party is ready for the new Great Plains version - if not - you just wait and stay on the old version.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 dataDo 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?You have Dexterity customization?You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools?You have a lot or ReportWriter Modified Great Plains Reports?You have old version of Great Plains: Dynamics or eEnterprise 6.0 or prior - in this case you can not appeal to Microsoft Technical Support - it is discontinued ?Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems?You don't have support - in this case you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade Good luck with 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!

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I?m not really into serious discussions on the email, answers to questions can often take a few days to arrive because people are so busy these days. I?ve just been ?hooked up? into Messenger and it?s really a different kind of communication, quick, simplistic and even humorous with the capability to express your feelings with ?emotion? cartoons. With Messenger you can communicate with a group of close friends or business partners instantly whenever they are at their computer. When a message is received you are informed instantly on your desktop, you don?t have to be at an email site. A little box appears flashing the name of the sender, you read the message and send a reply when you?ve got a second free. There?s a contact list and when you go on-line, it automatically tells you who of your connections are on and off-line at that moment. If someone goes on-line after you?ve already been at your computer, a small box appears on your screen to tell you who are now also instantly message able. It?s like the spontaneity of a telephone call but you don?t even have to dial any numbers! Just log in your password and you?re connected. The huge array of smiley faces and other ?emotional? icons add another dimension to the conversations. Some of the smiley faces actually move (sticking their tongues out etc.) and there are many other symbols to express the moment. E.g.: Show a little sun when it?s sunny in your neighborhood, flash a wilted rose when your love life isn?t going to well, put up a black sheep when you?re feeling disconnected from society. How about expressing your dream of a holiday by flashing up the tropical island icon when you?re stuck in dreary office working hard on a cloudy day. They say a picture speaks a thousand words? Well I certainly don?t work for Microsoft but I guess Bill Gates and his buddies have made a few bucks because they?ve had a couple of good ideas. They?re helping the world with their knowledge, and I reckon their MSN Messenger is another step forward in bringing the Earth together into one world. Besides the normal email format you can also have web cam and audio conversations, as well as sending files and photos instantly. It?s as sweet as that first time you kissed your honey bunny, well maybe not that sweet.

Reduce TCO: The Java Database Way

TCO (Total Cost Ownership) is the buzzword in today?s business world. This metric helps enterprise managers assess direct and indirect costs and benefits derived from their investment on IT components and services. A vital component of overall TCO is database management. All information-centric applications need databases for data storage. Also, the storage demands of small and mid-sized companies are growing rapidly, as more emphasis is given on data backup and long-term archival of data disaster recovery. Embedded databases have arrived in this scenario as a major cost-cutting tool. They help organizations in managing the growing storage requirements by providing a cost-effective and reliable solution for data backup, file storage and archiving, thereby assuring a lower cost of ownership for small to medium sized business organizations. The remainder of this article will focus on the database server that I am most familiar with (Daffodil DB) and how it helps in the reduction of TCO. Though the example has some nuances specific to Daffodil DB, I am sure that readers will be able to extrapolate the theme to better understand the role of a database in TCO reduction. Let?s begin with Development and Deployment Costs. Gone are the days when applications had to be tested extensively for all underlying platforms. Now, one can shrink the cost and time required to develop and setup solutions on multiple platforms by using a Java database. A separate deployment for different platform implementations of a large application is a major expense that an enterprise can do without. Administration Costs are a major concern for many-a-company. Logically, database administration costs are a significant component of TCO. When embedded with an application, a compact Java database can be made practically invisible to the user, since it (the database) requires no administration and runs on the same Java virtual machine (JVM) as does the application. Its simple performance tuning process helps in optimizing database performance and vastly reduces database administration costs. Now let?s move on to Compatibility Cost. Java databases, being platform independent, are compatible with all operating systems and application servers. This feature helps developers in choosing their own range of effective and economical solutions. For example, with Daffodil DB the developer can use Open Source tools like JBOSS application server for reducing overall TCO. Last, but certainly not the least, let?s get to Licensing Costs. Pardon me if I seem to evangelize Daffodil DB, but that?s one area where I can ?preach? with confidence. As Daffodil DB can be used / embedded with a wide array of applications, flexible licensing policies have been developed to accommodate the diverse needs of the development community without restricting the same to just one standard license. Each application development organization may pick the right combination of licenses that best meets its needs. The organizations may also acquire additional licenses or upgrade their licenses. Do I hear someone shout ?What about Open Source??

Microsoft Great Plains Implementation ? Overview for IT Director/Controller

What is installation in the language of technology? Installation has server and client sides. Server side - Installation creates security environment (logins) on MS SQL Server or MSDE, creates system database - DYNAMICS and then company databases. All these tasks are performed by Microsoft Great Plains Utilities Workstation side - workstation installation copies the client side application, installs current version of MDAC (we need SQL ODBC driver - please check documentation on ODBC DSN setup), registers the application. If you plan to run Great Plains Utilities from the workstation to create server side (see above) - you need to check Install Client and Server Components What is following implementation? Implementation requires combination of technological and accounting skills System Setup - you should refer to GP documentation. In general setup consists of Company information, General GL/AR/AP/Payroll setup, User classes, Customer/Vendor/Employee classesto name a few Master Records - you should either use integration tools, such as Integration Manager, SQL queries or have users to type in all your GL Accounts, Customers, Vendors, Employees . Beginning Balances - this is recommended approach - you place aside the old accounting application for querying the historical data and enter beginning balances in Great Plains GL, AR, AP, SOP, POP, Payroll. When you have balances in the system you are ready to use it in production Historical Data conversion - this is optional, in order to do historical data conversion you need to know basic Great Plains tables structure (Setup->Tools->Resource Description->Tables Structure). This is similar to surgery - so you probably need outside consultant to help you. If the volume of historical data is small - you can deploy Great Plains Integration Manager and then post the records in the modules. User Training - we are just listing this item - it is up to you to decide on the way to train your users Using Two Systems in Parallel - this is recommended. You should print the reports from both systems during this test period and compare the results Customization - typical areas of customizations: Invoice form, Crystal Reports, pulling info from multiple databases, including Great Plains database, Great Plains forms modification with Modifier/VBA, Great Plains Dexterity forms and logic customization, integration with CRM, RMS and other business systems, web publishing from Great Plains tables, EDI with your suppliers, SQL Data Transformation packages Do I need consultant? We strongly recommend you to use consultant in the following cases You have identified the need for Great Plains Dexterity customization You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools You are doing migration from Great Plains Accounting to Microsoft Great Plains You have to create a lot or ReportWriter Modified Great Plains Reports You have old version of Great Plains: Dynamics or eEnterprise 6.0 or prior - in this case you can not appeal to Microsoft Technical Support - it is discontinued Your Great Plains has more than 20 users in this case the mistake may lead to serious business problems You don't have support for your old Great Plains - then you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade Good luck with installation, implementation, 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!

Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content

It?s no secret that software companies operate in a very competitive space where rivalry is increasingly fierce and where profit margins can be razor thin. New, smaller software companies are sprouting up each month and the leading software companies continually make strong advancements forward leveraging massive cash flow reserves. This cycle makes it difficult for the mid-sized software company to compete because (a) they don?t typically have the cash flow necessary to take giant leaps forward in the industry and (b) because they need to continually move forward to stay ahead of the smaller software companies that are vying for their slot in the marketplace. Consequently, making the jump from an unknown to a mainstream brand can prove to be very difficult for the mid-sized software company.

Cisco CCNA Certification: Becoming A Truly Valuable CCNA.

I've been active in the Cisco Certification track for four years, working my way from the CCNA to the coveted Cisco Certified Internetwork Expert title, and during that time I've conducted job interviews and casual conversations with hundreds of CCNAs and CCNA candidates.

Software Piracy

We regularly hear reports about the cost to the software industry of software piracy, but are the claims to be taken at face value? Statistics are notoriously biased towards what the author is trying to say.

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!

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!

Crystal Reports for Microsoft Great Plains ? Overview for Developer

Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the US market. It serves the whole of vertical and horizontal market: most of the industries and company sizes. Crystal Reports on the other hand is the leader in the reporting software industry and Microsoft is willing to use Crystal as main reporting tool for Great Plains, Solomon, Microsoft CRM, .Net platform, etc. If you are developer who is asked: how do we extend Great Plains ReportWriter with somewhat more sophisticated ? read this and you will have the clues on where to look further. Great Plains Tables Structure ? first of all you need to know the tables to link. 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. Consider SQL Views ? if you don?t want complex links in Crystal Report itself or if you need unionization from several companies ? SQL view is the answer. Consider SQL Stored Procedures. Sometimes you can not pull the data in one view ? you need temporary tables to be created and the final query should be based on these temp tables ? this is when you need stored procedure. Call Crystal Report from GP Screens via VBA/Modifier ? if the user wants to call Crystal report for example - printing Invoices in GP and do it from SOP Entry window ? you can use Modifier and VBA to call Crystal Reports engine. 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. Happy customizing, querying and designing! if you want us to do the job - give us a call 1-866-528-0577!

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 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!

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as Client Relation Management system is very robust combination and could serve midsize to large corporation as Business System. Being VP IT or IT Director you need to foresee the positions to have in your IT department to do internal MS Great Plains and MS CRM support. Let us give you the directions, based on our research and consulting practice. Microsoft SQL Server Specialist ? we specially do not name this position as MS SQL DBA, because both Great Plains and MS CRM are not very complex from the database administration side, they do not use indexes optimization, referential integrity, probably do not require complex transaction log backup/recovery scenarios. On the other hand this position requires Great Plains and Microsoft CRM tables structure analysis and some primary Great Plains data fixing skills via SQL queries, described in MBS Customer source techknowledge database. The best candidate should have some accounting background - to be able to address ongoing issues to MBS technical support. Network Administrator with good Microsoft Exchange and Active Directory skills. Microsoft CRM uses all the newest Microsoft technologies, and Exchange is a workhorse here. In order to install and upgrade MS CRM this guy needs to understand the under-laying Microsoft technology. In the best case - she/he should know Exchange security structure and probably program Exchange handlers, due to the fact that CRM/Exchange connector is not a perfect tool yet. C# or VB.Net programmer with excellent SQL Skills? if you are midsize or large company - you should have this position - you will need web publishing and MS CRM customization and its support. Currently Microsoft CRM SDK has C# examples - so C# programmer would be the best fit, it may have more VB code in the future, so the C# - VB balance maybe restored. Crystal Reports Designer/Programmer - Crystal Reports is the best tool available on the market to address both Great Plains and MS CRM reporting needs. This position maybe merged with one of the above. These people should be probably cross-trained in both Great Plains, Microsoft CRM, Crystal Reports, SQL and C# programming, so you do not depend on the unique skills of one person. In our opinion, which is based on our long term consulting practice - these skills will allow you to keep the cost of IT support reasonably low and avoid paying high consulting price to your Microsoft Business Solutions Partner. Happy hiring and training! But in any case you need to select Microsoft Business Solutions Partner/Var/Reseller to be your official representative. This is how MBS has its channel working - it assures that Microsoft Business Solutions products are properly implemented. If you want us to be your Microsoft Business Solutions Partner - give us a call 1-866-528-0577!

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software market. The whole conception behind CRM seems to be different. In case of traditional CRM software (Siebel, Oracle) - the application was designed with platform independence in mind. Microsoft CRM is dedicated to Microsoft technology and so deploys all the Microsoft tools: Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc. If you are software developer, database administrator or web designer who is asked: how do we customize Microsoft CRM ? we are giving you directions in this article. Microsoft CRM SDK ? this is software development kit with C# and partly code samples ? it is supported by Microsoft Business Solutions technical support. It is based on web service calls, if you are C# .NET developer ? you are excellently positioned to do this type of customizations. This is the preferred modification scenario and this should be easily upgradeable customization. VB.Net examples will be available soon. Legacy SQL Data integration. This is also easy and safe. If you have SQL database, sitting on the same or linked SQL Server ? you can create ASPX .Net application and simply integrate it into CRM. You can place it on the navigation bar or menu in isv.config ? please refer to MS CRM SDK Legacy ASP integration ? this is somewhat more sophisticated. You have to deploy HTTP handler to be a middle party between CRM which is .Net based and ASP which is legacy IIS. The trick is ? you have to have INI file with security settings to penetrate into MS CRM with proper credentials, calling web service. Microsoft Exchange Programming. Microsoft CRM has Exchange connector ? which moves CRM incoming email to MS if it has GUID in its subject. You can alter this logic (for instance - move email to CRM if it doesn?t have GUID but it is from the sender who is contact or account in MS CRM). Refer to MS Exchange SDK onsyncsave event handling. Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience. Direct SQL touch ? in #4 above I described you the scenario with MS Exchange handlers ? this would be ideal world if MS CRM SDK does the job. But ? in real world this is not always true ? you have to do direct flags correction in CRM database (like making Activity closed, moving email attachments/octet streams, etc). This is not supported by MBS technical support ? but you can rescue to this technique if you have to get job done. MS CRM Customization tool ? this is rather end-user tool and we don?t describe it here ? read the manual. We?ve described above the options to use when this tool doesn?t do the job Crystal Reports - feel free to create Crystal report - tables and views structure is self explanatory. Try to avoid the temptation to create your own SQL view or stored procedure in MS CRM database, instead - create custom database and place your view and stored proc in it. Happy modifying! If you want us to do the job - give us a call 1-866-528-0577!

More Articles from Software Information:
2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39

Tableau Software Threatened? Rival Growing at 70% Just Raised $103M  Forbes

Tableau Software expects 20% growth in 2019. Rival Looker is growing at 70%. Should Tableau investors be worried?

Why Firms Need A Collaboration (Software) Strategy  Forbes

In basic terms, companies now need a collaboration strategy to work out which collaboration software they will use and how it will be installed, custom-tuned, ...

2019: Look for improvements to software-defined data-center networks  Network World

Developments in cloud services, security, containers and white-box switches can make a positive impact for software-defined data-center networks in the coming ...

Willis Towers Watson Launches New Version of Radar Pricing Software  Insurance Journal

Willis Towers Watson announced the launch of the latest version of its Radar pricing software. With the speed of change and disruption across markets and.

Weed Advisor’s software to help LPs manage assets, ensure compliance  The GrowthOp

Savings through optimization sought while eliminating potentially costly infractions and downtime.

DOE Standardizes on Nlyte Software's Datacenter Infrastructure Management Platform  HPCwire

SAN MATEO, Calif., Dec. 11, 2018 -- Nlyte Software, a leading software provider for managing computing infrastructure, and Data Center Infrastructure.

Quorum Software Appoints Gene Austin as President and CEO  PRNewswire

Software Industry Veteran to Lead Next Stage of Quorum's Growth HOUSTON, Dec. 11, 2018 /PRNewswire/ -- Quorum Software, the leader in digital ...

New cyber security division for independent software testing company  Software Testing News

UK independent software testing company, Edge Testing Solutions, has begun offering UK clients access to a new cyber security division.

Five Providers of AI Software Platforms Named IDC Innovators  Business Wire

A new IDC Innovators report profiles five companies that offer compelling and differentiated general purpose AI software platforms.

The Fintech Files: Teaming up to beat Big Software  Financial News

Your weekly roundup of the latest developments in financial tech and innovation.

Here is What Hedge Funds Think About Tableau Software Inc (DATA)  Yahoo News

There are several ways to beat the market, and investing in small cap stocks has historically been one of them. We like to improve the odds of beating the market ...

Enterprises turn to software solutions to manage endpoint devices  BetaNews

As businesses embrace digital transformation, things like the growth of distributed workforces and remote work are impacting both the day-to-day responsibilities ...

There's a simple reason why the Amazon Echo costs so little  Quartz

Smartphones apps, social media, and smart devices dominate our attention. But in a world full of infinite pings and notifications, software that makes itself a habit ...

Global Recruitment Software Markets to 2023 - Dominated by IBM, iCIMS, Lumesse, Oracle and SAP -  Business Wire

DUBLIN--(BUSINESS WIRE)--The "Global Recruitment Software Market 2019-2023" report has been added to's offering.

HubSpot Launches HubSpot Ventures, $30M Fund for Early-Stage Software Companies  American Inno

HubSpot is officially joining the club of tech companies that have professional venture arms.

Kids in China are trying every trick in the book to beat the facial recognition software that puts a mandatory time limit on popular video games  Business Insider

Chinese video game publisher Tencent recently implemented facial recognition software to verify the ages of the people playing its games in China.

Cannabis Software Company Baker Sees Promise in TILT Holdings B2B...  New Cannabis Ventures

Exclusive Interview with Baker Technologies, CEO and SVP, Software & Services, TILT Holdings Joel Milton. Since starting in 2014, CRM ...

Civica Snaps Up NHS Recruitment Software Provider  Computer Business Review

Acquisition “adds further specialist capability which the Group does not currently offer”. Outsourcing giant Civica has bought privately held UK software provider ...

Opinion: Microsoft browser shift has major implications for software and devices  TechSpot

At a basic level, it's an important (and surprising) move that seems significant for web developers and those who like to track web standards. For typical end ...

Software automation co Quali raises $22.5m  Globes

The Israeli company is focused on automation and orchestration software to deliver environments-as-a-*service* for digital transformation initiatives aligned with ...

Magic Software Chairman, Arjun Malhotra Awarded the 'Lifetime Achievement Award' by Dataquest  PRNewswire

NEW DELHI and NEW YORK, December 11, 2018 /PRNewswire/ -- Chairman and board member Arjun Malhotra for Magic Software Inc. was presented with the ...

India's HCL Sees Shares Slide After Agreeing to Buy $1.8B Worth of IBM's Software Assets  Data Center Knowledge

Indian software maker HCL has agreed to buy some of IBM's software assets for $1.8 billion • Its shares declined on the news, making it the worst performer ...

Google to Accelerate Closure of Google+ Social Network After Finding New Software Bug  The Wall Street Journal

Google said it would close the consumer version of its Google+ social network earlier than planned, after a second software glitch this year exposed the profile ...

Aberdeen Likes European Medical Technology, Software and Services  Bloomberg

Ben Ritchie, senior investment manager at Aberdeen Asset Management, discusses the outlook for European equities. Robin Niblett, director at Chatham House ...

O2 poised to receive millions from Ericsson over software failure  The Guardian

O2 is expected to receive a multimillion-pound compensation payment from technology group Ericsson over a software failure that cut off customers on Britain's ...

Coupa Software (COUP) Reports Acquisition of Hiperos

News and research before you hear about it on CNBC and others. Claim your 2-week free trial to StreetInsider Premium here.

Software company expands into Maine with Portland office  Mainebiz

Rapid Insight, an analytics software solutions company based in Conway, N.H., has expanded into Maine with a new office at 120 Exchange St. in Portland.

Retailers Rank Logile #1 in 8 Categories in 2019 RIS Software LeaderBoard as Logile Again Lands Top-20 Overall  Business Wire

Logile tops retail 2019 RIS Software LeaderBoard: #12 of Top-20 overall, 36 Top-10s, 8 #1s in customer satisfaction, innovation, *service* and support.

Microscope Software Market Worth $780 Million by 2023 - Exclusive Report by MarketsandMarkets™  PRNewswire

CHICAGO, December 11, 2018 /PRNewswire/ -- According to the new market research report "Microscope Software Market - Type (Optical Microscope, Electron, ...

Exadel Sees Strong Growth in 2018 with New Software Engineering Practices, Strategic Partnerships, and Upgrades  PRNewswire

WALNUT CREEK, Calif., Dec. 11, 2018 /PRNewswire/ -- Exadel (, a global software engineering company, saw strong 2018 momentum with ...

Paul Scherrer Institute Utilizing Varian Software Solution for Advanced Proton Therapy Treatments  PRNewswire

PALO ALTO, Calif., Dec. 11, 2018 /PRNewswire/ -- Varian (NYSE: VAR) today announced the Paul Scherrer Institute (PSI) Center for Proton Therapy in ...

Rootstock Software Announces New International Channel Partners  Associated Press

SAN RAMON, Calif.--(BUSINESS WIRE)--Dec 11, 2018--Rootstock Software, a leading cloud Enterprise Resource Planning (ERP) provider for manufacturing, ...

Paycom Software: Growing Fast At A Stretched Valuation  Seeking Alpha

Paycom is a human capital management software company. The company's financial performance has been outstanding and the company has received ...

OneStream Software Expands Executive Team with Appointment of Dave Kasabian as Chief Marketing Officer  Associated Press

ROCHESTER, Mich.--(BUSINESS WIRE)--Dec 11, 2018--OneStream Software, LLC, a leader in Corporate Performance Management solutions for the mid-sized ...

JMI Equity closes $1.2 billion fund for investing in software companies  Baltimore Business Journal

The $1.2 billion fund, called JMI IX, is the largest ever closed by JMI Equity and exceeded the firm's target.

Loc8 software can analyze drone photos to help locate missing people  DroneDJ

Loc8 software can go through thousands of images, much faster than is humanly possible, to locate the few pixels that might represent a missing person.

Alchemy Software Releases CATALYST 2019  Business Wire

Alchemy Software Development, the world leader in visual localization solutions and a division of TransPerfect, today announced the release of Alchemy.

Guten Tag: Ad-ID Added To WO Network Software  Radio & Television Business Report

In a move designed to make it easier for national cable TV networks to collaborate with ad buyers, the WO Network software for managing network commercial ...

Ashly Releases Protea Network-Enabled Software Update  Audio Visual News Network

Major changes to the software since July include further clarity into functions and statuses, more accurate reporting within the UI, and fixes to errors identified ...

Deep savings on cameras, lenses, software and more  Boing Boing

So you've got a good eye for pictures? We've got a good eye for deals. And this holiday, there are some solid deals out there for photographers. Check out some ...

Viventium named “FrontRunner” for HRIS software by software reviewer Software Advice  GlobeNewswire

BROOKLYN, N.Y., Dec. 11, 2018 (GLOBE NEWSWIRE) -- Viventium — a transformative, living, and purely cloud-based HCM solution that provides actionable ...

PennJersey Environmental Consulting Selects Locus EIM SaaS-Based Software for Its Environmental Compliance Data  Associated Press

MOUNTAIN VIEW, Calif., Dec. 11, 2018 (GLOBE NEWSWIRE) -- Locus Technologies, (Locus), the industry leader in EHS, sustainability, and compliance ...

AMD Radeon Software Adrenalin 2019 Edition’s 25+ New Features Leaked – Out Dec 13  Wccftech

As has become tradition, AMD is yet again on the cusp of launching its next big driver package as a holiday gift to all of its Radeon fans. Adrenalin 2019 Edition ...

TfL Offers £186 Million to Simplify Asset Management Software  Computer Business Review

Transport for London (TfL) has opened up a £186 million contract opportunity to migrate multiple existing systems to one single supported Asset Management ...

Yokogawa Releases Enhanced Version of Field Assistant Software  ARC Viewpoints

Yokogawa Electric Corporation announced that it has enhanced the Field Assistant software for the field inspections of industrial facilities and is releasing it as ...

Earth scientists gain insights into Earth's crust thanks to geological modeling software  EurekAlert

Members of the Department of Earth Sciences will gain new insights into Earth's crust, thanks to a licensing agreement between Syracuse University and ...

Huawei, sanctions and software: everything you need to know  The Guardian

The Chinese telecom giant is under renewed global scrutiny after the arrest of its founder's daughter. Here's why.

US, EU Hindering Global Ban on Malicious Software - Russian Cyberthreat Centre  Sputnik International

The deputy head of Russia's National Cyberthreat Response Centre has said that an international ban on malicious software would be a major step in boosting ...

Save the Cat!® Announces First Screenplay Competition, New Software, and CMO Hire  PRNewswire

LOS ANGELES, Dec. 11, 2018 /PRNewswire/ -- Save the Cat!, the "go to" in story structure development for screenwriters, authors, filmmakers, and studio execs, ...

Introduction of Fast-Start Franchise Management Software for Emerging Brands

FranConnect, the leading provider of franchise management solutions, announces the launch of Velocity Packs for emerging franchise brands with up to 100 ...

Halian Attains Microsoft Software Asset Management Managed Service Program Accreditation in the Gulf Region  RealWire

Halian becomes a regional go-to partner for customers needing software asset management supportDubai, 11/12/2018 - International IT services company ...

The tech giants can’t afford to alienate their key asset: software engineers  The Guardian

Skilled coders have transformed Google and Facebook into world beaters, but recent scandals won't help in retaining their services.

On the Street: Honours for patient-wait, social, and home-renting software  Times Colonist

A social network to reduce isolation, software to direct patients to clinics with shorter wait times and a project to connect people needing housing are squaring off ...

IBM Selling Big Part Of Its Software Portfolio To India's HCL In $1.8 Billion Deal  CRN

IBM is exiting its increasingly stand-alone collaboration and marketing software business to focus on forward-looking technologies such as artificial intelligence, ...

ECi Software Solutions Acquires Lasso Data Systems  Global Banking And Finance Review

ECi Software Solutions, a leader in cloud-based business management solutions, today announced it has acquired Lasso Data Systems, a leading provider of ...

Samsung files to trademark blockchain and cryptocurrency software  PocketNow

Recent Samsung trademark filings reveal the company's plans to develop blockchain and cryptocurrency software for smartphones.

Content Marketing Software - Global Market Outlook to 2026 -  Business Wire

DUBLIN--(BUSINESS WIRE)--The "*Content* Marketing Software - Global Market Outlook (2017-2026)" report has been added to's ...

Software engineer found dead in Google's NYC offices  CBS News

NEW YORK — Police say a 22-year-old software engineer was found dead at the company's New York City headquarters. Scott Krulcik was found unconscious ...

Optanix Launches Monitoring Platform From Internal Software Offering  SDxCentral

*Service* assurance software provider Optanix unveiled its first standalone monitoring and analytics platform. The platform provides hybrid IT infrastructures with ...

Softcat partners with 'leader' in cloud management software

Softcat has partnered with cloud management software provider CloudHealth in a move which the pair claim could reduce customer cloud spend by 30 per cent.

Software firm to create 85 jobs in Galway  RTÉ News

A software development company is to create 85 jobs in Galway over the next 12 months.

Why Teachers Don't Use The Software The District Paid For  Forbes

Schools spend a great deal of money on software that is barely used, if at all. Why does that happen?

Here's why IBM just sold a $1.8 billion chunk of its software business to the Indian IT company HCL  Business Insider

As part of its efforts to focus on "high-value" products, IBM will sell seven software products to the Indian company HCL for $1.8 billion, the company announced ...

Stocks To Watch: 5 Top Software Stocks With Bullish Charts  Investor's Business Daily

The stock market is as volatile as ever, but stocks to watch in the software sector are in plentiful supply, especially those holding near highs.

Ericsson software problem has been causing widespread cell phone outages  TechCrunch

A problem with the software in Ericsson equipment is causing outages across the world, including O2 users in Great Britain and SoftBank users in Japan, ...

Why Tableau Software Stock Popped 16.8% in November  The Motley Fool

The data-analysis software specialist delivered solid quarterly results last month. Here's what investors need to know.

Adobe's Position In The Software Industry  Seeking Alpha

The stock price of Adobe seems particularly attractive after a short contraction due to overall market uncertainty, even after the recovery seen in recent days.

[Sponsored] Software Christmas Madness: Windows 10 Pro $11.47, Office 2016 Pro $25.98 and Office 2019 $53.32  SamMobile

Christmas is just around the corner and everyone is already looking for the best Christmas Deals out there! Goodoffer24 has some great software deals.

LeanIX, the SaaS that lets enterprises map out their software architecture, closes $30M Series C  TechCrunch

LeanIX, the Software-as-a-*Service* for “Enterprise Architecture Management,” has closed $30 million in Series C funding. The round is led by Insight Venture ...

How Realtors Benefit from Real Estate Software  G2 Crowd

Real estate software facilitates and automates key job functions for real estate professionals. Continue reading to read what specific benefits real estate ...

How Software Is Helping Big Companies Dominate Daily

Throughout the global economy, big companies are getting bigger. They're more productive, more profitable, more innovative, and they pay better. The people ...

How Software Code Could Help You Grapple With the Legal Code  WIRED

Local legal codes can be hard to find online or hidden behind paywalls. The "free and open law" movement wants to change that.

County officials begin negotiating multimillion-dollar contract for software upgrades  Toledo Blade

With no discussion or mention of a top Democrat's accusation of political dealing at taxpayers' expense, Lucas County Commissioners agreed Tuesday to ...

How A Mysterious Tech Billionaire Created Two Fortunes—And A Global Software Sweatshop  Forbes

Two decades ago, Joe Liemandt became the youngest member of the Forbes 400 by building a software juggernaut. He's quietly bigger than ever, with a far ...

The Good Times Continue for VMware, Salesforce and Many Other Software Names  TheStreet Tech

Recent earnings reports from several major software firms suggest business trends remain pretty good for the group....VMW.

Israeli Software Helped Saudis Spy on Khashoggi, Lawsuit Says  The New York Times

LONDON — A Saudi dissident close to the murdered journalist Jamal Khashoggi has filed a lawsuit charging that an Israeli software company helped the royal ...

The battle over the driving experience is heating up and will be won in software  TechCrunch

Sirius XM's recent all-stock $3.5-billion purchase of the music-streaming *service* Pandora raised a lot of eyebrows. A big question was why Sirius paid so much.

Why Coupa Software Is Sinking Today  Motley Fool

In response to reporting of fiscal third-quarter results, shares of Coupa Software (NASDAQ:COUP), a software-as-a-*service* company that focuses on ...

DeepMind’s Go playing software can now beat you at two more games  New Scientist News

DeepMind's AI Go master has taught itself new tricks. The latest version of the machine learning software, dubbed AlphaZero, can now also beat the world's best ...

Ericsson sorry for software glitch that hits mobile services in Britain and Japan  Reuters

Sweden's Ericsson apologized and said it was working hard to fix a software glitch that was responsible for millions of smartphone users in Britain, Japan and ...

New software will let artists control how light interacts with objects  Ars Technica

Animators will now be able to precisely control how microscopic particles interact with light in their renderings of objects, thanks to a research collaboration ...

An Israeli tech firm is selling spy software to dictators, betraying the country’s ideals  The Washington Post

Israel has always prided itself on being, as the Book of Isaiah says, “a light unto the nations” — an exemplar of “righteousness” to inspire Jews and gentiles alike ...

Tabula Rasa To Acquire DoseMe For Dosing Software  Seeking Alpha

Tabula Rasa HealthCare has agreed to acquire DoseMe for up to $30 million in total consideration. DoseMe has developed a dosing software decision support ...

This N.L. software developer won an Emmy for his work on an app

Did you know a software developer could win an Emmy award? Jonny Sutherland did just that. "It's kind of funny, really, to be an Emmy-award-winning software ...

AI software can dream up an entire digital world from a simple sketch  MIT Technology Review

Creating a lifelike digital scene normally requires skill, creativity, and patience. Now we can just offload the work to an AI algorithm.

Hard Questions Raised When A Software 'Glitch' Takes Down An Airliner  Forbes

Air travel is, statistically, much safer than driving. But when a software "glitch" takes down an airliner, it becomes painfully obvious how critical software integrity ...

The best new software of 2018  Popular Science

On our list of the top software innovations of 2018, there's tech that'll do fun things, like deliver a pizza to your spot in a public park, and programming that takes ...

Mining software isn't just for cryptocurrency — it could also be used to steal corporate secrets  CNBC

A threat researcher recently discovered that mining software can be programmed to steal sensitive documents, log in credentials or take down critical systems.

SubtlePET Artificial Intelligence Software Enhances PET Scans, Saves Time in Scanner |  Medgadget

Subtle Medical, a firm headquartered in Menlo Park, California, won both FDA clearance and the European CE Mark of approval to introduce its SubltePET.

How to Choose the Best Tax Software for You This Year  U.S. News & World Report

Opting to file your taxes online involves tough decision-making. Which tax software or online program should you use? Should you buy the "deluxe" package?

New software coming to Livonia rec center, allowing for easier class signup

A new software system arriving next year will mean signing up for courses and programs at the rec center can be done easier.

New software will bring NH tax collection of out of the pre-Windows era  Concord Monitor

It's pretty easy to see why the state's tax collectors think they're long overdue to get a software update. Just peer over somebody's shoulder as they work.“Yes ...

Software Development Is Dead  Nextgov

The greatest technological breakthrough of our lifetimes, a cherished promise as old as software development, is finally coming to fruition. Right now.

reMarkable tablet: A software update makes this forgotten gadget incredibly useful  Boing Boing

A couple of years ago, I was asked if I'd like to review the reMarkable tablet. If you're unfamiliar with it, the reMarkable is an E Ink slate and pen solution that ...

Monroe/DAS Upgrade Software  Radio World

Monroe Electronics and its Digital Alert Systems stablemate have announced a major whole number software upgrade for its DASDEC-II and Monroe One-Net ...

Put 'Cloud Prince' Coupa Software on Your Trading Radar

In Monday's Recon, we discussed RH (RH - Get Report) , formerly known as Restoration Hardware, and the fact that the company had moved its earnings ...

LDH launches new Medicaid enrollment software  WAFB

The Louisiana Department of Health (LDH) has launched its new Medicaid enrollment technology, which is expected to help combat fraud and abuse of the ...

Software vendor claims Idaho's purchasing process was flawed  Idaho Statesman

One of the unsuccessful bidders vying for an Idaho teacher evaluations software contract has accused the state of running flawed and biased purchasing ...

The Consequences of a Changing Open-Source Software Business Model  CMSWire

It has been an interesting year for open-source software makers. The primary commercial sponsors and/or individual contributors to projects as game-changing ...

Software developed at ISU aids wildfire response  KXLY Spokane

Computer software that developed at Idaho State University to aid in post-wildfire recovery efforts is now being used by some fire managers during active fires.

home | site map
© 2005