If you are looking for the integration between Microsoft Great Plains as ERP/accounting and retail management application for midsize chain of stores: Microsoft Retail Management System or MS RMS, then you should know your options. In this small article we will go beyond standard integration, which comes with GP
We will take a look at Alba Spectrum integration which allows you to import RMS transactions to Microsoft Dynamics GP either on AR or SOP transactions level
Technology. Integration uses SQL Stored Procedures to make integration speedy. It can handle tens of thousand transactions per day and more. Limitations to the transactional level are actually on Microsoft RMS side. It doesnt require eConnect, however it duplicates some eConnect logic, while dragging transactions from RMS Headquarters module
Custom Logic. In RMS you typically have custom logic, which goes beyond standard ERP application business processes: gift certificates, overtenders when you give cashier 10 dollars and get change, exchange when you return one item, pick another and settle the difference. You should have your requirements for business specific customization. In this case integration could be tailored
RMS integration with GP. In some cases you might need changes in GP be sent to RMS custom integration logic should be able to create different types of RMS worksheets, typically originated on HQ level. The examples could be: in RMS you create new customer which needs to be pushed to Great Plains, or in RMS you create new items to by translated into GP inventory module
New Items import into RMS. If you are receiving new inventory items on the daily basis, you might need automation, which should simply push items in RMS outside of RMS item creation Wizard. Good option is importing items to GP and then integrating them to RMS via custom logic with sophisticated price matrix, based on cost.
Alba Spectrum Group, http://www.albaspectrum.comhttp://firstname.lastname@example.org 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale