Microsoft RMS Data Import

The RMS Data Tool is used to import items and purchase orders including the following fields:

  • Item Lookup Code
  • Description
  • Department
  • Category
  • Price
  • Cost
  • Extended Description
  • Sub Description 1
  • Sub Description 2
  • Sub Description 3
  • Price A
  • Price B
  • Price C
  • MSRP
  • Unit Of Measure
  • Weight
  • Restock Level
  • Reorder Point
  • Picture Name
  • Inactive
  • Supplier
  • Reorder Number
  • Supplier Cost
  • Master Pack Quantity
  • Minimum Order
  • Supplier Tax Rate
  • UPC (Alias 1)
  • Alias 2
  • Alias 3
  • Quantity Ordered (Purchase Orders)

Items are updated based on Item Lookup Code, UPC, or supplier number. New items are created when they do not already exist in the database.


RMS Data Import Tool Data Source Screen

RMS Data Import Tool Data Source Screen
RMS Data Import Tool Data Mapping Screens

RMS Data Import Tool Data Mapping Screens RMS Data Import Tool Data Mapping Screens RMS Data Import Tool Data Mapping Screens
RMS Data Import Tool Save Settings Screen

RMS Data Import Tool Save Settings Screen
RMS Data Import Tool Apply Changes Screen

RMS Data Import Tool Apply Changes Screen

Contact

80 Eastern Boulevard Suite 2

Glastonbury, CT 06033

Sales toll free: 1-888-816-8002

Support toll free: 1-866-703-2267

Sales local: (860) 781-7136

Support local: (860) 781-6379

Fax: 1-860-397-6344