Skip to main content
Sign in Submit a Ticket

How can we help?

Microsoft Dynamics GP

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.Annotated screenshot of the Financial Interface - Microsoft Great Plains screen in RMS showing the Mapping section with ledger account codes for Advances, Guest and City Ledgers, with an arrow highlighting the Mapping menu item
     
  2. Enter the GL Account Codes & Descriptions in the Advances Ledger section.Annotated screenshot of the Financial Interface - Microsoft Great Plains Mapping screen in RMS showing the Advances Ledger section, with an arrow highlighting the Description field for Plus New Credits
     
  3. Enter the GL Account Codes & Descriptions in the Guest Ledger section.Annotated screenshot of the Financial Interface - Microsoft Great Plains Mapping screen in RMS showing the Guest Ledger section, with an arrow highlighting the Description field for Plus New Reservation Charges
     
  4. Enter the GL Account Codes & Descriptions in the City Ledger section.Annotated screenshot of the Financial Interface - Microsoft Great Plains Mapping screen in RMS showing the City Ledger section, with an arrow highlighting the Description field for Plus New Balance
     
  5. Select 'Save' and navigate to the 'Receipts' tab.Annotated screenshot of the Financial Interface - Microsoft Great Plains Mapping screen in RMS with an arrow highlighting the Save button in the toolbar
     
  6. Enter the GL Account Codes & Descriptions for the Receipt Types.Annotated screenshot of the Financial Interface - Microsoft Great Plains screen in RMS showing the Receipts section with account codes for Cash, Cheque and Direct Credit, with an arrow highlighting the Receipts menu item
     
  7. Select 'Save' and navigate to the 'Credit Cards' tab.Annotated screenshot of the Financial Interface - Microsoft Great Plains Receipts screen in RMS with an arrow highlighting the Description field for the Cash receipt typeAnnotated screenshot of the Financial Interface - Microsoft Great Plains screen in RMS showing the Credit Card section with account codes for American Express, Mastercard and Visa for both Credit Card and EFTPOS, with an arrow highlighting the Credit Card menu item
     
  8. Enter the GL Account Codes & Descriptions for the Card Types.Annotated screenshot of the Financial Interface - Microsoft Great Plains Credit Card screen in RMS with an arrow highlighting the EFTPOS Code field for American Express
     
  9. Select 'Save'.Annotated screenshot of the Financial Interface - Microsoft Great Plains Credit Card screen in RMS with an arrow highlighting the Save button in the toolbar
     
  10. Optional: Navigate to the 'Statistics' tab.Annotated screenshot of the Financial Interface - Microsoft Great Plains screen in RMS showing the Statistics section with account codes for Out of Order, Total, No Show, Available and Occupied areas, with an arrow highlighting the Statistics menu item
     
    • Enter the Microsoft Dynamics GP GL Account Codes & Descriptions for the RMS Statistics.Annotated screenshot of the Financial Interface - Microsoft Great Plains Statistics screen in RMS with an arrow highlighting the Description field for Out of Order Areas
       
  11. Select 'Save/Exit' to store the changes made.Annotated screenshot of the Financial Interface - Microsoft Great Plains Statistics screen in RMS with an arrow highlighting the Save/Exit button in the toolbar
     

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.Annotated screenshot of the Microsoft Great Plains Financial Export screen in RMS showing the Report Options with the Date field set to 1 September 2020 and File Delimitation set to Tab Delimited, with an arrow highlighting the Date field
     
  2. Select a File Format.Annotated screenshot of the Microsoft Great Plains Financial Export screen in RMS showing the Report Options with an arrow highlighting the File Delimitation dropdown set to Tab Delimited
     
  3. Select 'Export File'.Annotated screenshot of the Microsoft Great Plains Financial Export screen in RMS showing the Report Options with an arrow highlighting the Export File button

 

 

Related to:

Was this article helpful?

We're sorry to hear this article was not helpful, please let us know why here, so we can make it better.

Thanks for the positive feedback! We'd love to hear more, let us know here.

Return to top

Related articles

Comments

0 comments

Please sign in to leave a comment.

Contact us