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 > Tutorials > Setting Up Hotsheets

Setting Up Hotsheets 

Hotsheet Processing with Margin Master

The following is an explanation of the proper Hotsheet procedure when processing retail changes through Margin Master.
 
Eliminating Hotsheets?

The simple truth is that there is so much critical information contained in Hotsheet updates that the
Hotsheet process cannot GO AWAY completely! What changes is how we process the information
that we receive from Hotsheets. Of all the information that is in Hotsheets, the only thing that
should not immediately be updated in your POS System is retail pricing. This means Order Multiple
Changes, Vendor Changes, Descriptions Changes, and so on, need to be processed - and your
system will continue to be updated with this information in the same manner you have done it in the
past.

After Margin Master

We want to say it again, HOTSHEETS DO NOT GO AWAY! With Margin Master, we are simply going
to change how we use them. Ultimately, we want to eliminate the retail review portion of the Hotsheet procedure. Once in place, Hotsheets will become a 100% automated process requiring zero user intervention. The Activant System has settings that allow you to apply all Hotsheet changes - except for retails changes. There is no longer a need to log retail changes to the review process, because we will be handling ALL price changes through Margin Master.
Once the Hotsheet process is automated, we will immediately free up the time spent on the review
process. True, Margin Master takes some time, but once past the initial work of creating a pricing
strategy and getting it implemented, the entire process from start to finish using Margin Master
should take less than 1 hour per month. In addition to getting some time back, accuracy will
dramatically improve, and the ability to make intelligent pricing decisions is all in front of us with
Margin Master.

In a Nutshell

Now that we are using Margin Master to maintain our retails, we no longer need to use our
Hotsheets to maintain retails. We do, however, still need to rely on our Hotsheets to keep costs,
OM, UPC Codes, and Descriptions up to date.
To do this, maintain your normal Hotsheet download schedule. Going forward, when
bringing down your Hotsheets, simply run an RPC report for option C to update cost. All areas of
Hotsheets, except retail changes, will be updated at this time. You can then run a second RPC for
option X, which will clear all of your Hotsheet records out of IPC. 

To Add the Two RPC Files to the Hotsheets Queue:
 
  • Open the RPC file in the launch bar.
  • Set the settings to spool, option C to update cost,, and make sure the store number matches the store you are working with.  
  • You will then want to click on the F7 (queue) button at the top of the RPC screen.
  • This will bring up a screen with the store number, queue name and comment space. 
  • Click ok.  This will add this RPC file to your Hotsheet queue.  When asked to close the RPC, choose no because we need to add the second RPC.

To Add the Second RPC File.
 
  • You will want to change the option tabe from C (to update cost), to the X (to delete out of the IPC).
  • In the from/to tab, you will want to put 00000 and ZZZZZ in the prime vendor area.
  • Then make sure your store number is still correct and click the F7 (queue) button again.
  • Choose the same Hotsheets queue as before and click ok. 
Now the next time your Hotsheets queue is run, it will automatically update the cost and then delete those Hotsheets ouf of the IPC; so you don't have to worry about them.

Please contact one of our support representatives with any questions you may have.



  

 
Article Details
Created:5/7/2009 3:37:57 PM
Modified:5/22/2009 10:57:02 AM
Author:smayhew
Views:284

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 |