Microsoft CRM Custom Design & Development

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 VB.net 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! help@albaspectrum.com Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Seattle, Minneapolis, Los Angeles, Houston, Dallas, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer. MORE RESOURCES: Microsoft to unveil new mobile services and software - MarketWatch Computing News Microsoft to unveil new mobile services and software MarketWatch - 2 hours ago The services will be announced at the 3GSM World Congress in Barcelona, where Microsoft will show off Windows Mobile 6, a new version of its software for ... Microsoft unveils new mobile software The Age Microsoft Reveals New Windows Mobile 6 Smartphone Software ... FinanzNachrichten.de Microsoft reveals new Windows Mobile 6 Smartphone software Wireless Design & Development Asia Prdomain Business Register (press release) - I4U all 124 news articles IBM Wants to Wipe Out Microsoft’s Software from Business Desktops - Playfuls.com Playfuls.com IBM Wants to Wipe Out Microsoft’s Software from Business Desktops Playfuls.com, Romania - 1 hour ago Yesterday, IT giant IBM unveiled its plans to reduce costs of managing Apple or Linux desktops, by offering a new open source software system for business ... IBM software makes mixed networks viable Macworld UK IBM aims to lower cost of using Linux, Apple PCs Playfuls.com IBM aims to lower cost of using Linux, Apple PCs Expressindia.com all 22 news articles Atex, the World's Leading Developer of Software Solutions for the ... - Canada NewsWire (press release) Atex, the World's Leading Developer of Software Solutions for the ... Canada NewsWire (press release), Canada - 5 hours ago 12 /CNW/ - Atex (www.atex.com), the world's leading developer of software solutions for the media industry, has today announced that it has acquired Mactive ... Atex, the World's Leading Developer of Software Solutions for the ... Yahoo! News (press release) Atex, the World's Leading Developer of Software Solutions for the ... PR Newswire (press release) all 10 news articles New models replacing 'box' software delivery - The News Journal New models replacing 'box' software delivery The News Journal, DE - 1 hour ago 30 launch of the consumer versions of Microsoft's flagship software may be among the last of its kind -- a product sold for a flat fee in a shrink-wrapped ... Japan's Renesas to work with Nokia on software for cell phones ... - Forbes Japan's Renesas to work with Nokia on software for cell phones ... Forbes, NY - 9 hours ago The Finnish firm will make its S60 platform software compatible with the Japanese semiconductor manufacturer's SH-Mobile system chips, which are currently ... Nokia Builds on Vision of Mobilizing the Internet to Transform ... Yahoo! News (press release) all 14 news articles Global Demand for New Leadership & Organizational Development ... - PR Web (press release) Global Demand for New Leadership & Organizational Development ... PR Web (press release), WA - 4 hours ago The animation software combines the GROW coaching process with four animated video movies. Instead of traditional coaching techniques the process combines ... Cranes Software net rises 67.94% in Dec`06 qtr - Myiris.com Cranes Software net rises 67.94% in Dec`06 qtr Myiris.com, India - 1 hour ago Cranes Software (Q, N,C,F)* International has reported a rise of 67.94% in net profits to Rs 264.61 million for the quarter ended December 2006 as compared ... Cranes Software to utilise Rs 2172.60 mn Myiris.com all 2 news articles CSR Launches Superior GPS Software for Seamless Mobile Positioning ... - DMN Newswire (press release) CSR Launches Superior GPS Software for Seamless Mobile Positioning ... DMN Newswire (press release), CA - 2 hours ago CSR's GPS solution is software-based and requires no further hardware beyond a RF front-end, hence the E5000 requires less than half the power and ... • Planner's software helps cut big events down to size - Indianapolis Star • Planner's software helps cut big events down to size Indianapolis Star, IN - 4 hours ago The Registration System is Web-based software that helps corporations and specialized event-planning firms coordinate tours and events of all sizes. ... Software industry grows by 30% - Nhan Dan Software industry grows by 30% Nhan Dan, Vietnam - 3 hours ago The software industry in 2006 generated US $300 million in revenue, up 30% year-on-year, in which exports accounted for US $90 million , reported the ... RELATED ARTICLES Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights Microsoft Great Plains is one of the Microsoft Business Solutions family ERP products: Great Plains, Navision, Axapta, Solomon, Small Business Manager. MBS also has Microsoft CRM - Client Relation Management software and Microsoft Retail Management System (Microsoft RMS)Microsoft Great Plains 8. Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware Spyware and malware are large problems for Internet users today and can be both annoying and a real threat to you and your computer. There exist a number of different spy and malware of which some are relatively friendly and only spies on your surfing habits, while others like the Trojans can be used to corrupt your hard drive or steal your usernames and passwords. How to Choose the Right Accounting Software for Your Business With any good luck and a good amount of hard work, you're having the same problem many business owners today are facing. Your business is growing rapidly and you're having problems controlling your finances. How to Choose the BEST Charting Software I suggest that you do not spend a lot of money on charting software as most perform very similar functions. Often the price is inflated to capitalize on the mentality that expensive is better. C++ Tutorial 1, Introduction to C++ Introduction to C++Why Learn C++?C++ may at first seem like a boring, confusing programming language that you can only program command prompt applications with. Well, that is what it is like in the [b]begining[/b]. Microsoft Great Plains Implementation in Russia - Overview for Consultant Microsoft Business Solutions Great Plains is very popular ERP platform in the USA, Canada (including French speaking Quebec/Montreal), U.K. Can You Calculate Complex Financial Calculations? Are you a whiz at calculating financial information? Not the easy personal stuff, like figuring out your monthly mortgage based on a fixed interest rate for x number of years, or how much money you have available each month after all your bills are paid. (You can probably use your fingers to figure that one out!)But the hard stuff, you know, the things you need to know when you're running a small business. Corporate ERP: Standard vs. Rich functionality - Microsoft Great Plains Traditionally we were considering functionally rich systems, such as SAP, Oracle Financials, PeopleSoft, JDEdwards as the fit for large publicly traded corporation. There might be multiple opinions for the future corporate ERP/MRP systems. Linux vs Windows Operating Systems With so many Microsoft Windows related viruses, errors, and other software problems, many average computer users are looking at alternative operating system platforms, such as Linux. It is important that users, frustrated with Windows, don't simply install a version of Llinux without knowing what they are in for. Microsoft Great Plains Partner Selection: Overview Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business Solutions ERP applications, serving to the whole spectrum of vertical and horizontal markets. Assuming that you already have one of these systems installed and implemented we would like to give you - IT director, Database Administrator, Programmer, Software Developer, Controller your options in supporting/upgrading Microsoft Great Plains for your companyIt is always good idea to install everything on your own - however Great Plains requires combination of computer networking, some programming, good accounting/distribution/logistics/reporting background - so it is not a surprise that Microsoft Business Solutions requires their customers to have specially assigner Microsoft Great Plains Partner/VAR/Reseller to serve the account. Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management Let's first look at your ERP system selection (without Retail Solution). Your options are:Microsoft Great Plains. The XP Firewall Isnt Enough You might think you don't need a firewall because windows XP has one built in, but read on for a plain-english explanation why this isn't enough. Before broadband and cable connections were common most people didn't need a personal firewall because they weren't connected to the Internet for extended periods of time. Cisco Certification: Introduction To ISDN, Part III Configuring PPP PAP AuthenticationNow we know how the ISDN link comes up (interesting traffic), and some scenarios that might cause the link to stay up, we need to look at ISDN authentication schemes. The two methods Cisco certification candidates must be familiar with are PAP and CHAP. Great Plains Dexterity History and Programming Overview As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into Microsoft Great Plains and Microsoft Business Solutions is in process of merging all its accounting applications: Great Plains, Solomon, Navision and Axapta into somewhat granular: Microsoft Financials, Microsoft HR, Microsoft Distributions, Microsoft Project Accounting, etc. So the original design of Great Plains should be deemphasized. Microsoft CRM for Corporate Business - Working Offline If your company has regional and worldwide operations, you might already realized that it is very hard to get decent internet connection in your remote locations. In this small article we will try to give you highlights on how to implement Microsoft Business Solutions CRM for worldwide operations with restricted internet connection. Review on QuarkXpress 6.0 After almost two decades of existence, Quark has become the basic building block of any print designer's toolkit. It has deservedly gained a reputation for reliable printing, offering consistent and dependable output that prevents costly mistakes. Microsoft CRM Customization - Processing In/Out-Going Email Messages We would like to give you several situations, when you may need custom development and programming to improve Microsoft CRM functionality. This overview is for programmer, software developer, IT specialist, database administrator. The End of Spyware? The US House of Representatives has recently passed the "Spy Act" - or to give it its full title - the Securely Protect Yourself Against Cyber Trespass Act. This aims to prevent software companies from installing spyware on users PCs without their knowledge, and anyone found guilty of breaching the act faces a fine of up to $3 million. Spyware, Adware, etc. -- Terms and Common Sense When reading an article where some term is used often, it is useful to make sure the author of the article and you mean the same. Not surprisingly for those who still remember English lessons at school, every noun ending with "ware" is a mixture of objects having something in common--usually used for similar purposes. How Do I Get Rid Of That Darn Spyware? Ad-Aware and Spybot are probably the two most well known antispyware solutions. However, they frequently fail to catch the more crafty spyware.

Microsoft CRM Implementation - Fundamental CRM Principles Revision

Microsoft CRM is relatively new player on the now becoming traditional CRM software applications market. We would like just to mention shift in the technical conception - Microsoft CRM is committed to Windows and Microsoft components: Exchange, Active Directory, SQL Server, etc (while traditional CRM applications, such as Siebel were biased toward multiplatform compatibility: Unix, Oracle, Windows, SQL Server) and move up to business logic paradigm shift.

There is high-tech wisdom and it is always applicable to traditional industries, such as auto makers. Don't try to be too innovative on the market, rather have your competitors build the market niche and then move in. It is rather safe not to purchase the car of the new line, just introduced this year, even if it comes from such a respectable manufacturer as Toyota. The same in software industry - we have unlimited trust and greatest respect to such CRM makers as Seibel - but I guess we have to admit - companies like this had to be pioneers on the market and had to create the market, being a little bit premature, however savvy in the long term market prediction.

Microsoft seems to be allowing the enthusiasts to create the market niche and then move in with its own or purchased and beefed up solution. In the case of MS CRM it seems to be from ground up MS development and very excellent fit to Microsoft Business Solutions business strategy. Microsoft CRM application conception in our opinion was substantial simplification in CRM functionality and making IT group to support it, by deploying all the recent Microsoft technologies.

Bullets to emphasize:

1. Microsoft CRM is for MCSE / Microsoft oriented IT departments - Microsoft CRM would be be-loved system for IT specialists. If you are MCSE+I - CRM will recruit all your MS Exchange, Active Directory, MS SQL Server, Windows domain security, Windows 2003 Server, Web publishing and HTML knowledge and experience. This is completely opposite to earlier Apple Computer believe - that computer systems should be easy in service and completely intuitive. MS CRM is kind of intuitive for end user, but not for its administrator.

2. Microsoft CRM - is not CRM - but rather simplified CRM - if you do remember old days whitepapers about CRM in general, or even it's predecessor - Lotus Notes/Domino - these papers were full of predictions about the future and were written for top level company executives, not for regular computer specialists. This was probably why so high percentage of CRM sales failed in implementations. Microsoft CRM has the highest ever rate of successful implementations, because it is not a CRM, but rather popularized version of it - it just does the job - as cheap and reliable car.

3. Transportation Companies - about 30% of our clients in the States are transportation and freight forwarding companies. This actually proves the hypothesis that MS CRM is very simple solution - these companies usually do not have extra money to spend on their computer system, but need the solution for its sales people to instantly see the cargos, plus have simple customization, allowing them to integrate with legacy system.

4. Movement down to small and tiny companies - this is completely new trend for CRM market. We know the examples when 5 employees companies make a decision to implement and have surprising success in Microsoft CRM implementation.

Happy implementing!

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving clients in Chicago, California, Colorado, Texas, New York, Georgia and Florida, Canada, UK, Australia and having locations in multiple states and internationally (http://www.albaspectrum.com/ ) You can reach Andrew at 1-630-961-5918 or 1-866-528-0577. He is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

---

MORE RESOURCES:

Microsoft to unveil new mobile services and software - MarketWatch

Geekzone

Microsoft to unveil new mobile services and software MarketWatch - 2 hours ago The services will be announced at the 3GSM World Congress in Barcelona, where Microsoft will show off Windows Mobile 6, a new version of its software for ... Microsoft unveils new mobile software The Age Microsoft reveals new Windows Mobile 6 Smartphone software Maktoob Business (press release) Microsoft Reveals New Windows Mobile 6 Smartphone Software ... FinanzNachrichten.de Wireless Design & Development Asia - I4U all 122 news articles

IBM Wants to Wipe Out Microsoft’s Software from Business Desktops - Playfuls.com

Playfuls.com

IBM Wants to Wipe Out Microsoft’s Software from Business Desktops Playfuls.com, Romania - 1 hour ago Yesterday, IT giant IBM unveiled its plans to reduce costs of managing Apple or Linux desktops, by offering a new open source software system for business ... IBM software makes mixed networks viable Macworld UK IBM aims to lower cost of using Linux, Apple PCs Expressindia.com IBM Rolls Out Desktop Bundle Red Herring all 22 news articles

Atex, the World's Leading Developer of Software Solutions for the ... - Canada NewsWire (press release)

Atex, the World's Leading Developer of Software Solutions for the ... Canada NewsWire (press release), Canada - 5 hours ago 12 /CNW/ - Atex (www.atex.com), the world's leading developer of software solutions for the media industry, has today announced that it has acquired Mactive ... Atex, the World's Leading Developer of Software Solutions for the ... Yahoo! News (press release) all 10 news articles

Microsoft hears sound of competitors breaking old software ... - The News Journal

Microsoft hears sound of competitors breaking old software ... The News Journal, DE - 3 hours ago 30 launch of the consumer versions of Microsoft's flagship software may be among the last of its kind -- a product sold for a flat fee in a shrink-wrapped ...

Global Demand for New Leadership & Organizational Development ... - PR Web (press release)

Global Demand for New Leadership & Organizational Development ... PR Web (press release), WA - 4 hours ago The animation software combines the GROW coaching process with four animated video movies. Instead of traditional coaching techniques the process combines ...

Cranes Software net rises 67.94% in Dec`06 qtr - Myiris.com

Cranes Software net rises 67.94% in Dec`06 qtr Myiris.com, India - 1 hour ago Cranes Software (Q, N,C,F)* International has reported a rise of 67.94% in net profits to Rs 264.61 million for the quarter ended December 2006 as compared ... Cranes Software to utilise Rs 2172.60 mn Myiris.com all 2 news articles

CSR Launches Superior GPS Software for Seamless Mobile Positioning ... - DMN Newswire (press release)

CSR Launches Superior GPS Software for Seamless Mobile Positioning ... DMN Newswire (press release), CA - 2 hours ago CSR's GPS solution is software-based and requires no further hardware beyond a RF front-end, hence the E5000 requires less than half the power and ...

Japan's Renesas to work with Nokia on software for cell phones ... - Forbes

Japan's Renesas to work with Nokia on software for cell phones ... Forbes, NY - 10 hours ago The Finnish firm will make its S60 platform software compatible with the Japanese semiconductor manufacturer's SH-Mobile system chips, which are currently ... Nokia Builds on Vision of Mobilizing the Internet to Transform ... Yahoo! News (press release) S60 Brings Nokia and T-Mobile Closer TMCnet all 10 news articles

• Planner's software helps cut big events down to size - Indianapolis Star

• Planner's software helps cut big events down to size Indianapolis Star, IN - 4 hours ago The Registration System is Web-based software that helps corporations and specialized event-planning firms coordinate tours and events of all sizes. ...

Software industry grows by 30% - Nhan Dan

Software industry grows by 30% Nhan Dan, Vietnam - 3 hours ago The software industry in 2006 generated US $300 million in revenue, up 30% year-on-year, in which exports accounted for US $90 million , reported the ... RELATED ARTICLES Screenshots Vista Windows Features Additionally, Vista will include many other new features.Aero Vista will include a completely re-designed user interface, code-named Aero. Corel WordPerfect 7 Macro Programming Example Case study: A secretary using Corel WordPerfect 7 is often required to carry out calculations and insert the values into invoices or other documents.She does this by entering calculations into either a real calculator and transcribing the answer, or the Microsoft calculator and copying then pasting the result into the document. RSS: Get Notified When Your Favorite Websites Are Updated RSS (Really Simple Syndication) is a way for a site to publish it's updates. RSS readers can read these notifications and display a listing of the updates to you, the user. 5 Time-Saving Tips in Microsoft Word Whether you have used Microsoft Word for years, have just switched from WordPerfect or are new to word processing, try these easy steps to save time and simplify your work in Word:Turn off Personalized Menus and ToolbarsAlthough it is a default, Personalized Menus and Toolbars is a terrible "feature" which limits your initial view to select toolbar buttons and menu commands. Do you only have one row of toolbars at the top of the screen? When you click on a menu, does it expand only after a few seconds? If so, you will save yourself a lot of frustration by turning off this personalized display:1. The End of Spyware? The US House of Representatives has recently passed the "Spy Act" - or to give it its full title - the Securely Protect Yourself Against Cyber Trespass Act. This aims to prevent software companies from installing spyware on users PCs without their knowledge, and anyone found guilty of breaching the act faces a fine of up to $3 million. Bill of Lading - Custom Reporting for Microsoft Great Plains - Overview for Consultant Bill of Lading is required report for Logistics and Freight Forwarding companies. If you are looking at Freight Forwarding software, targeted to automate transportation business - Bill of Lading with multiple custom forms should be present there. Linux - Keyboard Or Mouse Just stress testing one of the latest Linux distributions. Been testing it for about two months. XML Parser and Their Types XML parser is a software module to read documents and a means to provide access to their content. XML parser generates a structured tree to return the results to the browser. Microsoft CRM Implementation - US Market Lessons Microsoft CRM is CRM answer from Microsoft Business Solutions. If you compare it to other traditional CRM applications, such as Siebel - you will see that Microsoft CRM does use all the resent Microsoft technologies, that means that Microsoft targets its CRM to Windows market exclusively, plus this means that Microsoft CRM is more difficult in its installation. Device Driver Basics Most people understand that the "hardware" part of their computer is the real physical parts, like the keyboard, mouse, modem, hard drive and so on. They understand that the "software" is computer bits stored on the hard drive, CD-ROM, or other storage media. An Easy Way to Develop JAVA Enterprise Applications Research bears that less than 70 percent of development projects are actually completed, and more than half come in late and over budget. AlachiSoft TierDeveloper is a Rapid Application Development tool that helps Software Developers do better, more creative, and useful work by reducing redundant hand coding. Snort for Network IDS What is Snort?Snort is an open source network intrusion detection system (NIDS) that can audit network traffic in real-time. Snort is a packet sniffer, a packet logger, and a network intrusion detection system. An Easy Way to Deal with Email Viruses and Worms If you feel intimidated when someone tries to teach you something new on the computer, this article is for you!In the course of my career, I've worked with many people who I knew were smart but were convinced that they couldn't learn how to do new things on a computer. At some point, they'd convinced themselves that they weren't one of those "computer people". Blind CC (Bcc): Master Its Use When E-Mailing If you use Microsoft Outlook (or similar applications) for e-mailing, then you are familiar with the fields at the top of a new mail message, right? Of course, in the "To.. Pros and Cons of Using FREE Software in Your Business Itâ??s easy to understand why you might be drawn to the allure of free software. After all, it is free and free is always a good price to pay. SyncUp - A File/Folder Synchronizer For Windows SyncUp, a file synchronizer is designed to assist the home and advanced users. The product has a simple and familiar windows explorer type interface for easy file handling. Behave, Word, Behave! If you copy something from a Web site or elsewhere.. 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. OLAP, An Alternative Technology Over Spreadsheets Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average" companies are not confident that their forecasts and reports are accurate and reliable'In a recent study, 81% of FD's cited that their highest priority is the accuracy of revenue and earnings forecasts while 63% complained of inadequate budgeting and forecasting systems .The modern FD is coming under increasing pressure from all sides to produce more robust, meaningful and accurate financial information. 5 Easy File Management Tips in Microsoft Word How many steps does it take you to locate and open your Word documents? Try these tricks to streamline how you find and open the files you use most often:Opening DocumentsWith a variety of choices, how do you open a file? Here are the standards plus several keyboard shortcuts:? File > Open? Open toolbar button (usually 2nd from the left on the Standard toolbar)? [Ctrl] + O? [Ctrl] + F12? [Ctrl] + [Alt] + F2Selecting More Than One FileOnce you are in the Open dialog box, select more than one file to open:? To select nonadjacent files in the Open dialog box, click one file, and then hold down [Ctrl] and click each additional file.? To select adjacent files in the Open dialog box, click the first file in the sequence, and then hold down [Shift] and click the last file.

Microsoft Great Plains Integration with Microsoft Access - Overview for Developer

Software Information

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! help@albaspectrum.com



Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, New York, Florida, Georgia, Minnesota, Oregon, Arizona, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.




--------------------------------------------------------------------------------
MORE RESOURCES:

Satyam Opens Software Centre in China - SDA Asia Magazine


India Infoline.com Satyam Opens Software Centre in China
SDA Asia Magazine, Singapore - 5 hours ago
India’s Satyam Computer Services, a software services exporter, has opened in a software centre in China. This move is an attempt to cut costs. ...
Satyam opens software center in China International Herald Tribune
India’s Satyam builds huge software centre in China Blogger News Network
Satyam opens new software centre in China Daily Times
Times of Oman
all 181 news articles



Microsoft to release next generation phone software - China Post


Playfuls.com Microsoft to release next generation phone software
China Post, Taiwan - 12 hours ago
The company pledged that the new software would render e-mails and other documents much as they appear on desktop computers. The software also will have ...
Microsoft unleashes the latest in Wireless Software The Money Times
all 206 news articles



HP Rolls Out Storage Gear, Software - CIO India

HP Rolls Out Storage Gear, Software
CIO India, India - 2 hours ago
Called EVA File Services, the software lets customers virtualize their storage into a single pool of storage that can be managed centrally. ...



Tibco to Present at Merrill Lynch Internet, Software and Services ... - PR Newswire (press release)

Tibco to Present at Merrill Lynch Internet, Software and Services ...
PR Newswire (press release), NY - 10 hours ago
TIBCO Software Inc. provides enterprise software that helps companies achieve service-oriented architecture (SOA) and business process management (BPM) ...
Tibco to Present at Merrill Lynch Internet, Software and Services ... PR Newswire (press release)
Sybase CEO to Present at Merrill Lynch Internet, Software ... PR Newswire (press release)
Sybase CEO to Present at Merrill Lynch Internet, Software ... Yahoo! News (press release)
Business Wire (press release) - PR Newswire (press release)
all 14 news articles



Double-Take Software sees profit in Q4 - Washington Business Journal

Double-Take Software sees profit in Q4
Washington Business Journal, DC - 3 hours ago
The Southborough, Mass., storage software company (Nasdaq: DBTK) said it earned $1.7 million in the quarter ended Dec. 31, compared to a loss of $2.6 ...
Double-Take Software sees profit in Q4 Bizjournals.com
Double-Take Software Turns To Profit In Q4, Sees Q1 EPS Above ... Trading Markets
all 7 news articles



Online Casino And Poker Room To Use CryptoLogic Software - UK Casino Times

Online Casino And Poker Room To Use CryptoLogic Software
UK Casino Times, UK - 10 hours ago
CryptoLogic Inc., a leading software developer to the global online casino gaming market, has announced an exclusive three-year licensing contract to ...
Cryptologic Sells Online Casino Software To Holland Casino Casino Gambling Web
CryptoLogic sells online gambling software to Dutch casino operator Canada.com
Dutch Government-Owned Internet Casino and Poker Room to Use ... CCNMatthews (press release)
all 12 news articles



Is HP Serious About Its Software Business This Time? - InformationWeek

Is HP Serious About Its Software Business This Time?
InformationWeek, NY - 10 hours ago
In Boston last week, 2400 Hewlett-Packard software salespeople braved the frigid weather for a boot camp of education and training. ...
Who Will Hewlett-Packard Acquire Next? Intelligent Enterprise
all 3 news articles



RSA Conference 2007: Core Security says third-party software is ... - SC Magazine

RSA Conference 2007: Core Security says third-party software is ...
SC Magazine, UK - 18 hours ago
"To enable customers to take full advantage of Vista’s new security mechanisms, independent software vendors must be diligent in updating their products. ...



Revelation Software is Proud to Announce a Free Three-Day Training ... - PR Web (press release)

Revelation Software is Proud to Announce a Free Three-Day Training ...
PR Web (press release), WA - 7 hours ago
Founded in 1982, Revelation Software delivers a suite of application development tools and companion services that take full advantage of leading network ...



New Boomerang Data Recovery Software Supports Windows Vista - PR Web (press release)


PR Web (press release) New Boomerang Data Recovery Software Supports Windows Vista
PR Web (press release), WA - 7 hours ago
Boomerang Data Recovery Software quickly and efficiently recovers data lost to all due to all types of scenarios, including virus and file deletion, ...



RELATED ARTICLES
--------------------------------------------------------------------------------
Rapid Application Development - Is it Really a Need of Today?
Rapid Application Development (RAD) is a software development methodology. In this competitive world, software product delivery time should be as little as it can be.
--------------------------------------------------------------------------------
Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really "kill" Quark? Adobe has been saying "it will" for the last six years or so, but it hasn't happened.
--------------------------------------------------------------------------------
Anti-Virus Software
Anti-virus software is used to find, remove or fix files that are infected with computer viruses. Most anti-virus companies release weekly updates of their databases to help keep you safe.
--------------------------------------------------------------------------------
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 system1. Computer platform independence.
--------------------------------------------------------------------------------
Benefits of Integrating Online Chat Software with CRM
Customer Relationship Management (CRM) is a strategy and processes used to learn more about customers' needs and behaviors in order to develop stronger relationships with them. CRM applications are traditionally developed as client-server software.
--------------------------------------------------------------------------------
How to Evaluate Staffing Software
If you are in the market for new staffing software, I suspect that one of the most daunting of tasks will be to sift through the many vendors that are now servicing the staffing industry.You will find many very qualified companies with good staffing software products.
--------------------------------------------------------------------------------
Does Microsoft have any real competition?
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory S. Diehl In a word, yes.
--------------------------------------------------------------------------------
Ukraine: a Prospective Player on the World Software Outsourcing Market
The destruction of the Soviet Union about 15 years ago, made a huge country with a great level of IT science divided into small bricks. Nowadays, despite Russia's expansion into the world software development market, Ukraine keeps playing an important role here too.
--------------------------------------------------------------------------------
Microsoft CRM Customization Secrets - Second Edition
This article is for advanced Microsoft CRM SDK C# developers. It describes the technique of direct SQL programming, when SDK doesn't have the functionality to do the job.
--------------------------------------------------------------------------------
Intro to UNIX Shells
A UNIX Shell is in simplest terms, a command line interpreter, that takes the users input and gives it to the Kernel. If you are familiar with DOS, you will remember the 'command.
--------------------------------------------------------------------------------
An Easy Way to Develop JAVA Enterprise Applications
Research bears that less than 70 percent of development projects are actually completed, and more than half come in late and over budget. AlachiSoft TierDeveloper is a Rapid Application Development tool that helps Software Developers do better, more creative, and useful work by reducing redundant hand coding.
--------------------------------------------------------------------------------
Microsoft Great Plains SOP: Sales Order Processing
Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized).Great Plains Sales Order Processing (SOP) module forms a third of the core Inventory and Order Processing part of Great Plains.
--------------------------------------------------------------------------------
Why Stick With Email Clients Like Outlook?
Trying to figure out a stream in banning one email client or another is no easy job. As soon as somebody rises up saying Outlook is bad, somebody else comes saying it's good and the other one is bad.
--------------------------------------------------------------------------------
Microsoft Great Plains: Customization Upgrade & Recovery - Visual Studio VB 6.0
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has very long, about 12 years customization & integration history. In earlier 1990th - the customization tool was mostly Great Plains Dexterity, later on when Great Plains was successfully moved to MS SQL Server 6.
--------------------------------------------------------------------------------
Spyware Statistics -- Whats New in May 2005?
Although statistics often is blamed for various deadly sins -- from being biased to being inaccurate -- there is nothing left to those who are anyhow connected with IT but to keep up with fresh data. Since spyware is literally ubiquitous, nobody who owns or uses a PC can say that it is none of his business.
--------------------------------------------------------------------------------
Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization - Overview
In the case when you represent mid-size or mid-size-to-large business, it is not a surprise that you have to do ERP selection and switch to new technologies, doing your own research. If you a trying to stay with Microsoft technologies and try Microsoft Business Solutions products: Microsoft Great Plains, Microsoft Navision, Solomon, Axapta with integration to Microsoft CRM, you should know the history of Great Plains Software and Navision partners over the last 10 years.
--------------------------------------------------------------------------------
Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon
Bad News - the Threat is Bigger than it SeemedHow recently it was - when even many journalists thought that spyware gathers mostly information to be used for targeted advertising. Definitions like "spyware, a.
--------------------------------------------------------------------------------
How a Bug Challenges to a Software Professional
It is really interesting that a bug can create problem for a learned person even the bug is not alive. One day my one friend was working and a bug created much problem.
--------------------------------------------------------------------------------
IBM Lotus Domino or Microsoft Exchange?
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for many years between two main leaders in collaboration solutions - IBM and Microsoft. Whether the choice of a platform influences the ordinary user? The both of software giants put efforts to improve working conveniences for end Internet users.
--------------------------------------------------------------------------------
The Truth: Netzero 3G
We've all seen the ads on TV for Netzero 3G. You know the ones, "speeds so fast you sworn it was broadband" Well if your using it, you may not think it really is.
--------------------------------------------------------------------------------

Microsoft Great Plains Implementation - Overview for IT Director/Controller

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 classes to 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! help@albaspectrum.com
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

MORE RESOURCES:
HP Expands Software Portfolio with Acquisition of Bristol Technology - Internet Ad Sales (press release)
HP Expands Software Portfolio with Acquisition of Bristol Technology
Internet Ad Sales (press release), Sweden - 3 hours ago
“For the first time, customers will have a single software vendor that enables them to manage end-to-end business transactions, beginning with end-users all ...
HP Buying Danbury Tech Firm Hartford Courant
HP to acquire Bristol Technology, enhance software portfolio eChannelLine
HP to bulk up software group with Bristol buy ZDNet Asia
all 56 news articles

Microsoft: Don't be evil; drop lawsuit against software "pirate" - American Chronicle

BBC News
Microsoft: Don't be evil; drop lawsuit against software "pirate"
American Chronicle, CA - 13 hours ago
Reports say that the teacher was using school computers which had installed copies of unlicensed Microsoft software on them. Microsoft feels this is an ...
Putin, Gorby Petition Gates Red Herring
Microsoft: Not behind Russia piracy case BusinessWeek
Gorby Asks Gates For Mercy in Software Snafu KNX1070
all 144 news articles

Bytemobile and Opera Software Partner - Wireless Developer Network (press release)
Bytemobile and Opera Software Partner
Wireless Developer Network (press release) - 1 hour ago
Mountain View, Calif. and Oslo, Norway, February 6, 2007 Bytemobile, Inc. and Opera Software ASA today announced a joint development and marketing agreement ...
Bytemobile, Opera Software sign joint agreement Telecom Paper (subscription)
Bytemobile and Opera Software partner HULIQ
Bytemobile and Opera Software partner to deliver open Internet ... Assodigitale
Yahoo! News (press release) - PR Newswire (press release)
all 27 news articles

EMC to acquire Indian security software company - Computerworld
EFYTimes
EMC to acquire Indian security software company
Computerworld, MA - 2 hours ago
Valyd's software will be brought into RSA, the security division of EMC that was set up last year to integrate products from its acquisition of RSA Security ...
EMC to Acquire Indian Security Software Co. CIO
EMC Corp acquires Valyd Software Andhra Cafe
EMC Division Acquires Valyd Software EFYTimes
MarketWatch
all 19 news articles

HP Rolls Out Storage Gear, Software - PC World
ITBusiness.ca
HP Rolls Out Storage Gear, Software
PC World - 2 hours ago
Called EVA File Services, the software lets customers virtualize their storage into a single pool of storage that can be managed centrally. ...
Storage environments easier to manage with new HP Consolidation ... Prdomain Business Register (press release)
all 18 news articles

Absolute Software soars after inking deal with Dell - Globe and Mail
Computing News
Absolute Software soars after inking deal with Dell
Globe and Mail, Canada - 9 hours ago
A deal to have its theft-recovery software installed on Dell Inc. notebook computers pushed shares of Absolute Software Corp. up 25 per cent yesterday. ...
Absolute Software lands major deal with Dell Vancouver Sun (subscription)
Absolute Software shares jump 25% Montreal Gazette (subscription)
Dell To Bundle Laptop 'Lojack' Software CRN Australia
Reuters
all 31 news articles

Smart Students Save Big Bucks on Software - Derby Daily Reporter
Derby Daily Reporter
Smart Students Save Big Bucks on Software
Derby Daily Reporter, KS - 2 hours ago
With the professional software and training programs he's purchased from Academic Superstore, Owen is developing his design skills and says "I plan to apply ...

Nokia brings advanced developer benefits for S60 software - SymbianOne (press release)

Nokia brings advanced developer benefits for S60 software
SymbianOne (press release), Canada - 3 hours ago
Open C libraries are part of the S60 3rd Edition Feature Pack 2 and will be integrated into the publicly available software development kits. ...
CommVault CEO to Address Investors at the 2007 Merrill Lynch ... - Earthtimes.org
CommVault CEO to Address Investors at the 2007 Merrill Lynch ...
Earthtimes.org - 2 hours ago
... today announced that CEO Bob Hammer will address investors at the 2007 Merrill Lynch Internet, Software and Services Conference in New York City on ...

CommVault CEO to Address Investors at the 2007 Merrill Lynch ... PR Newswire (press release)
CheckFree to Participate in Merrill Lynch Internet, Software ... Earthtimes.org
CheckFree to Participate in Merrill Lynch Internet, Software ... PR Newswire (press release)
MCADCafe (press release) - dBusinessNews Triangle (press release)
all 12 news articles

SteelWorks(TM) Appliance Management Software to Incorporate ... - Yahoo! News (press release)
SteelWorks(TM) Appliance Management Software to Incorporate ...
Yahoo! News (press release) - 2 hours ago
The agreement calls for SteelCloud to incorporate FarStone's disaster recovery software into SteelCloud's SteelWorks(TM) Appliance Management Software. ...
SteelWorks(TM) Appliance Management Software to Incorporate ... PR Newswire (press release)
all 4 news articles

RELATED ARTICLES

COSMIC: A Small Improvement on the Symons Method
The COSMIC FP (function point) software quality metric, is no longer 'proposed' but an actual system in use and internationally recognised, whereas MarkII, like other older systems, is not recognised anywhere, and, even in the UK is in decline if not actually dormant, so this debate is already over.Historically, from my limited understanding of the situation, it seems that originally there were upwards of 35 variants of function point style metrics until the ISO developed criteria for a acceptable solution, ISO 14143: Parts 1 to 5 (1995-2002):The COSMIC group reviewed existing functional size measurement methods, namely the work done in the late 80's by Charles Symons in the UK.

Keep Your Software Simple! A Review of EditPlus
I like my software simple. If it's too complex or difficult to figure out, I don't use it.

Free Software for Newbies and Web Developers
Here is some free software tools to help you build your own websites and create web products.Learning new skills is not difficult.

ERP Remote Support: Microsoft Great Plains Analysis - Pluses & Minuses
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions Great Plains serves midsize and corporate clients as ERP system in the following countries and regions: USA, Canada, Mexico and Latin America, Brazil (where MBS actually promotes Navision and has GP for multinational corporations), Saudi Arabia, OAE, Egypt and the rest of Middle East, South Africa, Nigeria and the whole African continent, U.K.

What Stands Behind The Software Description?
With thousands of web pages added to the Net every day, it's getting more and more frustrating both to submit the information to the attention of those, who are interested in it and to find the information one needs.The problem is even aggravated with the fact that customers become more exigent to the products they are offered.

Microsoft Great Plains international implementation - USA / Mexico - overview for consultant
Microsoft Business Solutions Great Plains was purchased from Great Plains Software and Great Plains Software itself had strong international marketing plans and campaigns. If we look back to 1990th - we'll see that GPS had Multilanguage support and Great Plains Dynamics / Dynamics C/S+ was localized and translated into multiple languages, including Spanish.

Protect Your Computer...and Your Business!
We all take the computer for granted. I mean, all we have to do is switch it on and it's ready to go.

Groupware: What Works the Way Businesses Do?
GroupwareThe internet is full of 1.5 million to 7 million indexed pages of groupware packages available on the market today.

Lotus Notes Domino and Web: Application Development - Tips for Programmers Beginning with Domino version R4 it has integration with the Web, and the server itself becomes a HTTP-server. The next releases of Domino Web-server add new functionality (for example servlet managers, supported JVM versions upgrade, etc).

Free Preventive Maintenance Software
While several preventive maintenance software manufacturers offer free trials for their products before charging a fee, some companies offer their products for free. Free preventive maintenance software is rare, and is sometimes less thorough than software that must be purchased, but it can be a good solution for a new or struggling business.

Healthcare Preventive Maintenance Software
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can benefit greatly if up to date CMMS software is used. Healthcare CMMS programs will help with the maintenance of the building, alerting workers when items such as automatic doors, light fixtures, and plumbing structures are due for checkups.

Fundraising Software - How Can That Help Me?
Fundraising software lets you connect with donors in a way that is unlike any communication you've ever had before. You can diversify your fund raising efforts with software and manage all of your day-to-day activities.

Microsoft Great Plains, Navision, Axapta - Selection Considerations
During the years of our consulting practice, which comes back to East Europe in mid 1990th and then continues in the USA, Brazil, New Zealand, Australia, Oceania, Germany, Canada - we would like to orient you - business owner, IT director or software programmer. Selection process can take several months and you may end up with non-Microsoft solution.

Spyware, Adware, etc. -- Terms and Common Sense
When reading an article where some term is used often, it is useful to make sure the author of the article and you mean the same. Not surprisingly for those who still remember English lessons at school, every noun ending with "ware" is a mixture of objects having something in common--usually used for similar purposes.

Microsoft CRM Integration With Microsoft Office Documents - Overview For System Integrator
Microsoft CRM is CRM application, maintained and supported by Microsoft Business Solutions. Microsoft CRM utilizes majority of the Microsoft technologies: Windows Active Directory, SQL Server, MS Exchange, BizTalk (integration with MS Great Plains, and soon with Navision), Message Queuing, .

Microsoft Great Plains Payroll Module Customization Scenarios
It is now common thing when large corporation selects mid-market ERP or so-called standard functionality MRP solution as its corporate accounting system. Microsoft Business Solutions Great Plains is very good candidate.

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL
Microsoft bought Navision, Denmark based software development company, along with Great Plains Software. Now Microsoft Business Solutions offers following ERP applications: Navision (former Navision Attain), Microsoft Great Plains (former Great Plains Dynamics/eEnterprise), Solomon, Axapta.

Microsoft Great Plains: Large Scale Implementation
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM are coming up to satisfy ERP needs for large corporation, including multinationals. In this article we will be describing Microsoft Great Plains as the MRP platform, fitting to multiple industries and business niches: aerospace, defense, textile, pharmaceutical, healthcare, constructions, mining, services, distributions & logistics, wholesale & retail, public sector, chemicals, oil & gas, finance, brokerage, etc.

Microsoft CRM for Large Corporation - Security
Microsoft Business Solutions CRM proved to be reliable solution in the whole spectrum of industries and market niches: transportation & logistics, education, recruiting & placement, supply chain management, pharmaceutical, oil & gas, aerospace & defense, manufacturing, wholesale & retail. When corporation is looking into CRM application to choose from - one of the fist questions is security.

Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector - Future Directions
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management) from now on can work in tandem. Microsoft CRM Lotus Notes Domino connector from Alba Spectrum Technologies provides seamless messaging in MS CRM through Domino.

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

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.0

Is 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 version

What 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 few

Third 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 data

Do 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! help@albaspectrum.com


Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Colorado, Kansas, Minnesota, Texas, New York, Washington, Georgia and Florida and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

MORE RESOURCES:
Microsoft: Don't be evil; drop lawsuit against software "pirate" - American Chronicle


BBC News

Microsoft: Don't be evil; drop lawsuit against software "pirate"
American Chronicle, CA - 12 hours ago
Reports say that the teacher was using school computers which had installed copies of unlicensed Microsoft software on them. Microsoft feels this is an ...
Microsoft: Not Behind Russia Piracy Case Forbes
all 143 news articles



EMC to acquire Indian security software company - Computerworld


EFYTimes

EMC to acquire Indian security software company
Computerworld, MA - 2 hours ago
Valyd's software will be brought into RSA, the security division of EMC that was set up last year to integrate products from its acquisition of RSA Security ...
EMC to Acquire Indian Security Software Co. CIO
EMC Corp acquires Valyd Software Andhra Cafe
EMC Division Acquires Valyd Software EFYTimes
MarketWatch - Economic Times
all 19 news articles



Bytemobile and Opera Software Partner - Wireless Developer Network (press release)

Bytemobile and Opera Software Partner
Wireless Developer Network (press release) - 56 minutes ago
Mountain View, Calif. and Oslo, Norway, February 6, 2007 Bytemobile, Inc. and Opera Software ASA today announced a joint development and marketing agreement ...
Bytemobile, Opera Software sign joint agreement Telecom Paper (subscription)
Bytemobile and Opera Software Partner to Deliver Open Internet ... Yahoo! News (press release)
Bytemobile and Opera Software Partner to Deliver Open Internet ... PR Newswire (press release)
PR Newswire UK (press release)
all 26 news articles


HP Rolls Out Storage Gear, Software - PC World

ITBusiness.ca

HP Rolls Out Storage Gear, Software
PC World - 2 hours ago
Called EVA File Services, the software lets customers virtualize their storage into a single pool of storage that can be managed centrally. ...
Storage environments easier to manage with new HP Consolidation ... Prdomain Business Register (press release)
all 18 news articles


Absolute Software soars after deal with Dell - Globe and Mail

Computing News

Absolute Software soars after deal with Dell
Globe and Mail, Canada - 14 hours ago
A deal to have its theft-recovery software installed on Dell Inc. notebook computers pushed shares of Absolute Software Corp. up 25 per cent Tuesday. ...
Absolute Software shares jump 25% Montreal Gazette (subscription)
Absolute Software lands major deal with Dell Vancouver Sun (subscription)
Dell To Bundle Laptop 'Lojack' Software CRN Australia
Reuters - CRN
all 31 news articles


Smart Students Save Big Bucks on Software - Stuttgart Daily Leader

Stuttgart Daily Leader

Smart Students Save Big Bucks on Software
Stuttgart Daily Leader, AR - 4 hours ago
With the professional software and training programs he's purchased from Academic Superstore, Owen is developing his design skills and says "I plan to apply ...


CommVault CEO to Address Investors at the 2007 Merrill Lynch ... - Earthtimes.org

CommVault CEO to Address Investors at the 2007 Merrill Lynch ...
Earthtimes.org - 2 hours ago
... today announced that CEO Bob Hammer will address investors at the 2007 Merrill Lynch Internet, Software and Services Conference in New York City on ...
CommVault CEO to Address Investors at the 2007 Merrill Lynch ... PR Newswire (press release)
CheckFree to Participate in Merrill Lynch Internet, Software ... Earthtimes.org
CheckFree to Participate in Merrill Lynch Internet, Software ... PR Newswire (press release)
MCADCafe (press release) - dBusinessNews Triangle (press release)
all 12 news articles


SteelWorks(TM) Appliance Management Software to Incorporate ... - Yahoo! News (press release)

SteelWorks(TM) Appliance Management Software to Incorporate ...
Yahoo! News (press release) - 2 hours ago
The agreement calls for SteelCloud to incorporate FarStone's disaster recovery software into SteelCloud's SteelWorks(TM) Appliance Management Software. ...

Nokia Brings Advanced Developer Benefits for S60 Software - Yahoo! News (press release)

Nokia Brings Advanced Developer Benefits for S60 Software
Yahoo! News (press release) - 10 hours ago
Open C libraries are part of the S60 3rd Edition Feature Pack 2 and will be integrated into the publicly available software development kits. ...

'Govt eyes townships for software, services' - Financial Express

CXOToday.com

'Govt eyes townships for software, services'
Financial Express, India - 3 hours ago
MUMBAI, FEBRUARY 7: The Prime Minister's Office (PMO) has mooted the formation of integrated townships for the software and related services sector, ...
Incentive package for semiconductor manufacturing approved Telugu Portal
all 10 news articles