Microsoft CRM Integration With Microsoft Office Documents – Overview For System Integrator

From MediaWiki
Revision as of 04:56, 17 November 2018 by OdellFryman7 (talk | contribs) (Created page with "Recommended settings – targeting RMS Headquarters database (after daily transactions migration from Stores to Headquarter), however you could use linked SQL server to your St...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Recommended settings – targeting RMS Headquarters database (after daily transactions migration from Stores to Headquarter), however you could use linked SQL server to your Store Operation databases and pull daily transactions directly from there
Happy integrating! if you want us to do the job or use our product - give us a call 1-630-961-5918 or 1-866-528-0577! help@albaspectrum.com

ERP Historical Trend. Well, if you stake on Microsoft Business Solutions – you still might have legacy of products: IBM Lotus Notes Domino, Oracle Financials/Applications/E-Business Suite, SAP, PeopleSoft, JDEdwards, Accpac, Siebel, SalesLogix. You might need integration, data conversion, customization and heterogeneous reporting. Again – in our opinion you should consider budget offshore solution for these developers-time consuming projects

Pure Offshore vs. Local Consulting. Again – the choice is yours – in our opinion pure offshore is not the best option – offshore consultants and developers should be also experienced in serving clients face-to-face, this means – they should have local consulting practice in their local countries.

From Analysis to Workflow. The idea of Microsoft as we see it is to make it invisible for the user to judge – where is say, Microsoft CRM, Business Portal or where is Sharepoint. Sharepoint is the platform for workflow and document management, and being integrated into Business Portal it can compete with traditional workflow management tools, such as IBM Lotus Notes Domino.

Lovely Islands. If you are in Bermuda, In case you have just about any concerns concerning wherever and how you can work with Microsoft Store Promo Code, you are able to contact us in our web-site. Bahamas, Puerto Rico, Jamaica, Palau, Fiji, Microsoft Store Promo Code Tahiti – you are probably underserved and have to overpay to consultants flying from Miami, Manila, Paris, Chicago, NY, LA. The same should be told about USA/Canada rural communities

From technical side – integration is a set of SQL stored procedures and Great Plains Dexterity custom setup form. You can also schedule integration as SQL job to run overnight, looping through all your RMS stores

Lotus Notes/Domino remarks. Also we need to give mind set change advise to Lotus Notes/Domino switchers to MS CRM. Lotus is designed to incorporate files and documents (such as MS Word, Excel, Power Point, etc.) into its database – why it is efficient in Lotus – answer is simple – Lotus is not a relational database. At the same time MS SQL Server – MS CRM DB platform is perfectly relational. So – go ahead and make attachments, but do not try to make your CRM database be the repository of your documents. It is also possible to use Lotus as your documents repository and programmatically realize the links from MS CRM objects to documents, stored in Lotus Notes/Domino. Also it is possible to have Lotus/Domino playing the role of email server (instead of MS Exchange) – but this is outside of the scope.

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, .Net web services to name a few. There is market demand on the efficient integration of MS Office documents into Microsoft CRM. Let’s take a look at the options:

Attachment to MS CRM Notes. You may attach Office docs as file attachment to MS CRM Note. It is bullet-proof method, however you should be aware that it is not that simple for the user to attach files, especially web interface, which may work slow. The second drawback – you are actually copying document into MS SQL Server database and you may quickly increase its size and degrade efficiency.

Time Zones. Well – yes – you are right. Other countries are located in different time zones, especially Great Plains gurus in Philippines (remember Match Data Great Plains Project Accounting?). Philippines and India are almost 12 hours away from USA. However South America is about at the same time belt – Brazil, Argentina, Uruguay, Mexico – these are probably smaller clusters of offshore & BPO companies, but the advantage of time zone is obvious

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS) are originally developed by different software vendors, who had no idea that in the remote future (now) these two applications will be owned by Microsoft and will need to be tightly integrated. Current integration between the two is not an easy thing. At this time MBS has RMS integration on the General Ledger and Purchase Order level into Great Plains out of the box. This integration has some advancements in comparison to old product: QuickSell, but it is still GL and PO only. We do understand the need for midsize and large retail companies, structured as clubs and selling on account to their members to have more adequate integration when you can synchronize your Sales information and have robust Great Plains reporting.

Microsoft Office Information Bridge Framework for Microsoft CRM – this tool is sometimes misunderstood. It is the other way integration – from MS Office documents you can link to MS CRM objects (including proposals). This solution however works in the realm of MS CRM security model and requires the user, who opens MS office 365 personal for mac renewal monthly promo code document have MS CRM user id (and so – the user license)
You can always have us help you, give us a call: 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com