|
|
| www.1001TopWords.com |
|
|
Microsoft Great Plains - Microsoft RMS Integration ? overview
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. There is the product on the market, which is integration on the Receivables Management and Purchase Order Processing level from RMS to Great Plains, written by Daniel Sionov and Andrew Karasev and maintained by the alliance between LightEdge Solutions (www.lightedge.com) and Alba Spectrum Technologies (www.albaspectrum.com). In Alba Spectrum Technologies we actually do coding and product tuning for specific client needs. This product allows you to map multiple RMS stores to one or multiple Great Plains companies. We usually have to tune it for specific needs of the customer, but in general words - it is based on SQL insert into statement and so can handle hundred thousands transactions per day - maximum of what RMS can handle. Integration is usually setup on RMS Headquarters database. However we can set it for Store Operations database. Overview of out-of-the-box Microsoft RMS integration. This integration is currently available for Great Plains version 7.5 and Microsoft RMS 1.2. MBS is in process of subcontracting Nodus Technologies to write new integration for version 8.0. The weak points of the out-of-the-box 7.5 integration are: 1. It is for integration into one Great Plains company only. If you have multiple stores as multiple companies in Great Plains - then you have to remember which batch should be posted into which Great Plains company. 2. It is on GL and Purchasing level only. So, if you have to reconcile checkbooks / Bank Reconciliation module in Great Plains - you can not do it with standard integration If you are developer you can end up with your own custom solution, we would like to give you directions. 1. Great Plains Integration Manager - if the sales volume is very low, say 100 transactions per day - then you can do data export from RMS and import it into Great Plains via 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. 2. eConnect ? You can create VB.Net application which will be pulling info from RMS and then uses eConnect to move it to Great Plains. eConnect is kind 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. 3. SQL Stored Procedures. The product we've mentioned above is collection of stored procs. Obviously you have unlimited control and possibilities with SQL queries. You need to know Retail Management System Headquarters and 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. RMS tables structure is self explanatory. 4. 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. 5. Great Plains Dexterity Custom Screens. You can create the window, which will have integration settings in it - RMS store ID matching GP Company database, etc. 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. 6. Modifier/VBA custom buttons on the existing screens - alternative to Dexterity is you are comfortable with VBA and ADO. Happy integrating! if you want us to do the job or use our product - give us a call 1-866-528-0577! help@albaspectrum.com About The Author Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM, Microsoft RMS customization company, based in Chicago, Arizona, Colorado, California, Texas, New York, Georgia, 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; akarasev@albaspectrum.com
|
|
|
|
RELATED ARTICLES
Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content It's no secret that software companies operate in a very competitive space where rivalry is increasingly fierce and where profit margins can be razor thin. New, smaller software companies are sprouting up each month and the leading software companies continually make strong advancements forward leveraging massive cash flow reserves. This cycle makes it difficult for the mid-sized software company to compete because (a) they don't typically have the cash flow necessary to take giant leaps forward in the industry and (b) because they need to continually move forward to stay ahead of the smaller software companies that are vying for their slot in the marketplace. Consequently, making the jump from an unknown to a mainstream brand can prove to be very difficult for the mid-sized software company. Things You Can Do With Windows XP! Did you ever give a thought to the number of things you can do with Windows XP? Take your own time and think... I hope you remember few basic and easy things if you are not new to Windows family. Check it out the following paragraph. 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. Basic Steps To Optimize Your Internet Security After seeing many people complain about their weak Internet security I decided to write down some things that will help you for your Internet security. Start Developing Your Own Software Learning how to program software seems like a daunting task fit only for the geeks and nerds who lock themselves away in dark rooms staring at their monitors for days on end as they pour over thick manuals written largely in zeros and ones. Fortunately the reality is that it's not as complicated to make basic applications as people may think. If it were, the majority of nerds wouldn't be doing it because the defining factor of our kind is an inherent laziness. Why do you think we like computers? The heaviest thing we have to lift is a monitor and that's done fairly irregularly and for a very short period of time. Putting Screensavers Under Control No matter how much you enjoy your favorite screensavers, sometimes they can be rather annoying. Don't like them interrupting your presentations? Hate them disturbing you watching movies? Look no further. This article will show you how to gain full control over your screensavers in no time. Cisco Certification: Introduction To ISDN, Part III Configuring PPP PAP Authentication Document Templates Give You The Perfect Framework For Your Documents When it comes to running an office, the SOHO entrepreneur has enough on his or her plate as it is. So if you find yourself in the unenviable position of regularly having to set aside your core competencies to handle tedious, repetitive administrative duties such as creating your business documents from scratch, then you need to consider the potential benefits offered by document templates. Causes of ERP Failures ERP is the acronym of Enterprise Resource Planning. Multi-module ERP software integrates business activities across various functional departments, from product planning, parts purchasing, inventory control, product distribution, to order tracking. ERP has transformed the way multi-billion dollar corporations conduct their businesses. Successful implementation of ERP systems could save tens of millions of dollars and increase employee satisfactions, customer satisfactions and sustain competitive advantages in every-changing marketplace. Corporate executives are often perplexed by the stories that how reputable corporations (Hershey Foods, etc.) have failed miserably and lost ten of millions of dollars in their ERP endures. Microsoft CRM Data Conversion FAQ Microsoft Business Solutions CRM data conversion deserves FAQ type of article, where IT people could get initial directions. Even if it seems as a trivial task, we would suggest you to think about these possible scenarios: objects mapping between your legacy CRM: GoldMine, ACT, Siebel, Lotus Notes Domino. When you think about MS CRM switch over ? do you think just to transfer master records: Leads, Contacts, Accounts, or you are thinking about historical activities: emails, faxes, calls, appointments, etc? 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. And the story goes on and on. Artificial Intelligence And Intuition The intuitive algorithm. Running a Program on a Remote Server Using SSH How do you run a program on a remote server using ssh? 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. Software Tools To Help Your Business Sell More Sales are all about leverage, because there is only so much you can do on your own. But, with the help of these simple tools, you can easily double, triple and quadruple your productiviting and make more sales. Is Your Small Business Ready For A CRM Software Solution? I have yet to see a business that, sometimes in spite of themselves, didn't benefit from implementing a Customer Relationship Management (CRM) or a simpler Contact Management software solution. 20 Extra Hours Per Week: What Would You Do? While I was in college, if you would have asked me what I would do if I had an extra 20 hours to spend in a week, the first thing I would have told you is that I would definitely NOT spend it studying. I actually would have gone down a long list of hobbies and activities I would like to do if I had the time. So when my co-workers asked me to find out what owners/managers of sign companies would do if they had an extra 20 hours per week, I was very interested in hearing the responses. What types of activities are sign shop owners doing with their spare time? Was there a common activity or hobby in the sign & graphics industry? Or would I hear several different responses? Inherent Dangers Of File Sharing Via The Internet. Cyberspace has opened up a new frontier with exciting possibilities of "File Sharing." We can explore any interest imaginable and research any topic of choice. We truly are global in reach with high speed internet usage at our disposal and a keyboard at our fingertips. We can share music, movies, games and even personal photographs. Benefits of Shareware Shareware has been fighting the stigma of being misunderstood for decades. While corporate software giants can no longer ignore the marketing potential of a trial version, small software startups are struggling with new listings and bandwidth costs. Businesses and individual consumers need to take a closer look at the benefits of taking advantage of shareware marketing. The concept of a trial version is not a new one. Consumer expectations, and the need for immediate satisfaction have spurned the industry to realize the need for instant software. The availability of file downloads in the Internet era, is spurning a revolution of purchasers who never leaving their homes or offices. As a result, the Internet has taken the proliferation of shareware to a new level. Free Software for Newbies and Web Developers Here is some free software tools to help you build your own websites and create web products.
|
| © Athifea Distribution LLC - 2013 |
