Problem: When I run my usage summary report I have no percentage costs.
Solution: You must put your weekly sales into the Daily Sales Summary Window. Click Daily Sales (button on far left) and select the closing day of the week (usually Sunday) enter the sales total under CAID. Click Save.
Problem: When I run the usage summary the sales amount next to the Category name says “Sales not defined”
Solution: This is because you have not “detailed” your sales in the Daily Sales window, to have beer costs analyzed against beer sales you will need to make sure that you detail what the beer and other sales were. Click Daily Sales Summary, once you have entered your sales (or simply entered the total gross sales amount in the CAID field, click the detail button next to the Gross sales number and detail the sales.
Problem: My usage summary shows double ideal cost of sales.
Solution: Click on sales mix window and see if you have saved your sales mix twice. Go to Sales mix pick window, highlight the duplicate sales mix and click Delete. Then click Save. Another problem can be that you have imported regular days of sales and then perhaps run one of the sales mix reports from your POS for half a month or so. Open each sales mix and see if there is one of the sales mixes that is extremely high in number.
Problem: Usage Summary shows no Ideal usage.
Solution: Have you saved your sales mix for the date period? Or you may have saved the sales mix on a date outside the dates range of the reports. Double check the dates and if incorrect, click on sales mix and right click on the dates. Open the Sales Mix window and right click on the date to change.
Problem: My inventory amount for a certain inventory item is completely out of whack.
Solution: This is usually caused when an inventory item’s “case unit of measure" was entered incorrectly. Or you changed the units for the case size, if perhaps you had the case size entered incorrectly and then made purchases for that case size the program was tracking the wrong size. To revalue the inventory, this is not problem as you can adjust the inventory (even to the same counted amount) and it will be recalculated. For invoices you may have to re-date the invoice back a few years and then re-enter.
Problem: My usage summary is showing negative numbers for the inventory value
Solution: This can happen when you have chosen to only count key items for your inventory. Optimum Control takes whatever amount it has been tracking as the proper count for the non key items and until you set the closing inventory amounts for the non key items they may be incorrect. If you are running only Key items in your counts then ONLY key items should be run in the usage summary report. When you do a full count then run usage summary with all items.