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 Mapping Screens



RMS Data Import Tool Save Settings Screen

RMS Data Import Tool Apply Changes Screen
