MI Liquor Management Summary

MI Liquor Management Summary

GLDS has created a tool called MI Liquor Management for stores to use to keep Liquor pricing updated in their systems. This document will describe how the MI Liquor Management program works.

MI Liquor Management is used inside of SMS Pro, and is used in conjunction with Item Maintenance. First open Item Maintenance [Price Only]. Next click the “MI Liquor” drop down menu at the top of the screen and select “MI Liquor Management”.

Your screen should now look something like this:

The main MI Liquor Management box that pops up is a summary window. This menu will show you a summary of the liquor items in your system. It will show you how many items are below state minimum, above state minimum, or at state minimum.

If you click the number “2” that you see in this picture that are below state minimum, it will pull up those two items in the browser window so you can easily adjust the pricing manually as needed. This works with all of the numbers you see in the Summary window.

The state minimum price is stored in the SRP field in the price window. 

The system compares the SRP field with the Regular Price field in the price window to determine if items are above or below state minimum pricing. (Older version of the MI Liquor Management program used the Instore price field for custom pricing. This method will no longer be used. If you have custom pricing, just use the Regular Price field from now on, and set the CP flag in the Status field to indicate custom pricing. More on this later)

This main summary page is intended to give you a quick snap shot of your liquor items in your system.

    • Related Articles

    • LOC SMS - Michigan Liquor Management

      GLDS has created a tool called MI Liquor Management for stores to use to keep Liquor pricing updated in their systems. This document will describe how the MI Liquor Management program works. MI Liquor Management is used inside of SMS Pro, and is used ...
    • MI Liquor Management Reports

      We have created a few custom liquor reports to help you easily see what's selling in the liquor department. The Liquor book is broken into sections such as vodka, gin, rum, and cordials. These sections of the liquor book are Categories in our system. ...
    • MI Liquor Management

      MI Liquor Management is a tool created by GLDS that helps you manage your liquor pricing. The state of Michigan publishes a file on the internet that includes all liquor items sold in the state of Michigan and their mandatory minimum pricing. Price ...
    • MI Liquor Management Search

      The MI Liquor Management program has a handy search tool built into it that searches the item database specifically for liquor related items. Click the "Search" button and a new window will pop up with some options. You can use this tool to quickly ...
    • MI Liquor Management Item Programming

      The MI Liquor Management program will automatically program all liquor item information for every liquor item in the state. This includes all of the information in the liquor book including, category, cost, vendor, and liquor code. The MI Liquor ...