Tuesday, July 10, 2007

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino - overview

Microsoft Business Solutions Great Plains has substantial market share among horizontal and vertical clientele in the USA, Canada (including French version for Quebec/Montreal), UK, Australia, New Zealand, Spanish speaking Latin and Central America, South Africa and Middle East. Nowadays ERP can not stay as it is off-the-shelf product it requires integration with Legacy or newly implemented systems, such as CRM, Retail Management applications, custom in-house made business systems (transportation/cargo tracking, etc). The tendency is that if company uses Microsoft-driven computer park (Windows domain, SQL Servers, MS Exchange) the rest of the ERP/CRM applications are Windows-oriented. However you can have successful bridge between non-Microsoft ERP and Great Plains: Oracle, IBM Lotus Notes/Domino, DB2 or others), usually it involves Java/CORBA/EJB/JSP type of expertise.

Microsoft RMS-Great Plains integration. There are few options first one is to use standard integration, coming with MS RMS. It has Dexterity interface in Great Plains, does integration to single company at the time. Doesnt integration on SOP/AR level, however. Second option is to use integration, maintained by Alba Spectrum Technologies it integrates unlimited number of stores, SOP/AR/POP, posts through Bank Reconciliation module and so allows to track Check Books/Credit Card balances. This integration also has Dexterity interface for Stores-GP Companies mapping and could work as nightly or real time SQL Server routine

Microsoft CRM-Great Plains integration. This integration is maintained by Microsoft Business Solutions and allows you to synchronize SOP and Customers in Great Plains with Microsoft CRM Quotes and Orders. Microsoft CRM has open Microsoft CRM SDK and so you can customize and integrate Microsoft CRM at will, having C# or VB.Net in-house expertise. The above mentioned integration could be altered and tuned by programming MS BizTalk server (it can use either BizTalk runtime or regular license)

Microsoft Great Plains as Back office for eCommerce web-site. Here we need to mention interesting thing, The product, created and dedicated to eCommerce developers Great Plains eConnect is often considered as a bit expensive and licensing-restricting solution. If your company is ISV and implements eCommerce product, integrating to Great Plains you would rather prefer set of open and simple stored procedures, moving data to and retrieving from Microsoft Great Plains Sales Order Processing (SOP) module

Microsoft Great Plains integration with Oracle. Well you can do it either from Oracle or from MS SQL Server side in both cases you have linking tools and heterogeneous queries mechanisms

Microsoft Great Plains integration with Lotus Notes/Domino. If you want Great Plains documents lookup from Lotus you typically use ODBC connection to MS SQL Server. You need to know Great Plains tables structure (Tools->Resource Description->Tables in Great Plains) Good luck in upgrading 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, 1-630-961-5918! help@albaspectrum.com


The Most and Least Reliable Cars - How Reliable is Your Car

Over the last decade cars have become increasingly reliable. However, large variations in reliability performance do still exist, and reliability is certainly something that should be considered when purchasing a car and deciding whether a warranty is required. A warranty is a type of insurance policy, meaning that if a covered part suffers a mechanical or electrical failure resulting in a breakdown, the warranty will cover the cost of replacement parts and labour. Therefore there is full peace of mind as you know that you will never be left with a huge repair bill to pay.

Warranty Direct and Motoreasy are the two main providers of warranties in the UK. As a price guideline, a 4 year old Peugeot that has traveled 40,000 miles will cost 230 to cover for one year. However, most cars come with a 3 year warranty and if it doesnt come as standard then many retailers offer a warranty separately. When deciding whether to purchase a warranty separately you need to consider the reliability of your car.

Warranty Direct have gathered data from millions of pounds worth of claims every year to compile the Reliability Index, a complete guide to the reliability of cars on the road today. One interesting finding is that 25% of cars suffer mechanical failure at some point between its 4th and 5th year on the road, just as the manufacturers standard warranty expires. However, huge variations in reliability do exist, as illustrated by our five best and worst performers below.

Ford come in at number 5, with Suzuki and Honda at positions 4 and 3 respectively. Honda with its The Power of Dreams slogan appears to live up to its word with a highly reliable range of cars. Mazda comes in second place, with Skoda, perhaps surprisingly, the most reliable car make on the road today. It wasnt long ago that Skoda was ridiculed for being extremely unreliable and hard on the eye, but theyve worked intensively on the reliability of their cars. If youre concerned about being able to drive from one place to another at any time then consider purchasing a Skoda. Practical and exciting. Dont see that very often its certainly practical and is unlikely to let you down.

Moving on to the top 5 list car manufacturers dont want to be in, Jaguar comes in at number 5. Known more for its looks and performance rather than reliability, many people would see this as a fair trade-off. Land Rover comes in as the 4th most unreliable car. Derided as a car that is unpractical and unnecessary for city roads it also appears that it is unreliable. With the huge increase in taxes in the UK planned for high polluting vehicles a hard time could be in store for the Land Rover. Next up is Subaru, followed by the Jeep in second position. The jeep was really designed for off-road pursuits so perhaps it isnt surprising to see it struggling in the reliability stakes as they werent originally designed for the roads. Finally, the most unreliable car on the road today is Porsche. If a Porsche is your only mode of transport you may want to consider purchasing another more reliable car or certainly a warranty. Whilst it is a high-performance car Lexus have shown that you can be fast and reliable, as they came in as the 6th most reliable car make on the road.

Therefore if youre looking for a car purely to get you from one place to another consider purchasing a Skoda. If youre concerned about performance, speed, and looks then Lexus are certainly worth considering.


This page is powered by Blogger. Isn't yours?