Phone Support
(989) 896-8000
Email Support
support@retailersoft.com
Company Website
http://www.retailersoft.com
  Knowledgebase Search:      Show Home Page  
 Welcome
 Installation
    System Requirements
    Downloading Margin Master
    OCX Errors
    Upgrading Margin Master
 Vendor Specific
    Ace Hardware
       Processing Ace Data
    Do it Best
       Processing Do It Best Data
    True Value
    Mitre 10
    TransActPOS
    Handy Hardware
    Benjamin Moore
    Orgill
    Resurg Group
    RivalWatch
       Processing RivalWatch Data
    Hillman
 Using the Program
    Implementation
    What is a Pricing Strategy
    Developing a Price Strategy
    Custom Group Screen
    Commonly Used Margin Master Terms
    Short Cut Tips
    Exporting Sku Level Exceptions
    Importing Sku Level Exceptions
    Backing up the Database File
    Backing up the Price Strategy File
    View Options Screen
    SKU Sequence Screen
    SKU Pricing Strategy Screen
    Sku Detail Screen
    Restore Back Up Data
    Rounding Options Screen
    Registration Wizard Page
    Quick Find Page
    Profit Analyzer
    Print Screen
    Price Strategy Management Screen
    Options Screen
    Margin Master Screen
    FTP Transfer Utility Screen
    One Click Statistics
    Custom Import
    Adding Steps To A Strategy
    Transfering A Strategy
    Moving Margin Master 
    Targeted Backdoor Margin Worksheet
    Changing Steps In A Strategy
 POS System Specific
    Activant
       Errors
          Reasons SKU's Do Not Import
          Cannot Connect to FTP
          I Can't Download Margin Master Updates
       Tutorials
          Activant Step By Step
          Exporting Price Changes
          Importing  Exporting Automated Queue
          Recovering Archived Exports
          Setting Up Hotsheets
          Importing Date of Last Price Change
       Installation
       FAQ
          Getting Started
          FTP Access
          Creating the Queue
          Processing Data Reports
          Department and Class Names
          Creating the Import Macro
          Exporting Pricing BACK to E4W
    Paladin
       Importing Data to MM
       Exporting MM Data
    Substruct Systems
    RockSolid
       Displaying Margin Master Option
       Exporting to MM/Server PC
       Importing From MM/Server PC
       Printing Labels
       Exporting to MM/NonServer PC
       Importing from MM/NonServer PC
       Importing in to Margin Master
    TransActPOS
       Importing and Exporting
    SpruceWare
       Importing Price Changes
    SpruceWare.net
       Import/Export
    Cruise
       Cruise and Margin Master
    Advantage
       Exporting to Margin Master
    J3 Point of Sale
    Falcon
       CyberQuery
 FAQ
    Sales FAQ
    Installation FAQ
 Specifications
    POS Data Integration
       Store Data Layout
       Vendor Data Layout
       Integrated Data Mapping

Home > POS System Specific > Activant > FAQ > Creating the Queue

Creating the Queue 

What is a queue?

To simplify the process of getting store data from the Eagle System into Margin Master, users should set up a queue that will allow them to quickly execute the required reports, in a singe step.  Don’t worry about the formalities of queues; just understand that a queue is simply a grouping of reports – that can all be run at the same time.

There are two reports that must be run for each store that will be using Margin Master.  The RIV report is an inventory valuation report that lists information like current price, and quantities on hand.  The RIH report is a sales history report that shows monthly sales details for each Sku.

Obviously, these reports are the source of the information needed by Margin Master to effectively help a store manage and manipulate their pricing strategy.  Follow the steps below to correctly set up the RIV and RIH reports, and to save them to the queue.


Setup the RIV Report

  • Open the Eagle Browser.
  • Enter Username and Password.
  • At the Launch Bar near the top of the screen, enter RIV and press enter.
  • The RIV Report Screen will open.  Make the following selections by selecting the appropriate Tab on the left side of the screen.
  • On the Print Tab – Select Print to “S” to Send the report to the Spooler
  • On the Options Tab – Select the Cost to Use (Typically Replacement)
  • On the From/To Tab – Enter the Store Number you are running the report for. 
  • Set the Subtotals option to “N”.
  • After making the above selections, hit F7, or click on the QUEUE button at the top of the Report Screen. Enter the Name “MMASTER”
  • Keep the Store Number at the default value.
  • In comment, type Margin Master Reports
  • Click Ok.
  • You will see a message stating that the report has been added to position #1 in the Queue.
  • Repeat the RIV creation for each store in the organization – adding each report to the queue.
  • Press the ESC Key to Exit the RIV Report Screen

Setup the RIH Report

  • From the Eagle Browser as above, Enter RIH in the Launch Bar and press Enter.
  • The RIH Report Screen will open.  Make the following selections by selecting the appropriate Tab on the left side of the screen:
  • On the Print Tab – Select Print to “S” to Send the report to the Spooler.
  • On the From/To Tab – Enter the Store Number you are running the report for. 
  • Set the Subtotals option to “N”.
  • After making the above selections, hit F7, or click on the QUEUE button at the top of the Report Screen.
  • Select the Name “MMASTER” from the dropdown list.
  • Keep the Store Number at the default value.
  • Click Ok.
  • You will see a message stating that the report has been added to position #2 in the Queue.  (Unless Multiple RIV Files were created in a multi store environment.)
  • Repeat the RIH creation for each store in the organization – adding each report to the queue.
  • Press the ESC Key to Exit the RIH Report Screen

Setup the RDE Report

  • From the Eagle Browser as above, Enter RDE in the Launch Bar and press Enter.
  • The RDE Report Screen will open.  Make the following selections by selecting the appropriate Tab on the left side of the screen:
  • On the Print Tab – Select Print to “S” to Send the report to the Spooler.
  • On the Options Tab – Enter N as the Report Format. 
  • On the From-To Tab – Remove the Store Number to include ALL Stores.
  • After making the above selections, hit F7, or click on the QUEUE button at the top of the Report Screen.
  • Select the Name “MMASTER” from the dropdown list.
  • Keep the Store Number at the default value.
  • Click Ok.
  • You will see a message stating that the report has been added to position #3 in the Queue.  (Unless Multiple RIV & RIH Files were created in a multi store environment.)
  • Press the ESC Key to Exit the RDE Report Screen

Setup the RCL Report

  • From the Eagle Browser as above, Enter RCL in the Launch Bar and press Enter.
  • The RCL Report Screen will open.  Make the following selections by selecting the appropriate Tab on the left side of the screen:
  • On the Print Tab – Select Print to “S” to Send the report to the Spooler.
  • On the Options Tab – Enter N as the Report Format. 
  • On the From-To Tab – Remove the Store Number to include ALL Stores.
  • After making the above selections, hit F7, or click on the QUEUE button at the top of the Report Screen.
  • Select the Name “MMASTER” from the dropdown list.
  • Keep the Store Number at the default value.
  • Click Ok.
  • You will see a message stating that the report has been added to position #4 in the Queue.  (Unless Multiple RIV & RIH Files were created in a multi store environment.)
  • Press the ESC Key to Exit the RCL Report Screen

Once you have created this Queue, you can now and in the future execute all of the Margin Master reports quickly by going into Network Access and running the Queue rather than going into Eagle and running each report individually.

Note:  In a multi-store environment, you will have one QUE that will contain ALL reports for ALL stores.  Each report must be created and saved to the queue separately. 


Running the MMASTER Queue

After successfully creating the MMASTER queue above, you are now ready to initiate or execute the queue.  From the Eagle Browser, open Network Access, and login with the proper username and password.  At the Function Screen, type in MMASTER and press Enter.  A small box will appear in the center of the screen with the cursor blinking in Run Time.  Hit N, and the run time will change from End-of-Day to Now.  Hit the F3 key to submit the queue, and the reports will begin running. 

The reports will take varying amounts of time from system to system.  Multi-store organizations obviously have more reports that need to run.  The length of time isn’t important.  The important thing is that these reports MUST finish running BEFORE we can import them into Margin Master.  Since we have more work to do, we can get the rest of our work completed – then we will verify that the reports have finished processing.


  

 
Article Details
Created:4/30/2009 10:59:31 PM
Modified:5/28/2009 2:39:08 PM
Author:bgreen
Views:291

Options
 Print Article
 Bookmark Article
 Link to this Article

Related Articles
  
To add links, place the cursor in the box above and then click 'Link Page' on the toolbar.

File Attachments
  
To upload and insert attachments, place the cursor in the box above and then click 'Document Manager' on the toolbar.

 Copyright © 2003 - 2009 RetailerSoft, Inc.  | All rights reserved |