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 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
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 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 ...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 ...MI Liquor Management Report Bad Item
The state of Michigan puts a file on the internet with state minimum pricing for all liquor items sold in the state. The problem is that they don't do a very good job on this file. Specifically they will have more than one record for an item. What ...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. ...