MSI Central Warehouse Module™

Add-on package for M2000

The Central Warehouse Module is designed as an add-on option to the MSI M2000 Distribution System™ program. The Central Warehouse Module is designed to manage the purchasing, distribution and reporting requirements of chain stores for chains consisting of ninety-nine (99) stores or less running the MSI Music Retailer™ software at the stores.

The MSI Music Retailer™ performs all the inventory control, Point-Of-Sale cash transactions, direct purchasing, receiving and management reporting functions for the individual stores. During the POS fuctions at the store level, data is collected into that store's daily sales activity file. These activity files would be transmitted via modem or diskette to the Central Warehouse for processing. These files update the transaction tables at the warehouse reflecting the sales activity and stock information pertaining to the stores.

Utilizing the daily downloaded data from the stores, the warehouse will be able to print daily sales report showing the shift activity at the stores, sales by department, sales by music type as well as the cash transactions report. These reports can be printed per store or for the entire chain.

These daily transaction files will also create a demand file for the replenishment of inventory for the stores. The MSI Central Warehouse Module™ would allow the fulfillment of this replenishment from the warehouse stock. Any demand not fulfilled from this stock would then be available to be placed on purchase orders for fulfillment from the warehouse's vendors.

During the buildings of the replenishment orders, the following data would be available to assist in the decision process for the orders: the stores in-stock quantity (as of the last update from the store), the demand quantity, in-transit quantity (stock shipped from the warehouse, but not received at the store yet), on-order, and the period sales history (week-to-date, month-to-date, year-to-date). Shipments received at the warehouse, based upon the generated purchase orders, are allocatable to the stores at the time of scanning in the receiving. Once the receiving is done, picking sheets and packing slips can be generated for the inventory being sent to each store. This data can also be placed on diskettes for processing at the store(s) in order to facilitate quick receiving.

When shipments are generated at the warehouse, the quantities shipped is recorded in the in-transit column on the purchasing screen. When confirmation is received from that store that the inventory arrived (via the daily transaction files), this inventory shifts over to the quantity on hand for that store.

Best Seller Report function for printing the top sellers per store, or for the entire chain are also included in the Central Warehouse Module. In addition, No Activity Reports for the individual stores or the entire chain would assist in processing RA's from the stores to the warehouse, or from the warehouse to the Vendors.