Navision (former Navision Attain), Microsoft Great Plains (former Great Plains Dynamics/eEnterprise), Solomon, Axapta. Microsoft bought Navision, Denmark based software development company, along with Great Plains Software. Using a familiar Microsoft Outlook®-style interface, Business Analytics presents this information to your desk top where easy to use analytical tools allow you to carry out targeted analysis that is tailored by you, for you. XBRL is an XML-based specification that uses accepted financial reporting standards and practices to export financial reports across all software and technologies, including the Internet. If you need to pull data out of the Navision database on a regular basis one of the other options is a better choice.
Our opinion is based on our Microsoft Business Solutions Great Plains, Microsoft CRM sales and marketing campaign to large businesses in the following industries. You should be ready to do presentation over the web session, and close the deal over the phone or skype. IT folks are doing their duties and searching on google, yahoo, msn, altavista. We believe that future ERP system sales will be mostly done to the specialists, not to the top and so, the selling strategy should be adjusted. Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http.
Navision (former Navision Attain), Microsoft Great Plains (former Great Plains Dynamics/eEnterprise), Solomon, Axapta. Microsoft bought Navision, Denmark based software development company, along with Great Plains Software. If you need to pull data out of the Navision database on a regular basis one of the other options is a better choice. Using a familiar Microsoft Outlook®-style interface, Business Analytics presents this information to your desk top where easy to use analytical tools allow you to carry out targeted analysis that is tailored by you, for you. I would recommend using this tool for occasional reporting requests only.
Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. Lotus could work in multiple hardware & OS platforms, such as Windows Server, AS/400, etc. It is US$3k basic pack, including 30 users and then $75 each additional user. The reason for this is simple - version 6. In Europe price is proportional in Euro.
MS CRM works in concert with MS Exchange, Windows Active Directory, SQL Server, BizTalk (integration with Great Plains and in the close future Navision. Considering conservative decision making - there is often the requirement of clear and complete audit to verify past decision making. MS CRM plays this role by automatic logging all the documentation and especially all the incoming and outgoing emails to/from clients. You need MS CRM Exchange connector customization. Pension Funds and Financial institutions.
If we don't use this directive - we can't pull the results from Navision tables - we will get errors, like this. TRACEON(8765) directive allows working with the data results of variable length returned by C/ODBC driver. Unexpected data length returned for the column. ProviderName='MSDASQL', TableName='[MSDASQL]', ColumnName='Ship_to_Filter', ExpectedLength='250', ReturnedLength='1'. Now we need to create small procedure for Sales data extraction.
This is special handler, inspecting document change status, transferred from MS CRM to document storage (SharePoint), and report Activity owner on the changes with home page notifications (User home page in MS CRM. User in turn can review the history of the document editing - who, when and where is the change. Modified version sores document in SharePoint Document Library (the required library is subject for setup by MS CRM system administrator) or keep it in MS CRM as is (for documents of minor importance. Standard unmodified CRM suggests you to store documents in the file system. From the moment of saving the document in SharePoint Document Library it is not stored in MS CRM - CRM will now store only the link/reference to the document.
Robert Horowitz is Certified Navision Specialist in Microsoft Business Solutions Partner Alba Spectrum Technologies - USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www. You should probably familiarize yourself with OPENROWSET statement in Transaction SQL. Now you are ready to create geterogeneus SQL View to link all your databases and have the data shown in one Crystal Report. If you are on C/SIDE DB - you create linked server to it via C/ODBC, then you create additional linked servers to your legacy DBs. If Navision sits in MS SQL - you create linked server to the third party database (Oracle, DB2, Unidata, Ingress, Sybase, Pervasive, Ctree, MS Access.
If you have a need in large scale data import, you can always have us help you with MS CRM SDK data conversion. Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally. Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http. Tools->Import and select contacts or leads. Here we will describe other option and possibilities.
Navision Software was purchased by Microsoft and now it is supported by Microsoft Business Solutions together with Microsoft Great Plains, Axapta, Solomon, Microsoft Retail Management System and Microsoft CRM. You can get infor and download it at http. To test the procedure you can give its name in MS SQL Query Analyzer - EXEC NavisionCustomers. Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[MSDASQL. ProviderName='MSDASQL', TableName='[MSDASQL]', ColumnName='Ship_to_Filter', ExpectedLength='250', ReturnedLength='1'.
Robert Horowitz is Certified Navision Specialist in Microsoft Business Solutions Partner. Do you plan to expose Navision data to other applications? - Navision has tools to expose the data from C/SIDE database (C/ODBC, C/FRONT), but in the case of SQL Server you certainly have standard Microsoft technologies in your disposition. Do you need OLAP/Datawarehousing? - then SQL Server is the way to go. It has built in Analytical Server with OLAP cube creation and Excel data pivoting. Alba Spectrum Technologies - USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www.
This allows you to revise and versionize document with automatic fax delivery to the addressees involved. Andrew is Lead Software Developer in Alba Spectrum Technologies - USA nationwide Oracle, Navision, Microsoft CRM, Microsoft Great Plains customization company, serving Chicago, California, Arizona, Colorado, Texas, Georgia, Florida, New York, Canada, Australia, UK, Russia, Europe and internationally ( http. All we have to do is - integrate one of the reliable solutions into Microsoft CRM. Let's look at the technical aspects of the integration. Fax software automation market is very mature and we don't have to re-invite the bicycle here.
Lotus workflow may work with integration to your ERP/Accounting application, such as Microsoft Great Plains, Navision, Axapta, however this is outside of the scope of this article. One of the popular requirements is the synchronization of Microsoft CRM Activities. This should allow users work on the same project sharing Lotus and MS CRM data space. This is typical Microsoft CRM SDK (to program MS CRM) and Lotus Java Agent programming from the side of Lotus. Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.
Andrew Karasev is Chief Technology Officer in Microsoft Business Solutions Partner. Alba Spectrum Technologies - USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www. It has built in Analytical Server with OLAP cube creation and Excel data pivoting. Do you plan to expose Navision data to other applications? - Navision has tools to expose the data from C/SIDE database (C/ODBC, C/FRONT), but in the case of SQL Server you certainly have standard Microsoft technologies in your disposition. Do you need OLAP/Datawarehousing? - if you use MS SQL Server - you are positioned better.
Because MS CRM is web application - it can be used by remote users and automate operations across the whole USA and even Worldwide. Net with MS CRM SDK and SQL queries to legacy database. This is usually made as small web application, created in Visual Studio. Usually MS CRM ties together existing legacy business systems and replaces large portion of them. Typical case - if you are freight forwarding client and have cargo tracking system - you should more likely have lookup from the MS CRM account screen to the customer current shipments statuses.
|
|