Data Management

Data Management Extension

Let the data management extension make importing and maintaining your items easy.

The Data Management module allows you to manipulate data in 'bulk' rather than at each individual stock card level. This manipulation includes the controlled data import from suppliers catalogues.

Choose from the following six import and maintenance options:

Data Management Extension

Item Import (Multiple Suppliers) - Items can be maintained and an import option is available. This allows a bulk import (from an excel spreadsheet) and updating of items for Multiple Suppliers within the RMS database.

Item Import (Single Supplier) - Items can be maintained and an import option is available. This allows a bulk import (from an excel spreadsheet) and updating of items for a Single Supplier within the RMS database.

Item Import - Single Supplier Mapping Columns

Item Maintenance - Item attributes can be maintained in a spreadsheet style format, which allows mass changes to be made to the items. These changes can then be saved to the RMS database.

Item Maintenance

Item Migration - Allows the importing of new items only into RMS. This works in exactly the same way as 'Item Import Multiple Single Supplier' but the difference is that you do not have to specify a supplier for which you are importing the items for.

Item Price Maintenance - Allows storage of up to 30 prices against every item. These stored prices can then be applied to the item price or sale price by using the formula feature of Data Management. Sale dates and schedules can also be administered.

Item Price Maintenance

Supplier Import & Maintenance - Supplier details can be imported and maintained and saved to the RMS Database.

Supplier Import & Maintenance

Supplier Catalogue Imports

  • Retain supplier spreadsheet format for ease of import.
  • No more concern over format of supplier catalogues.
  • Create Suppliers products in seconds, with validation.

The Ability to Export to Excel Spreadsheet for Further Reporting

  • Full Validity Checking - Highlighting & explaining "faulty" data.
  • Copy & Paste Function across all rows .
  • Formula creation to "mark up" products, including price rounding.

Fully Integrated

The Data Management extension works at both Store and Headquarters level, also it is fully compatible with other RMSynergy extensions.

  • Easy to use Excel Look & Feel.
  • Wizards allow quick setup of "Data Views"
  • Each operator can have their own unique view.
  • Show what data YOU want to see - Show/Hide Columns.
  • Data selection via Supplier, Department, Category and Attributes.

Microsoft Dynamics Retail Management System Brochure

Requires Adobe Acrobat
Reader to view

Download Now

Integrated Style

Do you want your EPOS to promote your company's image?

Then check out the new Odysse EPOS Hardware - Innovative and design oriented hardware to compliment your hard working software

Website design by Web Industry Ltd. Copyright © 2004–2010 RMS

RMS Home Contact RMS