Retail Hero's Top Import Utility

The Challenge:

Most of the inventory management operations fall into one of the following categories:

• Item creation and changing item’s properties (such as description, cost etc.)
• Changing item’s prices (such as putting items on sale)
• Transferring inventory in or out (between the stores or sending damaged inventory to the supplier) using transfer orders (TOs)
• Creating purchase orders (PO’s) based on certain criteria, i.e. such as according to the restock/reorder levels (min/max levels).

Physical inventory counts at the store or in warehouse. Some of the listed above operations (i.e. physical count, warehouse operations) require a mobile data collector (scanner) to be used in connection with RMS – to count the actual inventory and then transfer data into RMS.

The “Physical Count” functionality in RMS allows importing data file from a data collector (a standard text file: comma- or tab- delimited). However, a similar functionality is missing from RMS when it comes to TOs (RMS Transfer Orders) or POs (RMS Purchase Orders). But in some cases it is required.

E.g. if one of the RMS Stores in a chain is used as warehouse, a Transfer Order from warehouse to store may need to be populated from a data collector. In their turn, Purchase Orders sometimes are not created prior to the receiving but ordering is done manually and a Purchase Order is created “on fly” while receiving shipment from a supplier.

The Solution:

Retail Hero’s Top Import utility.

Features

Retail Hero’s Top Import Utility resolves these issues with the following features:

• Operates as a standalone application or may be configured to run from the Tools menu in RMS SO Manager
• Lists all orders currently available in RMS: Purchase Orders and Transfer Orders with types and statuses
• Imports into RMS a data collector file (comma- delimited) which contains two columns per line item lookup codes (SKUs) and quantity.
• Adds items from the data collector file to the RMS Purchase Order or RMS Transfer Order if they do not exist in the content 
• Adjusts the item quantities in the order according to the data collector file
• Verifies each imported item against the item’s supplier in RMS database (how it is setup in RMS) and alerts the operator if no match is found, If the SKU being imported is not found in RMS, allows the operator to create the item on-fly

Future enhancement will include the following functionality:

• Converting Purchase Orders into Transfer Orders and vice versa 
• Generating Purchase Orders and Transfer Orders based or restock/reorder levels
• Consolidating multiple Purchase Orders and Transfer Orders at the warehouse

Contact Retail Hero for demo or purchase.