Microsoft Dynamics RMS

Drive growth, streamline operations, improve customer service, and centralize information

Tools

Connect your retail accounting systems with Microsoft Dynamics RMS

Microsoft Dynamics Retail Management System (RMS) delivers a complete point-of sale (POS) solution that integrates with a number of enterprise resource planning (ERP) and accounting applications, helping retailers connect information and processes, adapt to mid-market requirements, and drive a lower total cost of ownership (TCO).

Built on Microsoft SQL Server database technologies, Microsoft Dynamics RMS enables retailers to integrate data generated at stores across their retail chain with merchandising systems, warehouse systems, and other back-office enterprise systems or portals, including Microsoft Office SharePoint Server.

A number of add-on solutions from Microsoft partners are available for retailers using Microsoft Dynamics RMS with Microsoft Dynamics ERP applications or other providers. Your reselling partner can help you identify the best one to suit your business needs.

Integration with Microsoft Dynamics GP

Microsoft Dynamics RMS connects smoothly with Microsoft Dynamics GP, providing retailers with an end-to-end retail and financial management solution for managing a multistore network. Intuitive, automated set-up processes help eliminate the need to have an accountant on hand for the integration, helping you save time and money.

With Microsoft Dynamics GP and Microsoft Dynamics RMS, data can flow between applications used at store locations and those used in the back office at headquarters

With Microsoft Dynamics GP and Microsoft Dynamics RMS, data can flow between applications used at store locations and those used in the back office at headquarters.

Read more about Microsoft Dynamics RMS and Microsoft GP integration.

Integration with other Microsoft Dynamics solutions

Retailers can manage accounts receivable in Microsoft Dynamics Retail Management Systems Store Operations, then trade summary point-of-sale (POS) data with other Microsoft Dynamics business management solutions, including:

Integration with Intuit QuickBooks

Microsoft Dynamic RMS integrates with Intuit QuickBooks 2003 or later. Supported versions include QuickBooks Pro, QuickBooks Premier, QuickBooks Premier: Accountant Edition, QuickBooks Premier: Contractor Edition, and QuickBooks Enterprise Edition.

  • Summary data integration. After initial installation and setup, you can export your summary POS accounting data to the QuickBooks general ledger (GL), and also export closed purchase orders as QuickBooks bills. The information posted to the GL of QuickBooks includes department-level sales, cost of goods sold, commissions, taxes, and tenders received.

  • Chart of Accounts. Easily import the Chart of Accounts from QuickBooks into Microsoft Dynamics RMS. You can also import Payment Terms, Customers, Suppliers (Vendors), and Items from Microsoft Dynamics Retail Management System Headquarters if these pieces of data are defined in QuickBooks. The integration does not allow you to import Payment Terms, Customers, Suppliers (Vendors), and Items from Microsoft Dynamics RMS Store Operations to QuickBooks.

Defining your integration needs

You can take advantage of Microsoft Dynamics RMS integration with accounting and ERP solutions at any phase in your business life cycle. If you are not certain how to start evaluating your business software requirements, a Microsoft partner can help you establish a reliable roadmap for the business management infrastructure that's best for you. You will set goals and identify your business requirements. We can help you translate those requirements into practical business technology that can support and enhance the accomplishment of your objectives no matter how far you go.