Inventory Count Issues

 

Question: Why are my inventory amount incorrect?

Reason

Solution

The Item was counted using the wrong unit of measure.

This is usually caused when an inventory item’s purchasing unit of measure was entered incorrectly. The reporting unit of measure may also have been recently changed. Adjusting the inventory count using the proper unit of measure will correct the count amount.

A prep contains the incorrect quantity of an ingredient.

Open the I.R.M to find out which preps the item is included in. Correct the quantity of the item within the prep recipe and re-enable/re-summarize the inventory count sheet. Re-enable the inventory by clicking Delete then selecting No.

Counts are incorrect

99% of the time the inventory counts are just incorrect.  Double check counts before anything else.

Key Items vs All items

If using key item inventory, all other items will be automatically calculated by Optimum Control and if the amounts for some reason have gone below 0 (tied to a recipe with no purchases or proper inventory) then the recipe import could keep extracting below 0.  Make sure to do an all item inventory to correct (set to 0 if necessary)

 

 

Question: Why is it that my actual and ideal usage match for an item but there’s still a variance in value?

Reason

Solution

This is because the cost has been updated for an item without entering a purchase.

Click File|Preferences|Settings|Inventoryto change the inventory valuation to Last Cost. Adjust the inventory count by entering the same count amount and the value will be corrected to reflect the current case cost for the inventory item in question.

 

Question: Why is my inventory value for an item inaccurate?

Reason

Solution

The First in First Out (FIFO) function is calculating incorrectly.

Click Settings and choose Preferences and Inventory and select Last Cost. Revaluing the inventory is not a problem as you can adjust the inventory (even to the same counted amount) and it will be recalculated based on the current case size’s cost. For invoices, you may have to re-save the ones that include the item in question. You can determine which invoices the item has been included on by running an item activity report.