Microsoft Dynamics GP (formerly Great Plains) Financial Export

Overview

Microsoft Dynamics GP (formerly Great Plains) is a business management solution including financial and accounting software that can export a Financial Extract that can then be imported into RMS.

This Financial Interface is available for Accrual Accounting properties using RMS.

Important! The Financial Interface to Microsoft Dynamics GP is not included in the base RMS subscription. Contact RMS Sales for pricing information.

Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.

Financial Interface Mapping

Log a Support Ticket for the financial interface to be set to 'Microsoft Great Plains'.

In the Side Menu of RMS, go to Setup > Accounting > Financial Interface.

1. Navigate to the 'Mapping' tab.
2. Enter the GL Account Codes & Descriptions in the Advances Ledger section.
3. Enter the GL Account Codes & Descriptions in the Guest Ledger section.
4. Enter the GL Account Codes & Descriptions in the City Ledger section.
5. Select 'Save' and navigate to the 'Receipts' tab.
6. Enter the GL Account Codes & Descriptions for the Receipt Types.
7. Select 'Save' and navigate to the 'Credit Cards' tab.
8. Enter the GL Account Codes & Descriptions for the Card Types.
9. Select 'Save'.
10. Optional: Navigate to the 'Statistics' tab.
    • Enter the Microsoft Dynamics GP GL Account Codes & Descriptions for the RMS Statistics.
11. Save/Exit.

Visual Guide

Log a Support Ticket for the financial interface to be set to 'Microsoft Great Plains'.

In the Side Menu of RMS, go to Setup > Accounting > Financial Interface.

1. Navigate to the 'Mapping' tab.
    
2. Enter the GL Account Codes & Descriptions in the Advances Ledger section.
    
3. Enter the GL Account Codes & Descriptions in the Guest Ledger section.
    
4. Enter the GL Account Codes & Descriptions in the City Ledger section.
    
5. Select 'Save' and navigate to the 'Receipts' tab.
    
6. Enter the GL Account Codes & Descriptions for the Receipt Types.
    
7. Select 'Save' and navigate to the 'Credit Cards' tab.
    
8. Enter the GL Account Codes & Descriptions for the Card Types.
    
9. Select 'Save'.
    
10. Optional: Navigate to the 'Statistics' tab.
     
    • Enter the Microsoft Dynamics GP GL Account Codes & Descriptions for the RMS Statistics.
       
11. Select 'Save/Exit' to store the changes made.
     

Financial Interface Utility

In the Side Menu of RMS, go to Utilities > Financial Interface.

1. Select the Date.
2. Select a File Format.
3. Select 'Export File'.
    

Visual Guide

In the Side Menu of RMS, go to Utilities > Financial Interface.

1. Select the Date.
    
2. Select a File Format.
    
3. Select 'Export File'.