If you are considering consolidating Microsoft Great Plains with ERP / accounting management and retail management applications (Microsoft Retail Management System or MS RMS), you need to know that option. This little article explains beyond the standard integration that comes with the GP. With integration with Alba Spectrum, you can import RMS transactions into Microsoft Dynamics GP at the AR or SOP transaction level
o Technology. Integration allows for quick integration using SQL stored procedures. It can handle tens of thousands of transactions per day. The transaction level limit is actually on the Microsoft RMS side. Although eConnect is not required, it duplicates some eConnect logic, but drags the transaction from the RMS Headquarters module
o Custom logic. RMS usually has custom logic beyond the standard ERP application business process. Gift Certificate, Overweight - When you pay tenants for $ 10, receive changes and exchanges - return items, return different items, and require requirements for business specific customization. In this case, the integration can be tailored
RMS integration with GP. In some cases, you may need to send GP changes to RMS. Custom integration logic should be able to create different types of RMS worksheets, usually created at HQ level. As an example, in RMS, create a new customer that needs to be pushed to Great Plains, or create a new item by translating it to GP stock module with RMS
o New items will be imported into RMS. If you receive new inventory items daily, you may need automation. If you need automation, you simply push the items outside of the RMS item creation wizard. A good option is to import items into the GP and integrate them into RMS using custom logic with a sophisticated price matrix based on cost.
